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