Office Warehouse Inc. currently makes four products. The Sales Director has asked you to run...

50.1K

Verified Solution

Question

Accounting

Office Warehouse Inc. currently makes four products. The Sales Director has asked you to run a preliminary analysis on last year's
sales data, which has been cleaned and is given on the Original Data tab. The products made by the company and sales price per unit
are listed below. Use the different data visualization methods recommended in each requirement to analyze the company's sales data.
Now, create a PivotTable to determine the monthly sales earned by each region. Use that data to create a 2D clustered column chart.
Based on that column bar chart, identify the regions that had the highest and lowest monthly sales for the entire year.
image

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students