Hello,

I need help! How do I perform a chi-square test on excel? I have 343 respondents- they were asked whether they were married-1, never married-5, single-4, divorced-3 or widowed-2 and asked whether they were very happy-1, happy-2, not too happy-3, not applicable-4. I converted their answers using code . Can you describe how to run the test in excel?

Thank you so much!