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!

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 a 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!

I am teaching a new online class this semester, which means that I will be making more guides again!  Today, I just made a guide on calculating one-variable chi-square tests in Excel.  Because the “Data Analysis” add-on in Excel does not have this function, they are a pain to calculate in Excel.  Nevertheless, I hope this guide is helpful to some.

Here is the link to it: https://mattchoward.com/one-variable-chi-square-test-in-excel/ .

As always, please email me at MHoward@SouthAlabama.edu if you have any questions!