Excel 2016 for Social Science Statistics by Thomas J. Quirk

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

D28:=(D4 − D5)/D22 (use two decimals) (no spaces between symbols)

This formula should give you a value for the t-test of: −4.55.

Nest, check to see if you have rounded off all figures in D13:D28 to two decimal places (see Fig. 5.11).

Fig. 5.11Results of the t-test Formula for the Soft Drink Taste Test

Now, write the following sentence in D31 to D34 to summarize the result of the study:D31:Since the absolute value of −4.55

D32:is greater than the critical t of

D33:1.96, we reject the null hypothesis

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.