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 ﬁnd 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