1 9 10 234567822 AutoSave Off MGMT650 HW11 Summer22_Questions File Home Insert Page Layout Formulas Data Review View Help Calibri v 11 ' ' Paste BIU v x x Undo Clipboard Font Alignment C19 X fx A B C E F G H Search (Alt+Q) Tiffany Dial General Conditional Formatting Insert T $ %" Format as Table Delete Sort & Find & 03- Cell Styles Number Styles Format Cells v Filter Select Editing K M N P TD Comments Share Analyze Sensitivity Data Analysis Sensitivity R S 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 Age less than 30 30-55 56 or older Total In town mall Total 25 37 38 100 30 48 22 100 55 85 60 200 1 What is the null hypothesis if you want to check if the age patterns of customers are independent of bank location? 11 12 2 What are the expected numbers for each cell in a 3 by 3 table if the null hypothesis is true? 13 Age 14 less than 30 30-55 56 or older Total 15 In town 0 16 mall 0 17 Total 0 0 0 0 18 3 Use the chi square test to accept or reject the null hypothesis. What is the chi square test statistic? HW11 Chi Square ANOVA Regression Cleaning Data with Outlier Ready Accessibility: Investigate 84F Partly sunny (DELL) . Count: 2 + 100% 5:53 PM 7/31/2022 AutoSave Off MGMT650 HW11 Summer22_Questions File Home Insert Page Layout Formulas Data Review View Help Calibri v 11 ' ' Paste BIU v x x Undo Clipboard Font Alignment C19 X fx A B E F 16 17 18 19 20 21 22 22 23 24 25 TIT LOWIT mall Total 0 0 0 Search (Alt+Q) H 0 0 General Conditional Formatting Insert $ %" Format as Table Delete 03- Cell Styles Number Styles Format Cells K 3 Use the chi square test to accept or reject the null hypothesis. What is the chi square test statistic? 4 What is the chi square critical value and how many degrees of freedom does it have? Assume alpha is .05. 5 What do you conclude? HW11 Chi Square ANOVA Regression Cleaning Data with Outlier Ready Accessibility: Investigate 84F Partly sunny + - . W Tiffany Dial TD T Sort & Find & Filter Select v Editing Comments Share Analyze Sensitivity Data Analysis Sensitivity M N P Q R S T Count: 2 + 100% 5:54 PM 7/31/2022