1. Chi-squared - Is there a relationship between genre and critic score? Create a pivot table showing genre as the independent variable and critic score group as the outcome variable, and populated with results from your dataset.

Create another table showing the expected values for this dataset. Calculate the chi-squared value for this data.

1. What does this tell you about the likelihood of a relationship between genre and critic score?
2. Use the CHISQ.TEST function to calculate the p-value for the observed and expected values.
3. For a 95% CL, explain you would accept or reject the null hypothesis in this case.
4. Explain why you believe this was, or was not, a valid application of Pearson's Chi-squared test.

Link for data set below

https://www.dropbox.com/scl/fi/09pxtlh9gpqletn8qt74a/Course-hero-Question.xlsx?dl=0&rlkey=hwb61d3qp043oo4dt80mkr780