Download the file Final_$22.xlsx from the Final Assignment folder on D2L. This file contains information about the sales in a chain supermarket. I also posted the file Final_Codebook for information regarding the variables on the Excel file. You must submit your Excel file that contains your answers and includes your works. In addition, you can also submit a Word document with your written answers. Please answer each question on the worksheet that is labeled as the question number. I need to see how you found the answers on your Excel file.
1) Find total spending on each branch (A, B, and C) and show their shares on a pie chart. (8 points)
2) Find the average ratings for each product line. Also, find the average rating for each branch. How do these numbers help to make a better managerial decision regarding the performance of sales personnel for product lines and branches? (8 points)
3) What percentage of female shoppers did use credit cards for payments? What percentage of male shoppers used credit cards? If there is any difference, then is it ethically acceptable to offer better deals to apply for a credit card than the other gender? (6 points)
4) Compare the average total spending by Normal shoppers versus Member shoppers. Which one is bigger? If someone claims that the two groups spend equally on average, use a t-test to verify this claim.
