Microsoft Office Tutorials and References

In Depth Information

Fig. 1.1
Worksheet Data for

Wild Field Mice Weights

(Practical Example)

1.3 Standard Error of the Mean

The formula for the
standard error of the mean
(
s.e
., which we will use
S
x
to

symbolize) is:

s

n

p

s

:

e

:
¼

S
x
¼

(1.3)

To ﬁnd
s.e.
, all you need to do is to take the standard deviation, STDEV, and

divide it by the square root of n, where n stands for the “number of numbers” that

you have in your data set. In the example under the standard deviation description

above, the
s.e.

0.60 . (You can check this on your calculator.)

If you want to learn more about the standard deviation and the standard error of

the mean, see Bremer and Doerge (2010) and Weiers (2011).

Now, let’s learn how to use Excel to ﬁnd the sample size, the mean, the standard

deviation, and the standard error or the mean using the weight (measured in grams)

of eight adult wild ﬁeld mice collected in a tall grass prairie on the bluffs above the

Mississippi River near St. Louis, Missouri. The hypothetical data appear in Fig.
1.1
.

¼

Search JabSto ::

Custom Search