d.Use the above data to construct a 95% confidence interval for p1- p22. Use the data in BUSI1013 Bank Dataset.xlsx (from Unit 1 Exercise Question 2) to answer this question. (4 points each; 8 Points in total
)
1

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.
b.Construct a 99% confidence interval for the difference of the proportions, before and after the change, of members who would recommend the Bank to their family and friends.3. A national retailer has completed an internal survey on its social media strategy. Thekey 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 effectiveStore ManagersNoYesWest Region1535Central Region1028East Region4550Based on this output, can the retailer conclude that the opinion of the store managers