Excel 2010 for Engineering Statistics by Thomas J. Quirk

Author:Thomas J. Quirk
Language: eng
Format: epub
Publisher: Springer International Publishing, Cham

Create an Excel spreadsheet, and enter the following information:

B3: Group

B4: 1 Group A

B5: 2 Group B

C3: n

D3: Mean

E3: STDEV

C4: 52

D4: 55

E4: 7

C5: 57

D5: 64

E5: 13

Now, widen column B so that it is twice as wide as column A, and center the six numbers and their labels in your table (see Fig. 5.9)

Fig. 5.9Results 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)

Fig. 5.10Formula Labels for the Two-group t-test

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.