One-Sample and Two-Sample T-Test in Excel and SPSS

Hi all!  I just finished uploading three new sections to the Statistics Help portion of my academic website.  To access these three pages, please click on the links below:

One-Sample T-Test in SPSS

Two-Sample T-Test in SPSS

Two-Sample T-Test in Excel

As always, if you need any help with these guides or anything else, please email me at MHoward@SouthAlabama.edu.

Quadratic & Dummy-Coded Regression in Excel and SPSS

Hi all!  I just finished uploading four new sections to the Statistics Help portion of my academic website.  To access these four pages, please click on the links below:

Dummy-Coded Regression in Excel

Dummy-Coded Regression in SPSS

Quadratic Regression in Excel

Quadratic Regression in SPSS

As always, if you need any help with these guides or anything else, please email me at MHoward@SouthAlabama.edu.

Regression and More in Excel and SPSS

Hi all!  I just finished uploading three new sections to the Statistics Help portion of my academic website.  To access these three pages, please click on the links below:

Regression in Excel

Regression in SPSS

Partial Correlation in SPSS

As always, if you need any help with these guides or anything else, please email me at MHoward@SouthAlabama.edu.

Identifying Multiple Modes in Excel

Very early in my intro-level statistics courses, I always cover the topics of mean, median, and mode. For any dataset, there can only be a single mean and/or median value, but there can be multiple modes. For some strange reason, the =mode() command in Excel will only provide the first mode that appears in a dataset, even when multiple modes exist! For this reason, I made a guide on how to use the =mode.mult() command. Never again should you incorrectly identify the number of modes in a dataset!

Here is the link: https://mattchoward.com/multiple-modes-in-excel/

Descriptive Statistics in Excel

I just added a page on How to Calculate Descriptive Statistics in Excel to the Excel Statistics Help portion of my Statistics Help page.  If you need help calculating descriptives, click here:

https://mattchoward.com/descriptive-statistics-in-excel/

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

How to Perform a T-Test in Excel

Recently, I added a page on How to Perform a T-Test in Excel to the Excel Statistics Help portion of my Statistics Help page.  So, if you need help performing a t-test in excel, click here:

https://mattchoward.com/how-to-perform-a-t-test-in-excel/

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

Activating “Data Analysis” in Excel

Have you ever wanted to calculate a simple statistic in Excel, but couldn’t find the correct tab to do so?  If so, it is possible that you did not have the “Data Analysis” tab activated.  For some reason, Excel defaults the Data Analysis tab as
inactivate, although it is completely free and per-installed.  Weird, right!?

To help with this problem, I created a page on my website with instructions on how to activate the “Data Analysis” tab. If can be found by clicking here.

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