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
6¼
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