Task 9: Analysis on your part by answering these questions on the Answer Sheet:

Your manager at Foodmart is expecting you to showcase your Excel skills and deliver a brief report with your findings from the analysis youve completed. As a graduate of Texas State he expects you have the decision-making skills and judgement to develop a final report and allows you to decide what material to present, how to present it and complete it on-time.

Hint by talking to your managers assistant youve learned the expectations for the report are demonstrating use of Excels conditional formatting feature and evaluating AVERAGE spend (not total spend). Its expected that you will address the following specific questions for the overall dataset.

What are the customer IDs of the top 5 spending customers for each country (For each customer, be sure and the amount the customer spends) - record these on your submission document

Which gender has the highest average spending and what is the amount? (identify each gender and their average spending on your submission document)

Which age group has the lowest average spending and what is the amount? (Identify all age groups and their spending, be sure to highlight the highest - record the amount on your submission document)

Which country has the highest average spend per customer and what is the amount? (Identify all countries and the average spending) - record the amount on your submission document

Given all information we have about customers, what one action do you recommend we take to increase sales and why? (Record your answer on your submission document) Note: Your answer limited to 5 sentences)

Deliverable #3: CIS3380_HW3_ LnameFname.docx and CIS3380_HW3_LnameFname.xlsx