1 page in 1 hour (Due 3pm pst friday)

Case Problem 1 Use the data and case description in BUSI1013-Case.xls to answer this question. Summarize the following variables using one graph (e.g., pie chart, histogram, etc.) (8 points) Loans Before Recommend Before Loans After Recommend After Summarize the following variables using one or more statistical measures (e.g., percent, sample mean, etc.) (8 points): Loans Before Recommend Before Loans After Recommend After Based on the above, would you consider the pilot to be successful? (4 points): Case Problem 2 A retail chain sent out a “Buy More Save More” coupon to each of the customers who own a loyalty card in its 61 stores. The objective was to get these customers to redeem the coupon and buy at least 2 items from the stores. Results of this promotional campaign were recorded in the BUSI1013-Case Question 2.xls file. Evaluate the following probabilities: (2 points each, 8 points in total) The probability of customers redeemed the coupon and purchased at least 2 items in each of the three regions. The probability of customers who redeemed a coupon. The probability of customers purchased at least 2 items. The probability of customers purchased at least 2 items if they redeemed the coupon. Based on the above, provide a ranking of the stores in each region. (6 points) State the criteria you used to rank the stores and your rationale for the choice. (4 points)