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