Please use Excel to do all necessary work and answer the questions for this bonus assignment. The children's museum found that annual visitors are associated with kindergarten enrollment two year prior (e.g., Year 3's number of visitors is correlated with kindergarten enrollment in Year 1 not the same year) in the community. They gathered data of 7 years as below. Please plot the time-series data of the number of visitors in Excel, what pattern(s) do you observe? Select one or more: a. downward trend Please plot the time-series data of the number of visitors in Excel, what pattern(s) do you observe? Select one or more: a. downward trend b. seasonality c. cyclical pattern d. upward trend What would be Year 8 's forecast using a simple exponential smoothing method with alpha of 0.3, and Year 2 follows nave forecast? Round to the nearest integer. Note the final correct answer is based on the calculation using Excel. Answer: By plotting the data, we find that the linear regression is appropriate to use kindergarten enrollment 2 years prior to forecast the number of visitors (you may use scatter plot to double check the association between these two variables). Construct the regression model using any Excel functions introduced in the last video. What is the slope? Round to 4 decimal places. Hint: Think about what are X and Y variables. Year 1 's kindergarten enrollment should be used to forecast Year 3's number of visitors. Answer: What would be Year 8 's forecast using above regression model? Round to the nearest integer. Answer: If you use MAPE as fihe performance measurement, which of the above two forecasting methods would you recommend? Select one: a. regression b. simple exponential smoothing method Clear my choice