Previous Next

OLS Optimize

1             Enter data into the spreadsheet following normal WinORS conventions; that is, several independent variables and at least one dependent variable.

2             Enter names on row one and one-letter variable types (VType) across row two (I, D, F, G, or W).

3             Choose Menu path: Applications / Statistical Methods / Regression / Ordinary Least Squares.  If the data is not saved to disk WinORS will force you to File/Save at this point.  If the block range of the data is not already set, then use the roll-up arrow and do so at this time.

4             Proceed to generate a solution.  Analyze the regression results.  First check the validity of the regression parameters.   When multicollinearity is present (see: Variance Inflation Factors (VIFs) drop or transform offending variables (see Multicollinearity - Solving the Problem ).  Deselect (remove the I variable types) collinear variables.

5             Return to step #3 and solve the revised model except in this case choose OLS Optimze settings.  OLS Optimize automatically creates and employs either the Durbin adjusted or First-differenced data as a means of eliminating serial correlation from the data set under analysis.  WinORS reads the Durbin-Watson statistic at the 95% confidence level (2-tailed test) to determine whether the correction is necessary.  After solving for the OLS parameters on the time-series adjusted data, WinORS will attempt to correct for heteroskedasticity based on the p-value of White's test.  If the p-value of the White's test is greater than 0.05 a weighted OLS analysis is performed.  Upon the completion of all steps, the WinORS user is presented with the corrected solution across all relevant tabs.

a.   Durbin Adj -- check this box is you want auto-correlation correction using the Durbin adjustment method.

b.   First diff.  --  check this box if you want auto-correlation correction using first differenced data.

c.     WOLS  -- check this box if you want to correct for heteroscedastic variance after correcting for auto-correlation violations.


Previous Next