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-fit 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 find the regression equation, notice the coefficients 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