***PLEASE HELP!! JUST TWO QUESTIONS, ATTACHED IS A GOOGLE SHEETS WITH EDITING ALLOWED, PLEASE PLEASE PLEASE ANSWER WITH COMPLETED GOOGLE SHEETS DOC, THANK YOU!!!*** IF COMPLETING GOOGLE SHEET ISN'T POSSIBLE, THEN A STEP-BY-STEP OF THE EXCEL FUNCTIONS/FORMULAS PLEASE

https://docs.google.com/spreadsheets/d/1aZZMbeDvW1cuB39evvnn66F28X8tJbDxnKgEXFskwvA/edit?usp=sharing

9.6 - For the data in the Excel file Gasoline Prices, do the following:

a. Develop a spreadsheet for forecasting prices using a simple three-period moving average.

b. Compute MAD, MSE, and MAPE error measures.

9.9 - The Excel file Closing Stock Prices provides data for four stocks and the Dow Jones Industrial Average over a one-month period.

a. Develop a spreadsheet model for forecasting each of the stock prices using simple exponential smoothing with a smoothing constant of 0.3.

b. Compare your results to the output from Excel's Data Analysis tool.

c. Compute MAD, MSE, and MAPE.

d. Does a smoothing constant of 0.1 or 0.5 yield better results?