Use the data in busi1013 bank datasetxlsx from unit 1

2. Use the data in BUSI1013 Bank Dataset.xlsx (from Unit 1 Exercise Question 2) to answer this question. (
points each; 8 Points in total )
a. Perform a statistical test to see whether the proportion of members who would
recommend the Bank to their family and friends have increased because of the
change.
4

09/03/2019 BUSI 1013 Emily Thompson
3. A national retailer has completed an internal survey on its social media strategy. The key question in the
survey is whether the stores managers think that the recently-launched social media strategy is effective. The
following is the output of a statistical analysis of the data:
Social Media Strategy is effective Total
Store Managers No Yes
West Region 15 35 50
Central Region 10 28 38
East Region 45 50 95
Total 70 113 183
Based on this output, can the retailer conclude that the opinion of the store managers on the whether the
recently-launched social media strategy is effective is dependent on which region they belong to? Use a chi
square test and a level of significance of 0.05. (