Excel 2016 for Biological and Life Sciences Statistics by Thomas J. Quirk Meghan H. Quirk & Howard F. Horton

Excel 2016 for Biological and Life Sciences Statistics by Thomas J. Quirk Meghan H. Quirk & Howard F. Horton

Author:Thomas J. Quirk, Meghan H. Quirk & Howard F. Horton
Language: eng
Format: epub
Publisher: Springer International Publishing, Cham


Create an Excel spreadsheet, and enter the following information:B3:Group

B4:1 Males

B5:2 Females

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.8)

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



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.