Tag Archives: Work

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

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

One-Factor ANOVA in Excel

Chi-Square in SPSS

One-Way ANOVA in SPSS

Two-Way ANOVA in SPSS

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

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.

Bullshit Outliers

New post on StatisticalBullshit.com!  This post discusses how outliers can skew your results…and how sometimes removing outliers can also skew your results!  To read more about Statistical Bullshit, use the following link: https://statisticalbullshit.com/2017/10/09/bullshit-outliers/ .

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!