Microsoft Office Tutorials and References
In Depth Information
The resulting correlation matrix appears in A42:E46 (see Fig. 7.8 ).
Resulting Correlation Matrix for SAT Scores vs. FROSH GPA Data
Next, format all of the numbers in the correlation matrix that are in decimals to
two decimals places. And, also, make column E wider so that the MATH SCORE
label ﬁts inside cell E42.
Save this Excel ﬁle as: GPA14
The ﬁnal spreadsheet for these scores appears in Fig. 7.9 .
Final Spreadsheet for SAT Scores vs. FROSH GPA Regression and the Correlation
Search JabSto ::