2] 3] 5} 6] Odds and Risk Ratios Are Sports games are more likely to get the more restrictive E10+ rating I? marks} a. Do you think this dataset is a sample or a population? And why do you think that? {2 marks} b- E10+ is a more restrictive rating than E. Given that we have defined Sports as the 'positive' predictor and the E'lD+ rating as the 'positive' outcom e, build a 2x2 pivot table for this test. i1 mark} c. Calculate either the odds or the risk that a game will be rated E10+ rather than E {and show your calculations]. You will have to think carefully to do this correctly'. Rem em ber that we have defined Sports as the 'positive' predictor and the E10+ rating as the 'positive' outcome. {2 marks} d. What does this tell you about the risk or odds of getting the higher rating with a Sports game? (I manic} e. What if any further steps would we need to perform to be sure of the result? (I mark} Chi-squared - Is there a relationship between genre and critic score? {3 marks} 3. 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. [1 mark J b. Create another table showing the expected values for this dataset. [1 mark) c. Calculate the chi-squared value for this data. [2 marks} d. What does this tell you about the likelihood of a relationship between genre and critic score? {1 mark]I e. Use the CHISQJEST function to calculate the p-value for the observed and expected values. [1 mark J f. For a 95% CL, explain you would accept or reject the null hypothesis in this case. {1 mark) 3- Explain why you believe this wasr or was not,a valid application of Pearson's Chi-squared test. [1 mark .1 T-test - Is there a significant difference in user counts depending on the genre of the game? [5 marks) 3. Create a pivot table showing game name in rows, genre in columns, and sum of user countin values. [1 mark} b. Using the Data Analysis Toolpak, create a t-test, two-sample assuming equal variances, with a 95% confidence level. [1 mark J Should you use the onetail or two-tail pvalue? What is your calculated p-value for your choice? [1 mark J d. Explain why you would accept or reject the null hypothesis in this case. [I mark} e. Explain why you believe this wasr or was not,a valid choice ofmst for these circumstances. {1 mark} ANOVA - Are global sales different depending on the critic score group? [4 marks} 3. Create a pivot table showing game name in rows, critic score group in colum ns, and sum of global sales in values. [1 mark J b. Using the Data Analysis Toolpak, create a Single Factor ANOVA with a 95% confidence level. {1 mark} c. What is your calculated F-statistic? Which F-statistic value depends on the chosen confidence level? {I mark} d. Explain why you would accept or reject the null hypothesis in this case. {I mark} e. Explain why you could not use a T-test here. {1 mark} MANDVA - Is the combination ofglobal sales, user count and user score driven by Crit_Sc_Group? [4 marks} 3. Create a pivot table showing game namethen critic score group in rows, and three variables in values: sum of global sales, sum of user score, and sum of user count. You'll see '2 Values' appear in Columns. i1 mark} b. Using the Real Statistics add-in, create a Single Factor MANOVA with Regular analysis and a 95% confidence level. Include Significance Analysis, Covariance Matrices. M ultiple ANOVA and Group M eans. {I mark} '3- Looking at the p-values for the various statistics [Pillai Trace, Wilk's Lam bda, Hotelling Trace], explain why you would accept or reject the null hypothesis in this case. {1 mark} d. Looking at the multiple ANOVAs calculated for each of these statistics, which if any of these variables is significantly affected by the critic score group?. [1 mark J