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.
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/
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:
As always, email me at MHoward@SouthAlabama.edu if you have any questions!
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!