Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

0 Hint by talking to your manager's assistant you've learned the expectations for the report are demonstrating use of Excel 's conditional formatting feature and

image text in transcribed
0 Hint by talking to your manager's assistant you've learned the expectations for the report are demonstrating use of Excel 's conditional formatting feature and evaluating AVERAGE spend (not total spend). It's expected that you will address the following specific questions for the overall dataset. a. What are the customer ID '5 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 b. Which gender has the highest average spending and what is the amormt? (identify each gender and their average spending on your submission document) c. 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) d. Which country has the highest average spend per customer and what is the amormt? (Identify all countries and the average spending) - record the amorult on your submission document 2. 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: CISBBBO HW3 Lnamaname.docx and Ci53380 HW3 Lnamaname.xlsx

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cost Accounting

Authors: William K. Carter

14th edition

759338094, 978-0759338098

Students also viewed these Accounting questions

Question

=+7. For the cost matrix of Exercise 3,

Answered: 1 week ago