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 find 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 find the mean weight figure using the
¼
AVERAGE
function
Search JabSto ::




Custom Search