Microsoft Office Tutorials and References
In Depth Information
To use Excel to do this, use these steps:
Data (top of screen under ‘‘Home’’ at the top left of screen)
Data Analysis
Correlation (scroll up to highlight this formula; see Fig. 7.6 )
Fig. 7.6
Dialogue Box for SAT vs. FROSH GPA Correlations
OK
Input range: A6:D17
(Note that this input range includes the labels at the top of the FOUR variables
(FROSH GPA, READING SCORE, WRITING SCORE, MATH SCORE) as well
as all of the figures in the original data set).
Grouped by: Columns
Put a check in the box for: Labels in the First Row (since you included the labels at
the top of the columns in your input range of data above)
Output range (click on the button to its left, and enter): A42 (see Fig. 7.7 )
Fig. 7.7 Dialogue Box for
Input/Output Range for
Correlation Matrix
Search JabSto ::




Custom Search