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!