Hi,

Please help me solve this question by using excel.

AutoSave . OFF MGMT650 HW11 Summer21_Questions - Saved to my Mac Q Home Insert Draw Page Layout Formulas Data Review View Developer ? Tell me Share Comments Calibri (Body) * 11 AA ab Wrap Text v General ZNAY - O. Paste BIU BY CvAv EE Merge & Center v $ ~ % " Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles Filter Select Data Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates S14 fx B C G H M N Q R S T U w Z AA AB AC AD AE An analyst at a local bank wonders if the age distribution of customers coming for service at his branch in town is the same as at a branch located near the mall. He selects 100 transactions at random from each branch and researches the age information for the associated customer. These are the data : Age less than 30 30-55 56 or older Total In town 20 40 40 100 mall 30 50 20 100 Total 50 60 200 10 1 What is the null hypothesis if you want to check if the age patterns of customers are independent of bank location? 11 2 What are the expected numbers for each cell in a 3 by 3 table if the null hypothesis is true? 13 3 Use the chi square test to accept or reject the null hypothesis. What is the chi square test statistic? 15 16 4 What is the chi square critical value and how many degrees of freedom does it have? Assume alpha is .05. 17 5 What do you conclude? HW11 Chi Square ANOVA Regression Cleaning Data with Outlier + IT - + 83%