Test for Independence of two categorical random variables in EXCEL
Channel: Ralf Becker
Date: 30/04/2023

This is a worked through example for a Chi-Square test of independence. I show how to use Excel to calculate the test statistic and its p-value .

The data come from a YouGov Intention to Vote Survey (End of March, 2023) for the UK. Source: https://docs.cdn.yougov.com/8iqsfg1dct/TheTimes_VI_230330_W.pdf.