This assignment will give you an opportunity to discover
This assignment will give you an
opportunity to discover the power of simple analytic tools built into the
Microsoft Excel program. You will create a number of tables responding to
questions pertaining to the data in the tables in Part 1. In Part 2 you will
analyze the data and respond to questions.
General Information:
Use the following information to
ensure successful completion of the assignment:
• Use
“MGT-820-R-WorkingwithPivotTablesT5.xlsx” to complete this assignment.
• APA style for their writing
assignment
Directions:
Part 1
Using the data in the
MGT-820-RS-WorkingwithPivotTablesT5.xlsx
file, create Pivot Tables to be able to respond to the questions in Part 2.
Part 2
Using the data tables you created
in the previous section or by creating new tables, write a report (750-1,000
words) that addresses the following questions:
• Are all sales persons operating
at the same efficiency?
• Are all cities producing the
same results?
• Is one product performing better
in one city as compared to another city?
• Based on the results, what
trends have you identified? What action(s) would you recommend to senior
management?
• Based on your use of the Pivot
Table:
o Was it easy to use?
o Would you use it again to
analyze data?
o Looking at month/year, revenue,
and returns, what can be said about the results of the sales force?
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
