solved All the highlighted parts need to be filled in on
All the highlighted parts need to be filled in on Module 29 worksheet. Module 28 has to be used to complete Module 29. It is complete and attached. Questions:For SES solutions, use α = 0.1. For Holt solutions, use α = 0.95 and β = 0.01. 1. Recall the forecast produced for assignment 3 in Module 28 for the Northland special revenue fund. The original data are provided in Table 29.1.
a. Using the same initial data and assumptions, refine the forecast using the exponential
smoothing method appropriate for nontrending data.
b. Produce a graph showing the original data, the 5-year moving average forecast from Module 28, and the forecast produced using the exponential method.
c. Which forecast would you recommend using, and why? Graphs are on first page of excel and highlighted areas are on second page. The graph can be found on pg. 57:https://study.sagepub.com/sites/default/files/Modu…