I am teaching a new online class this semester, which means that I will be making more guides again! today, I just made a guide on calculating one-variable chi-square tests in Excel. Because the “Data Analysis” add-on in Excel does not have this function, they are a pain to calculate in Excel. Nevertheless, I hope this guide is hekpful to some.
Here is a link to it: https://mattchoward.com/one-variable-chi-square-test-in-excel/ .
As always, please email me at MHoward@SouthAlabama.edu if you have any questions!
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.
Dummy-Coded Regression Practice
One-Way ANOVA Practice
Quadratic 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!
More guides for statistical analyses in Excel and SPSS on MattCHoward.com! This week, I added four guides. The links can also be found below:
One-Factor ANOVA in Excel
Chi-Square in SPSS
One-Way ANOVA in SPSS
Two-Way ANOVA in SPSS
As always, feel free to email me at MHoward@SouthAlabama.edu if you have any questions, comments, stories, or requests for guides!