I have an excel file with data for problem, you can either give me steos and walk me through problem, or comment and I can send you the excel file which is my preferred option

Final Assignment BUS 102 Due date: 6/4/2022 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. Write the null hypothesis, and alternative hypothesis and interpret the result of your test. (8 points) Context The growth of supermarkets in most populated cities are increasing and market competitions are also high. This dataset is one of the historical sales of supermarket company which has recorded in 3 different branches for 3 months data. Attribute information Branch: Branch of supercenter (3 branches are available identified by A, B and C). Customer type: Type of customers, recorded by Members for customers using membership card and Normal for without membership card. Gender: Gender type of customer Product line: General item categorization groups - Electronic accessories, Fashion accessories, Food and beverages, Health and beauty, Home and lifestyle, Sports and travel Unit price: Price of each product in $ Quantity: Number of products purchased by customer Total: Total spending on that purchase Payment: Payment used by customer for purchase (3 methods are available - Cash, Credit card and Ewallet) Rating: Customer stratification rating on their overall shopping experience (On a scale of 1 to 10) Final Assignment BUS 102 Due date: 6/4/2022 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. Write the null hypothesis, and alternative hypothesis and interpret the result of your test. (8 points) Context The growth of supermarkets in most populated cities are increasing and market competitions are also high. This dataset is one of the historical sales of supermarket company which has recorded in 3 different branches for 3 months data. Attribute information Branch: Branch of supercenter (3 branches are available identified by A, B and C). Customer type: Type of customers, recorded by Members for customers using membership card and Normal for without membership card. Gender: Gender type of customer Product line: General item categorization groups - Electronic accessories, Fashion accessories, Food and beverages, Health and beauty, Home and lifestyle, Sports and travel Unit price: Price of each product in $ Quantity: Number of products purchased by customer Total: Total spending on that purchase Payment: Payment used by customer for purchase (3 methods are available - Cash, Credit card and Ewallet) Rating: Customer stratification rating on their overall shopping experience (On a scale of 1 to 10)