Tuesday, June 26, 2018

How To... Perform a One-Sample t Test by hand and in Excel 2016

Yesterday I published a new video showing students how to perform a one-sample t test by hand. This test shows if there is a significant difference between a sample mean and a population mean. My students from next September will need to know how to perform this test by hand. Here's the video:




Today I am publishing how to do the same test using Excel. This has to be done manually step-by-step, as Excel does not have a Data Analysis tool of function to do this test. The same result is obtained - here's the video:


After a sudden burst of creating three new videos, that's it for a while as I am starting holidays from tomorrow. I will be on the lookout for new stats test to cover as I plan on adding some more to my modules next year.

No comments:

Post a comment