Microsoft Office Tutorials and References
In Depth Information
OK
The resulting correlation matrix appears in A42:E46 (see Fig. 7.8 ).
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 fits inside cell E42.
Save this Excel file as: GPA14
The final spreadsheet for these scores appears in Fig. 7.9 .
Fig. 7.9
Final Spreadsheet for SAT Scores vs. FROSH GPA Regression and the Correlation
Matrix
Search JabSto ::




Custom Search