I would like you to create a spreadsheet that calculates a weighted average forecast, and charts it as an xy plot, where time is on the x axis.

The data is as follows:

Actual observations at times T₁ through T₅ are:

Time	1	2	3	4	5
Observations	5	7	8	11	12

You should compute the weighted average forecast for Times T₁ through T₆.

The weighting factors are 0.2,0.3, and 0.5, 0.2 applies to the earliest, 0.3 to the middle, and 0.5 to the latest.

Explain/justify how you derived the forecast at T₁ and T₂.

Repeat the exercise, but now change the weighting factors.

Explain what were you trying to achieve, how successful you were, and describe any limitations you see with technique.