Microsoft Office Tutorials and References
In Depth Information
Fig. 5.9 Results of widening
column B and centering the
numbers in the cells
B8:
Null hypothesis:
B10:
Research hypothesis:
Since both groups have a sample size greater than 30, you need to use Formula
#1 for the t-test for the difference of the means of the two groups.
Let’s ‘‘break this formula down into pieces’’ to reduce the chance of making a
mistake.
B13:
STDEV1 squared/n1 (note that you square the standard deviation of Group
1, and then divide the result by the sample size of Group 1)
B16:
STDEV2 squared/n2
B19:
D13 ? D16
B22:
s.e.
B25:
critical t
B28:
t-test
B31:
Result:
B36:
Conclusion: (see Fig. 5.10 )
Search JabSto ::




Custom Search