1. Please use R programing and excel to anser and answer the following questons. Please show all R programing and outputs.

The following data represents demand for tires from the Easyfit tire store over a period of 14 days. Split the data into two equal parts of seven days each. Assume F₁ = 198.

Day	Demand	Day	Demand
1	200	8	208
2	209	9	186
3	215	10	193
4	180	11	197
5	190	12	188
6	195	13	191
7	200	14	196

Complete the following:

Develop a spreadsheet using the first seven days of demand to determine the best exponential smoothing model for values of ? = 0.2, ? = 0.3, and ? = 0.4. Select the model with the smallest absolute deviation for seven periods.

Develop another spreadsheet using the holdout sample for the second seven days to compare the best exponential smoothing model found in part a with a three-period moving average model. Compare the predictions on the basis of the total absolute deviation for the seven periods.

What principles does this problem illustrate?