Microsoft Office Tutorials and References
In Depth Information
Fig. 6.10 Dialogue Box for Naming a Range of Data as: “weight”
Formulas
Define name (top center of your screen)
weight (in the Name box; see Fig. 6.10 )
OK
Now, repeat these steps to give the name: eggs to C8:C19
Finally, click on any blank cell on your spreadsheet to “deselect” cells C8:C19
on your computer screen.
Now, complete the data for these sample sizes, means, and standard deviations in
columns B and C so that B22 is 2956.58, and C23 is 19.79 (use two decimals for the
means and standard deviations; see Fig. 6.11 )
Objective : Find the correlation between weight and eggs produced
B25:
correlation
C25:
¼
correl(weight,eggs) ; see Fig. 6.12
Hit the Enter key to compute the correlation
C25:
format this cell to two decimals
correl(weight,eggs) in C25 tells Excel that you are
going to use a formula in this cell.
The correlation between weight (X) and eggs produced (Y) is
Note that the equal sign in
¼
.87 , a very
strong positive correlation. This means that you have evidence that there is a strong
þ
Search JabSto ::




Custom Search