T-Tests in Excel on YouTube

I just finished uploading my latest lecture to YouTube.  It covers how to perform one-sample t-tests and two-sample t-tests in Excel.  While both are extremely important statistics, the latter cannot be easily calculated in Excel.  So, I hope that this video is helpful in figuring how how to calculate the statistic.

Here is the link to the YouTube video: https://www.youtube.com/watch?v=GOs_IXTHT5w .

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

One-Sample T-Test in Excel

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!

Chi-Square Test of Independence in Excel (Two Variable)

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!

One-Variable Chi-Square Test in Excel

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 hekpful to some.

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

Practice in Excel and SPSS

Need a little practice in Excel and SPSS?  On the Statistics Help section of MattCHoward.com, I recently uploaded several practice pages.  Links to each individual page are below.

Chi-Square Practice

Correlation Practice

Dummy-Coded Regression Practice

One-Way ANOVA Practice

Quadratic Regression Practice

Regression Practice

Two-Sample T-Test Practice

Two-Way ANOVA Practice

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

ANOVA and Chi-Square in Excel and SPSS

More guides for statistical analyses in Excel and SPSS on MattCHoward.com!  This week, I added four guides.  The links can also be found below:

One-Factor ANOVA in Excel

Chi-Square in SPSS

One-Way ANOVA in SPSS

Two-Way ANOVA in SPSS

As always, feel free to email me at MHoward@SouthAlabama.edu if you have any questions, comments, stories, or requests for guides!