Microsoft Office Tutorials and References
In Depth Information
5.3 FORMULA #2: One or Both Groups have a Sample Size
Less than 30
Suppose that you wanted to see if there was a geographic variation in body length
(in mm) of queen honeybees in two different regions of the world (REGION A and
REGION B). Suppose, further, that you have been asked to analyze the data from
this study and to compare the body lengths of the two regions using the two-group
t-test for independent samples. You decide to try out your new Excel skills on a
small sample of queen honeybees from each region on the hypothetical data given
in Fig. 5.13 :
Fig. 5.13 Worksheet data
for body length of queen
honeybees (practical
example)
Letâ€™s call REGION A as Group 1, and REGION B as Group 2.
Null hypothesis: l 1 = l 2
Research hypothesis: l 1 = l 2
Note: Since both groups have a sample size less than 30, you need to use
Formula #2 in the following steps:
Create an Excel spreadsheet, and enter the following information:
A3:
BODY
LENGTH
(in
mm)
OF
QUEEN
HONEYBEES
IN
TWO
REGIONS
B5:
REGION A
C5:
REGION B
B6:
22.56
B15:
20.23
C6:
18.22
C17:
18.05
Search JabSto ::

Custom Search