Although I’ve been putting it off for months (years?), I finally made a guide on performing a one-sample t-test in Excel. The “Data Analysis” add-on in Excel is not able to calculate this statistic directly, so we have to trick Excel into calculating it for us. Nevertheless, the guide provides clear instructions on how to do so.
Here is a link to it: https://mattchoward.com/one-sample-t-test-in-excel/ .
Please email me at MHoward@SouthAlabama.edu if you have any questions!
Every semester, I try to upload my lectures to the University of South Alabama’s course management site, and, every semester, I run out of space before the half-way mark of the semester. Our IT department recently recommended that I upload my videos to YouTube to avoid these space difficulties. So, I am doing just that!
I already uploaded my first two lectures. The first is a general review of statistics with a focus on descriptive statistics and p-values. The second is an overview of one-variable chi-square tests and the chi-square test of independence (also called two-variable chi-square tests). The links are provided below:
Lecture 1 – Review – https://www.youtube.com/watch?v=-IvU7uTQ9u0
Lecture 2 – Chi-Square – https://www.youtube.com/watch?v=sRxTvZiV8Lg
As always, if you have any questions or comments, please contact me at MHoward@SouthAlabama.edu.
Just made a new guide as a follow-up to my prior guide! It is on the chi-square test of independence, also known as the two-variable chi-square test. Because the “Data Analysis” add-on in Excel does not have this function, it is a pain to calculate in Excel. So, I hope this guide can make it a little bit easier to others.
Here is a link to it: https://mattchoward.com/chi-square-test-of-independence-in-excel-two-variable/
Please email me at MHoward@SouthAlabama.edu if you have any questions!
Statistical Bullshit 