Microsoft Office Tutorials and References

In Depth Information

Fig. 7.5

Final Spreadsheet for SAT vs. FROSH GPA Regression Analysis

Once you have the SUMMARY OUTPUT, you can determine the multiple

correlation and the regression equation that is the best-ﬁt line through the data

points using READING SCORE, WRITING SCORE, AND MATH SCORE as the

three predictors, and FROSH GPA as the criterion.

Note on the SUMMARY OUTPUT where it says: ‘‘Multiple R.’’ This term is

correct since this is the term Excel uses for the multiple correlation, which is

+0.80. This means, that from these data, that the combination of READING

SCORES, WRITING SCORES, AND MATH SCORES together form a very

strong positive relationship in predicting FROSH GPA.

To ﬁnd the regression equation, notice the coefﬁcients at the bottom of the

SUMMARY OUTPUT:

Intercept: a (this is the y-intercept)

1.5363

READING SCORE: b
1

0.0006

WRITING SCORE: b
2

0.0003

MATH SCORE: b
3

0.0021

Since the general form of the multiple regression equation is:

Y
¼
a
þ
b
1
X
1
þ
b
2
X
2
þ
b
3
X
3

ð
7
:
2
Þ

Search JabSto ::

Custom Search