Microsoft Office Tutorials and References

In Depth Information

Fig. 6.10
Dialogue Box for Naming a Range of Data as: “weight”

Formulas

Deﬁne 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