Hypothesis Testing: A Visual Introduction To Statistical Significance by Scott Hartshorn

Author:Scott Hartshorn [Hartshorn, Scott]
Language: eng
Format: azw3, epub
Published: 2020-06-20T16:00:00+00:00

The value of 2.16 isn’t in the T table, but the value of 2.144 is close enough. We can read up to see that the two-tailed confidence at this T value is .05. This means that we are at least 95% confident that this college has a statistically different height than the average .

Putting that all into one table

Excel generated the p value using the function

= T.Dist.2T(x, DF)

It returned .0484 which is slightly more precise than the .05 we got from the T-table since we had to go with the closest value of 2.14, which didn’t precisely match our T value

Doing a 1 sample T Test in Excel

Unfortunately there is no easy one line way to replicate a 1 sample T test in excel. You are forced to go through it step by step. But using the equation =STDEVA to get the sample standard deviation, and =T.Dist(), T.Dist.RT() or =T.Dist.2T() to lookup a value from the T table makes it relatively painless

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.