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
As always, if you need any help with these guides or anything else, please email me at MHoward@SouthAlabama.edu.
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:
As always, if you need any help with these guides or anything else, please email me at MHoward@SouthAlabama.edu.
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/ .
Hi all! I just made a new post on StatisticalBullshit.com about p-values. Use the following link to read more!
https://statisticalbullshit.com/2017/09/25/more-issues-with-p-values/
If you have any specific topics that you’d like to read about, please let me know by emailing MHoward@SouthAlabama.edu.
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/
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!
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!
On StatisticalBullshit.com, I recently posted a new page on the perils of small sample sizes. Some quick examples show that small samples may bias your results in unexpected ways. So be sure to read it here: https://statisticalbullshit.com/2017/08/07/small-samples-big-problems/ .
As always, if you have any statistical questions or comments, please email me at MHoward@SouthAlabama.edu!
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!?
As always, if you have any questions, comments, or requests, please email me at MHoward@SouthAlabama.edu!
New post on StatisticalBullshit.com! This post discusses when mean comparisons are appropriate. Perhaps more importantly, this post also discusses when mean comparisons are inappropriate. Particularly, it focuses on a prior personal experience of mine, in which a manager believed that the means of two variables could provide information regarding their linear relationship. If you believe that you, your boss, or anyone else has made this mistake in the past, be sure to read the post to understand how to avoid Statistical Bullshit in the future! Also, feel free to email me (MHoward@SouthAlabama.edu) any questions or future posts that you’d like to see on StatisticalBullshit.com.
The link to the post is here: https://statisticalbullshit.com/2017/07/31/what-is-in-a-mean/ .
Dr. Matt C. Howard 