Microsoft Office Tutorials and References

In Depth Information

1.4.6 Finding the Mean Score Using the =AVERAGE Function

Objective: To ﬁnd the mean weight ﬁgure using the =AVERAGE function

F9:

=AVERAGE(Weight)

This command should insert the number 1.6375 into cell F9.

1.4.7 Finding the Standard Deviation Using the =STDEV

Function

Objective: To ﬁnd the standard deviation (STDEV) using the =STDEV

function

F12: = STDEV(Weight)

This command should insert the number 0.437321 into cell F12.

1.4.8 Finding the Standard Error of the Mean

Objective: To ﬁnd the standard error of the mean using a formula for these

eight data points

F15:

=F12/SQRT(8)

This command should insert the number 0.154616 into cell F15 (see Fig.
1.9
).

Search JabSto ::

Custom Search