Question

Please finish the following assignment in Excel.

1. Ignoring price, create a chart that displays the seasonality of cranberry sales.
2. Ignoring price, create a chart that shows whether there is an upward trend in sales.
3. Determine average sales per quarter, breaking it down based on whether your price was higher or lower than the competitor’s price. You can use the following function to transform the price into a category variable:  “=IF(J14<K14,"Higher Price", "Lower Price")”

Year	Quarter	Units	Competitor Price	My Price
2006	1	453.4041	4.05	4.74
2006	2	454.8513	4.81	5.28
2006	3	523.9836	5.42	4.43
2006	4	578.7019	4.31	5.02
2007	1	608.5591	4.71	4.11
2007	2	577.5938	4.88	4.52
2007	3	571.9	5.81	4.41
2007	4	660.0556	4.14	4.87
2008	1	443.501	4.58	5.3
2008	2	390.6668	4.2	5.07
2008	3	429.6064	4.24	5.14
2008	4	788.3224	5.89	4.66
2009	1	581.585	5.2	4.52
2009	2	503.9166	5	4.86
2009	3	499.7705	4.5	4.63
2009	4	936.1867	5.05	4.25
2010	1	459.4822	5.42	4.94
2010	2	470.638	4.57	4.58
2010	3	349.4878	5.06	5.78
2010	4	912.5367	5.28	4.16
2011	1	400.3611	4.93	5.5
2011	2	528.4768	4.34	4.33
2011	3	605.8438	5.23	4.46
2011	4	574.5326	5.62	5.53

Answer 1

Answer: