I will give you excel document, you should use it for analysis.
Now let’s test your ability to think critically. This is also a small writing assignment.
Our company’s approach has been to divide advertising efforts evenly between web banner ads and email ads, and to give each region equal levels of resources. What are the weaknesses
Also, what changes would you suggest to our advertising plan?
For example, should we stop all advertising in the North? Concentrate on web banner ads of books in the South? Stop using PayPal? YaddaYadda
Write your answer in memo form.
Be sure to include all pivot tables or other charts that you used to help make this decision. (I did the pivot table and chart in the excel document to help you solve the question)
Grade for this assignment will be based on:
- correctly identifying the problem, (15 points)
- identifying any assumptions, (15 points)
- quality supporting data, (15 points)
- clarity of conclusions. (15 points)
What to submit:
Your Workbook and Memo with the correct naming convention i.e. . YourLastNameYourFirstNameA4
Please use appropriate memo format (If you do not know what a typical memo looks like â€“ google it.