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 ﬁts inside cell E42.

Save this Excel ﬁle as: GPA14

The ﬁnal 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 coefﬁcients 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