Use the data in BUSI1013 Bank Datasetxlsx from Unit 1 Exercise Question 2 to

# Use the data in busi1013 bank datasetxlsx from unit 1

• Homework Help
• 6
• 100% (2) 2 out of 2 people found this document helpful

This preview shows page 5 - 6 out of 6 pages.

3. Use the data in BUSI1013 Bank Dataset.xlsx(from Unit 1 Exercise Question 2) to perform a statistical test on whether a customer would recommend the Bank to their family and friends before the change is dependent on the gender of the customer. (4 points) Recommend Before Gender Yes No Male 28 49 77 Female 22 53 75 50 102 152 Expected 25.33 51.67 24.67 50.33 Difference Square/Expected 0.282 0.138 0.289 0.142
Test Statistic 0.851 H0: whether a customer would recommend the Bank to their family and friends before the change is not dependent on the gender of the customer Ha: whether a customer would recommend the Bank to their family and friends before the change is dependent on the gender of the customer Let alpha=0.05 d.f.=(1-1)*(2-1)=1 Reject H0 if chi square statistic>3.841 Chi Square statistic=0.851 Since chi square statistic=0.851<3.841, we do not reject H0 and conclude that whether a customer would recommend the Bank to their family and friends before the change is not dependent on the gender of the customer