Question C: Complete the following analysis with the techniques covered in class (50%)
In the analysis, apply conditional formatting to highlight all "bad" in light red fill with dark red text and highlight all good with green fill with dark green text
Date	F	Quarter	Annual Moving Average	Seasonal Factor	Seasonal Index	Theoretical Values	Analysis		Quarter	Raw factor	Normalized Factor
6/29/07	44,955
9/28/07	40,853
12/31/07	43,841
3/31/08	43,190
6/30/08	41,793
9/30/08	32,049
12/31/08	29,236
3/31/09	24,778
6/30/09	27,189
9/30/09	30,892
12/31/09	35,449
3/31/10	31,566
6/30/10	35,067
9/30/10	29,893
12/31/10	32,428
3/31/11	33,114
6/30/11	35,527
9/30/11	33,047
12/30/11	34,576
3/30/12	32,445
6/29/12	33,211
9/28/12	32,172
12/31/12	36,424
3/28/13	35,810
6/28/13	38,095
9/30/13	35,976
12/31/13	37,036
3/31/14	35,876
6/30/14	37,411
9/30/14	34,920
12/31/14	35,870
3/31/15	33,900
6/30/15	37,263
9/30/15	38,144
12/31/15	40,251
3/31/16	37,718
6/30/16	39,485
9/30/16	35,943
12/30/16	38,654
3/31/17	39,146
6/30/17	39,853