To
Irregular using Pattern
The To Irregular using Pattern function generates a new time series data set from
an existing irregular or regular interval time series data set. The times for the
new time series are defined by the times of a second time series data set. Values
for the new time series are computed from the original time series data using one of
seven available functions. The functions are:
Interpolate at end of Period
Maximum for Period
Minimum for Period
Average over Period
Accumulation over Period
Volume for Period
Integration over Period
Number of Valid Data over Period
where “period” is the time between data points in the pattern data set.
The data type of the original time series data governs how values are interpolated. Data type “INST-VAL” (or “INST-CUM”) considers the value to change linearly over the interval from the previous data value to the current data value. Data type “PER-AVER” considers the value to be constant at the current data value over the interval. Data type “PER-CUM” considers the value to increase from 0.0 (at the start of the interval) up to the current value over the interval. Interpolation of the three data types is illustrated in the figure below.
Interpolation of “INST-VAL,” “PER-AVER” and “PER-CUM” Data
How interpolation is performed for a specific data type influences the computation of new values for the selected function. For example, if the data type is “INST-VAL,” the function Maximum for Period is evaluated by:
Referring to the plots above, the Average over Period function is applied to a time series by integrating the area under the curve between interpolated points and dividing the result by the interval time.
Screen for Transforming To Irregular using Pattern Function
The appearance of the Math Functions screen for the Transform to Irregular interval function is shown above.
To transform to an irregular interval time series data set: