Microsoft Office Tutorials and References
In Depth Information
Fig. 6.9
Worksheet data for weight and eggs produced (practical example)
Important note: Note that the eggs produced have been rounded off to
thousands, so that a fish that produces 65,000 eggs would be
recorded as 65.
You want to determine if there is a relationship between the weight and eggs
produced, and you decide to use a correlation to determine this relationship. Let’s
call the weight scores the predictor, X, and eggs produced, the criterion, Y.
Create an Excel spreadsheet with the following information:
A3: FEMALE WALLEYE FISH IN WISCONSIN
B5: Is there a relationship between weight and the number of eggs produced?
B7: Weight in grams (g)
C7: Eggs produced (thousands)
B8: 1245
C8: 58
Next, change the width of Columns B and C so that the information fits inside
the cells.
Now, complete the remaining figures in the table given above so that B19 is
4589 and C19 is 94. (Be sure to double-check your figures to make sure that they
are correct!) Then, center the information in all of these cells.
A21: n
A22: mean
A23: stdev
Next, define the ‘‘name’’ to the range of data from B8:B19 as: weight
We discussed earlier in this topic (see Sect. 1.4.4 ) how to ‘‘name a range of
data,’’ but here is a reminder of how to do that:
Search JabSto ::




Custom Search