Microsoft Office Tutorials and References
In Depth Information
MATH SCORE) are to the right of the criterion variable. If you follow this rule,
you will be less likely to make a mistake in this type of analysis.
7.2 Finding the Multiple Correlation and the Multiple
Regression Equation
Objective:
To find the multiple correlation and multiple regression equation
using Excel
You do this by the following commands:
Data
Click on: Data Analysis (far right top of screen)
Regression (scroll down to this in the box; see Fig. 7.2 )
Fig. 7.2
Dialogue Box for Regression Function
OK
Input Y Range: A6:A17
Input X Range: B6:D17
Note that both the input Y Range and the Input X Range above both include the
label at the top of the columns.
Search JabSto ::




Custom Search