The Apply Multiple Linear Regression function applies the multiple linear regression coefficients computed with the Multiple Linear Regression function. The coefficients, stored in a paired data set, are applied to a collection of independent time series data sets to derive a new estimated time series data set.
For time series data, an estimate of the primary time series values may be computed from a set of independent time series data sets using regression coefficients such that:
Y = B0 + B1*X1 + B2*X2 + B3*X3
where Bn are the linear regression coefficients.
For time series data, an estimate of the original time series values may be computed from a set of independent time series data using regression coefficients such that:
TsEstimate(t) = B0 + B1*TS1(t) + B2*TS2(t) + … + Bn*TSn(t)
where Bn are the set of regression coefficients and TSn are the time series data sets.
The number regression coefficients in the paired data set must be one more than the number of independent time series data sets. The collection of selected time series data sets should be in the same order as when the regression coefficients were computed. The displayed list of time series is sorted alphabetically in the dialog. The user should be aware if the names of the time series data sets used for coefficient generation are substantially different from the data names used in this function.
All the time series data sets must be regular interval and have the same time interval. The function filters the data to determine the time period common to all time series data sets and uses only those points in the regression analysis. For any given time, if a value is missing in any time series, the value in the resultant time series is set to missing. You can also set optional minimum and maximum value limits. Computed values in the resultant time series, which fall outside the specified range, are set to missing.
Names, parameter type and unit labels for the resultant time series data set are taken from the first time series data set. The "F part” (Version) in the new data set is set to "COMPUTED.”
Apply Multiple Linear Regression Method
To apply a set of multiple linear regression coefficients to derive a new time series data set: