Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need to get this questions done using the excel in the picture A) show sales (totalcharge) by year and by store, (Hint: to get

I need to get this questions done using the excel in the picture
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
A) show sales (totalcharge) by year and by store, (Hint: to get year, add another column and use the = YEAR() function to get the year of the order's date. Now add items sold (items). Analyze the results. Make a chart which shows items and sales by year and location. What inferences can you make from thilsata? B) Do separate analysis to show total sales for each year by store location and category. Make a chart and then Discuss the resuits what does your analysis indicate about sales trends for the company? C) Who were the top 3 sales people (total sold) in 2016? Who were the top 3 in 2017 ? A) show sales (totalcharge) by year and by store. (Hint: to get year, add another column and use the =YEAR0 function to get the year of the order's date. Now add items sold (items). Analyze the results. Make a chart which shows items and sales by year and location. What inferences can you make from this data? B) Do separate analysis to show total sales for each year by store location and category. Make a chart and then Discuss the results what does your analysis indicate about sales trends for the company? C) Who were the top 3 sales people (total sold) in 2016? Who were the top 3 in 2017 ? 11111111111111111111111111111111111111111111111111111111111111 111111111131111111111111111111111111111111111111111,1111111111111 [11111111111111111111111111111111111111111111111111111111111111

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Seven NoSQL Databases In A Week Get Up And Running With The Fundamentals And Functionalities Of Seven Of The Most Popular NoSQL Databases

Authors: Aaron Ploetz ,Devram Kandhare ,Sudarshan Kadambi ,Xun Wu

1st Edition

1787288862, 978-1787288867

More Books

Students also viewed these Databases questions