Using the Regression Function
The Regression function in EZAnalyze allows you to conduct a statistical hypothesis test of the ability of a single predictor (or set of predictors) to predict scores on a dependent variable (criterion). Since this is an Advanced feature of EZAnalyze, it will not be discussed at length here. Feel free to consult a statistics textbook or the Internet for information on what Regression is and how it works. If you are already familiar with Regression and want EZAnalyze to crunch the numbers for you, read on!
NOTE: This is the only procedure in EZAnalyze which relies on the 'Analysis Toolpak - VBA', provided by Microsoft. Not all Excel installations contain this program. If your installation does not have the Toolpak, you will not see the Regression option on the EZAnalyze Advanced menu.
To perform a Regression on your data, select "Advanced" from the EZAnalyze menu in Excel, and then choose "Regression".
When the "Regression" dialog box appears, select a criterion (dependent) variable from the list on the left, and your predictor(s) from the list on the right. When you are satisfied with your choices, click OK.
When you click OK, a results report will be printed on a separate sheet for your review. (click on "results report" for information on how to interpret this analysis)