Microsoft Office Tutorials and References

In Depth Information

E13: 2 Region B

F11: n

G11: Mean

H11: STDEV

Your spreadsheet should now look like Fig.
5.14
.

Now you need to use your Excel skills from Chapter 1 to ﬁll in the sample

sizes (n), the Means, and the Standard Deviations (STDEV) in the Table in cells

F12:H13. Be sure to double-check your work or you will not be able to obtain the

correct answer to this problem if you have only one incorrect ﬁgure!

Since both groups have a sample size less than 30, you need to use Formula #2

for the t-test for the difference of the means of two independent samples.

Formula #2 for the two-group t-test is the following:

X
1

X
2

S
X
1
X
2

t

¼

(5.1)

Where

s

ð

S
1
þð

S
2

n
1

1

Þ

n
2

1

Þ

1

n
1
þ

1

n
2

S
X
1
X
2
¼

(5.5)

n
1
þ

n
2

2

¼

df

¼

n
1
þ

n
2

and where degrees of freedom

2

(5.6)

This formula is complicated, and so it will reduce your chance of making a

mistake in writing it if you “break it down into pieces” instead of trying to write the

formula as one cell entry.

Now, enter these words on your spreadsheet:

E16: (n1 – 1) x STDEV1 squared

E19: (n2 – 1) x STDEV2 squared

E22: n
1
þ

n
2
–2

E25: 1/n
1
þ

1/n
2

E28: s.e.

E31: critical t

E34: t-test

B37: Result:

B40: Conclusion: (see Fig.
5.15
)

You now need to use your Excel skills to compute the values of the above

formulas in the following cells:

H16: the result of the formula needed to compute cell E16 ( use 2 decimals)

H19: the result of the formula needed to compute cell E19 (use 2 decimals)

H22: the result of the formula needed to compute cell E22

Search JabSto ::

Custom Search