create at least two-three different pivot tables (or pivot c
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)Excel 97-2003 format data file (.xls)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.
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.
