Microsoft Office Tutorials and References
In Depth Information
Fig. 7.12 Worksheet Data for Chapter 7: Practice Problem #3
1. What is multiple correlation R xy ?
2. What is the y-intercept a ?
3. What is the coefficient for SAT-V b 1 ?
4. What is the coefficient for SAT-M b 2 ?
5. What is the coefficient for HS GPA b 3 ?
6. What is the coefficient for the AP BIOLOGY b 4 ?
7. What is the multiple regression equation?
8. Predict the FROSH GPA you would expect for an SAT-V score of 650,
an SAT-M score of 630, a HS GPA of 3.47, and an AP Biology Test score
of 4.
(f) Now, go back to your Excel file and create a correlation matrix for these five
variables, and place it underneath the SUMMARY OUTPUT on your
spreadsheet.
(g) Save this file as: APbiology3
(h) Now, print out just this correlation matrix on a separate sheet of paper.
Answer the following questions using your Excel printout. Be sure to
include the plus or minus sign for each correlation:
9. What is the correlation between SAT-V and FROSH GPA?
10. What is the correlation between SAT-M and FROSH GPA?
11. What is the correlation between HS GPA and FROSH GPA?
12. What is the correlation between AP BIOLOGY and FROSH GPA?
13. What is the correlation between SAT-V and SAT-M?
14. What is the correlation between HS GPA and AP-BIOLOGY?
15. What is the correlation between SAT-M and AP BIOLOGY?
16. What is the correlation between SAT-V and AP BIOLOGY?
17. Discuss which of the four predictors is the best predictor of FROSH
GPA.
Search JabSto ::




Custom Search