create at least two-three different pivot tables (or pivot charts) to answer the following questions. Then anslyse it.
please write half page first draft( like what are you going to do) and then write the final draft. using two document to sparete first draft and final draft please. and the requirement is below. please follow the pivot table rubric.
Part One – Basic Pivot Tables (3 points)Excel 2007 format data file (.xlsx)
Using the Excel spreadsheet found above, create at least two-three different pivot tables (or pivot charts) to answer the following questions.
- What do the numbers/data tell us about the purchases in each region?
- What form of payment is most common?
- Do our customers shop online?
Please submit the pivot tables that you used to answer each question together with your essay via canvas on March 17 at 11:59am.
Part Two â€“ Analysis (5 points)
This is a written component that is designed to test your critical thinking ability.
The companyâ€™s approach has been to distribute advertising efforts equally between web banner ads and email ads, and to give equal resource levels to each area. What are the weaknesses of this approach?
Also, what changes would you suggest to their advertising plan? For example, should the company cease all advertising in the North? concentrate on web banner ads of books in the South? stop using PayPal? etc.
Present your answer in paragraph form. Be sure to include all pivot tables or other charts that you used in your decision-making process.
Your grade for Part Two of this assignment will be based on correct identification of the problem, identification of any underlying assumptions, the quality of your supporting data, and the clarity of your conclusions. Please consult Canvas for the grading rubric.