Math Functions > General Functions


Estimate Missing Values

The Estimate Missing Values function linearly interpolates estimates for missing values in a regular or irregular interval time series data set.  Linear interpolation will occur for those portions of the time series data set where the number of consecutive missing values exceeds a specified user limit.

 

If the time series data set has type "INST-CUM", a special check box appears to optionally enable the following rules intended for cumulative precipitation:

 

§  If the values bracketing the missing period are increasing with time, only interpolate if the number of successive missing values does not exceed the value of the user specified limit.

§  If the values bracketing the missing period are decreasing with time, do not estimate any missing values.

§  If the values bracketing the missing period are equal, then estimate any number of missing values

 

To estimate for missing values in time series data sets:

  1. Choose the General tab of the Math Functions screen and select the Estimate Missing Values 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. In the Maximum Consecutive Number of Missing box, enter a value to set the limit for consecutive missing values allowed for interpolation.
  4. If the time series data set is of type cumulative precipitation, select Interpolate Cumulative Precip to apply the modified rules for the interpolation of missing precipitation data.
  5. Click Compute to perform the linear interpolation fill of the missing values in the data set.