Microsoft Office Tutorials and References
In Depth Information
Fig. 5.13 Worksheet Data for Body Length of Queen Honeybees (Practical Example)
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 :
Let’s call REGION A as Group 1, and REGION B as Group 2.
Null hypothesis:
m 1 ¼ m 2
Research hypothesis:
m 1 m 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
Search JabSto ::

Custom Search