2. Write a VBA function (not a macro) to implement the moving average method that takes the

observations of a time series and the order parameter k as input and outputs the forecast for the next

time period in the series. This has to be implemented and a built-in excel function is not acceptable.

(15 marks)