Microsoft Office Tutorials and References
In Depth Information
Fig. 7.7 Dialogue Box for Input / Output Range for Correlation Matrix
Fig. 7.8 Resulting Correlation Matrix for SAT Scores vs. FROSH GPA Data
The resulting correlation matrix appears in A42: E46 (See Fig. 7.8 ).
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 .
Note that the number “1” along the diagonal of the correlation matrix means that
the correlation of each variable with itself is a perfect, positive correlation of 1.0.
Correlation coefficients are always expressed in just two decimal places.
You are now ready to read the correlation between the six pairs of variables:
The correlation between READING SCORE and FROSH GPA is:
+ .51
The correlation between WRITING SCORE and FROSH GPA is:
+ .45
The correlation between MATH SCORE and FROSH GPA is:
+ .77
The correlation between WRITING SCORE and READING SCORE is:
+ .47
The correlation between MATH SCORE and READING SCORE is:
+ .44
The correlation between MATH SCORE and WRITING SCORE is:
+ .43
Search JabSto ::




Custom Search