Multiple
Linear Regression
The Multiple Linear Regression function computes the multiple linear regression
coefficients between a primary time series data set and a collection of independent time
series data sets, and stores the regression coefficients in a new paired data set.
This paired data set may be used with the Apply Multiple Linear Regression function to
derive a new estimated time series.
For the general linear regression equation, a dependent variable, Y, may be computed from a set independent variables, Xn:
Y = B0 + B1*X1 + B2*X2 + B3*X3
where Bn are the linear regression coefficients.
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:
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.
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 data sets and uses only those points in the regression analysis. For any given time, if a value is missing in any time series, no data for that time is processed. Optional minimum and maximum limits can be set to exclude values in the primary time series which fall outside a specified range.
To compute the set of multiple linear regression coefficients:
