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/8iqsfg1dc....