Microsoft Office Tutorials and References

In Depth Information

Fig. 1.7
Dialogue box for “naming a range of cells” with the name: Weight

Now, add the following terms to your spreadsheet:

E6: n

E9: Mean

E12: STDEV

E15: s.e. (see Fig.
1.8
)

Note:
Whenever you use a formula, you must add an equal sign (

) at the

beginning of the name of the function so that Excel knows that you intend to use

a formula.

¼

1.4.5 Finding the Sample Size Using the ¼COUNT Function

Objective
: To ﬁnd the sample size (n) for these data using

the

¼

COUNT function

F6:

¼

COUNT(Weight
)

This command should insert the number 8 into cell F6 since there are eight mice

in your sample.

1.4.6 Finding the Mean Score Using the

¼

AVERAGE Function

Objective
: To ﬁnd the mean weight ﬁgure using the

¼

AVERAGE

function

Search JabSto ::

Custom Search