can u show how we answer this in excal

Not yet answered Marked out of 50.00 Construct forecasting spreadsheet models to analyze this data. Note: below is a Ink to click and download the data in .csv format. This will save you some typing & reduce the chances of a data entry error. Copy the date table from this csv file to your Excel file. Do all your work in the Excel file. The osv file will NOT save any programming. 1 https://eaming.semo.edu/pluginfile.php/3363971/question questiontext/3510543/18/18237095/OM352 2020 Sum OL E data via You can also try to copy & paste the table below if you can't get the datafile to work P mg question Time (1) A(U) 1 1321.6 2 1347.2 3 13283 1311.5 5 1305.4 I 6 1315.6 7 1284.7 8 1277.8 9 Don't have Create forecasts of the data using the following methods Weighted Moving Average with n=3 and weights of 0.60, 0.25, and 0.15 Linear Trend. Use as Y-axis Intercept = 1,350.0 & b= slope parameter 1.000 to start with Use Solver with the forecasting table to optimize the forecasts with this method. Use MSE as the criteria. 1. Calculate the Forecasts, Forecast Errors, Mean Absolute Deviation (MAD). Mean Square Error (MSE), and Mean Absolute Percent Error (MAPE) using the methods listed above. Your answers should be calculated to three (3) decimal places 2. What is the Forecast for Period 9? What is the MAD. MSE, and MAPE? Type your answers in the textbox below AFTER the appropriate labels in the box so they are easier for me to read and grade. 3. Which of these methods produces the best forecasting it MSE is the criteria? Explain your reasoning. Make sure you've uploaded the final copy of the file [it's very common for someone to create a spreadsheet, save it under the approved name, work on the file, and then upload the file to the Dropbox without remembering to save it again. This means the initial incomplete, half-worked on file is the one turned in.] 7 T: - I B I U S X2 9. $3 !