Math Functions > Arithmetic Functions


Divide

The Divide function divides all valid values in a time series or paired data set by a number, or divides the values in a data set by the values in one or more data sets of the same type.  For time series data, missing values are kept as missing.

 

When you are dividing data sets, times in the data sets need not match exactly.  Therefore, only values with coincident times will be divided.  Times in the primary time series data set that cannot be matched to times in the other data set result in missing values for those times.  Values in the data set(s) selected from the lower list form the divisor(s).   Values in the resultant data set are set to missing if there is a zero divisor. Missing values in the primary data set are kept as missing.  Data sets may be regular or irregular interval time series. 

Presently the Divide function does not allow the division of paired data by another data set.

 

To divide all values in the selected data set(s) by a number:

  1. Choose the Arithmetic tab of the Math Functions Screen and select the Divide operator.
  2. Select a data set to apply the function from the Selected Data Set pull-down list at the top of the screen or multiple data sets from the list in the lower portion of the screen.  If you include the data set selected in the top Selected Data Set, the operation on that set will only be done once.
  3. If the data set is paired data, use the Select Paired Data Curve list to select a single paired data curve or all curves for the operation (see section 7.2.1 “Selecting Paired Data Curves for Function Operations” for more details).  Constants can be divided by only one paired data set at a time
  4. Click Constant and enter the value to divide by in the box to the right.
  5. Click Compute.

 

To divide the selected data set by one or more data sets (time series only):

  1. From the Selected Data Set list, select a data set to apply the function. This data set will contain the result of the divide operation.
  2. Click Data Set. 
  3. From the Data Set list, select the divisor data set(s).  .  If you include the data set selected in the top Selected Data Set, it will be divided by itself.
  4. Click Compute.