Question
Tiger Mart is a small grocery store known for its cranberries. The HW1_TigerMart.xls file contains data from each quarter in the years 2006-2011 detailing the
Tiger Mart is a small grocery store known for its cranberries. The HW1_TigerMart.xls file contains data from each quarter in the years 2006-2011 detailing the pounds of cranberries sold by the store. In addition, the file also contains information on stores price and the price charged by a competitor. Analyze the data using Pivot functions and answer the following questions.
a) Ignoring the price, create a chart that displays the seasonality of cranberry sales over the quarters.
b) Ignoring the price, create a chart to determine if there is a trend in the sales over the years?
c) Determine the average sales per quarter, breaking it down based on whether your price was higher or lower than the competitors price. Hint: You can create additional fields using the given data.
**PLEASE SHOW YOUR PIVOT TABLES LAYOUT**
A B E F G H 1 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Year 2006 2006 2006 2006 2007 2007 2007 2007 2008 2008 2008 2008 2009 2009 2009 2009 2010 2010 2010 2010 2011 2011 2011 2011 Quarter Units 1 453.4041 2| 454.8513 3 523.9836 4 578.7019 1 608.5591 2 577.5938 3 571.9 4 660.0556 1 443.501 2 390.6668 3 429.6064 4788.3224 1 581.585 2 503.9166 3 499.7705 4|936.1867 1459.4822 2 470.638 3 349.4878 41 912.5367 1 400.3611 2 528.4768 3 605.8438 4 574.5326 Competitor Price 4.05 4.81 5.42 4.31 4.71 4.88 5.81 4.14 4.58 4.2 4.24 5.89 5.2 5 4.5 5.05 5.42 4.57 5.06 5.28 4.93 4.34 5.23 5.62 My Price 4.74 5.28 4.43 5.02 4.11 4.52 4.41 4.87 5.3 5.07 5.14 4.66 4.52 4.86 4.63 4.25 4.94 4.58 5.78 4.16 5.5 4.33 4.46 5.53Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started