Microsoft Office Tutorials and References
In Depth Information
Fig. 1.9 Example of Using Excel Formulas for Sample Size, Mean, STDEV, and s.e.
¼
F15:
F12/SQRT(8)
This command should insert the number 0.154616 into cell F15 (see Fig. 1.9 ).
Important note: Throughout this topic, be sure to double-check all of the figures in
your spreadsheet to make sure that they are in the correct cells, or the formulas will
not work correctly!
1.4.8.1 Formatting Numbers in Number Format (2 decimal places)
Objective : To convert the mean, STDEV, and s.e. to two decimal
places
Highlight cells F9 : F15
Home (top left of screen)
Look under “Number” at the top center of your screen. In the bottom right corner,
gently place your mouse pointer on you screen at the bottom of the .00 .0 until it
says: “Decrease Decimals” (see Fig. 1.10 )
Click on this icon twice and notice that the cells F9:F15 are now all in just two
decimal places (see Fig. 1.11 )
Now, click on any “empty cell” on your spreadsheet to deselect cells F9:F15.
Search JabSto ::




Custom Search