The cranberrydata.xlsx fi le contains data for each quarter in the years 2006-2011 detailing the pounds of cranberries sold by a small grocery store. You also see the store's
a. Ignoring price, create a chart that displays the seasonality of cranberry sales.
b. Ignoring price, create a chart that shows whether there is an upward trend in sales.
c. Determine average sales per quarter, breaking it down based on whether your price was higher or lower than the competitor's price.