New page on using regression for prediction in Excel! It can be found here: https://mattchoward.com/prediction-with-regression-in-excel/ . As always, email me at MHoward@SouthAlabama.edu if you have any questions or comments!
Tag: Excel
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!
Statistical Bullshit 