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 ﬁgures 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