3. The cranberrydata.xlsx file contains data for each quarter in the years 2006-2011 detailing the pounds...

 

Transcribed Image Text:

3. The cranberrydata.xlsx file 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 price and the price charged by the major competitor. Use this file to perform the following exercises: 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. 3. The cranberrydata.xlsx file 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 price and the price charged by the major competitor. Use this file to perform the following exercises: 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.

Answer rating: 100% (QA)

a The chart below ... View the full answer