Microsoft Office Tutorials and References
In Depth Information
1.4.6 Finding the Mean Score Using the =AVERAGE Function
Objective: To find the mean weight figure 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 find 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 find 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