Quarterly GDP Data by State for Midterm 2 Excel file from the Midterm Exam 2 content area on our class D2L site. Find your name in the table below. Please note that states are not assigned alphabetically so you may need to search through the list for your name. You will use the data from that state for this problem. (If you wish, you may delete the other columns from the Excel file.) a. Create a 3-period moving average forecast, an exponential smoothing forecast with alpha=0.3, and a linear trend forecast for your data. b. Calculate the MSE, MAPE and MAE for each forecast developed in (a). c. Plot the original series, and each of the forecasts. d. Create a forecast for the first quarter of 2018 using each of the three techniques in (a). If you had to choose one of these, which would you choose and why?

management science