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
To find the multiple correlation and multiple regression equation
using Excel
You do this by the following commands:
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
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