Chat with us, powered by LiveChat This assignment will give you an opportunity to discover | acewriters

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
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?

error: Content is protected !!