2) Insert a column to the left of column C. In cell C5 type Month, in cell E5 type MA3 3) Cells C6 to C41: Fill in with numbers 1-36 (you will have to reformat the column to general) 4) Cells E6 to E39: Place a 3 period moving average. 5) --Create MA3 regression --Column C data is independent (X) variable (C5:C39); Column E data is dependent (Y) variable (E5:E39) --Place he regression output on cell G3 6) Cell F39: type FC; Cell G39: type % error --Calculate a forecast for the next two months: Year 4-Jan & Feb (i.e. 35, 36), and place them in cell F40 and F41 --In cell G40 and G41 calculate the % error for your two forecasts 7) Create a scatter plot with the MA data in column E. Title it MA3. Cut and paste the graph into the Graphs sheet below the previous graph.

the data is as follows

New Car Retail Sales
Year	Month	Units
1	Jan	39,810
1	Feb	40,081
1	Mar	47,440
1	Apr	47,297
1	May	49,211
1	Jun	51,479
1	Jul	46,466
1	Aug	45,208
1	Sep	44,800
1	Oct	46,989
1	Nov	42,161
1	Dec	44,186
2	Jan	42,227
2	Feb	45,422
2	Mar	54,075
2	Apr	50,926
2	May	53,572
2	Jun	54,920
2	Jul	54,449
2	Aug	56,079
2	Sep	52,177
2	Oct	50,087
2	Nov	48,513
2	Dec	49,278
3	Jan	48,134
3	Feb	54,887
3	Mar	61,064
3	Apr	53,350
3	May	59,467
3	Jun	59,370
3	Jul	55,088
3	Aug	59,349
3	Sep	54,472
3	Oct	53,164
3	Nov	48,793
3	Dec	46,956
4	Jan	44,562
4	Feb	52,934