Question 6 (1 point) (a) Forecast from 3-week moving average is % (e.g., if forecast is 7.34%, state -7.34 without the % sign) Your Answer: Answer Question 7 (1 point) (a) MSE from 3-week moving average (round to 5 decimal places, e.g., 0.00698) Your Answer: Answer Question 8 (2 points) (b) After filling in column E for the expo, smoothing forecasts, copy and paste here the exact Excel formulas you have in cell E9 (2nd wk forecast) and cell E10 (3rd week (b) After filling in column E for the expo. smoothing forecasts, copy and paste here the exact Excel formulas you have in cell E9 (2nd wk forecast) and cell E10 (3rd week forecast). (The answer should include the = sign and no spaces. $ signs should be included as appropriate. Examples of acceptable formats: =E8,=$G$6 (1$G$6)/F27)) Cell E9: A Cell E10: Question 9 (1 point) (b) MSE from exponential smoothing with alpha =0.3 (round to 5 decimal places, e.g. 0.00698) Your Answer: Answer 5 -week moving average forecast for week 13 ? (round your answer to 2 nd decimal digit) Your Answer: Answer Question 4 ( 1 point) 5-week moving average MSE? (round your answer to 3rd decimal digit) Your Answer: Answer Question 5 (1 point) Best \# of weeks to use? 3 4 5 Gasoline Sales \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline & Actual & 3 werk & Squared & 4 weok & Squared & 5-week & Squared \\ \hline & Sales & Mor, Ave. & Efree & Mov. Ave & frrer & May Are & Error \\ \hline 1 & 17 & & & & & & \\ \hline 2 & 21 & & & & & & \\ \hline 3 & 19 & & & & & & \\ \hline 4 & 23 & 19000 & 16000 & & & & \\ \hline 5 & 18 & 21000 & 9000 & & & & \\ \hline 6 & 16 & 20000 & 16.000 & & & & \\ \hline 7 & 20 & 19.000 & 1000 & & & & \\ \hlineB & 1A & $8000 & 0,000 & & & & \\ \hline 9. & 22 & 18.000 & 16000 & & & & \\ \hline 10 & 20 & 20000 & 0000 & & & & \\ \hline 11 & 152 & 20000 & 23.000 & & & & \\ \hline 12 & 22 & 19.000 & 9.000 & & & & \\ \hline \multirow[t]{2}{*}{13?} & 7 & 19.000 & & & & & \\ \hline & & & 10.222 & & & & \\ \hline \end{tabular} (c) The MSE of the better forecasting method is? (round to 5 decimal places, e.g., 0.00698 ) Your Answer: Answer Spreadsheet 3 Question 12 (2 points) (a) Fill in the blanks. (Round each coefficient to the nearest 3rd decimal digit.) Regression equation is: F= Q1+ A Q2+ A Q++ A t Question 13 (2 points) (b) Give the quarterly forecasts for year 7. Question 1 (1 point) 4-week moving average forecast for week 13 ? (round your answer to 2 nd decimal digit) Your Answer: Answer Question 2 (1 point) 4-week moving average MSE? (round your answer to 3rd decimal digit) Your Answer: Answer Question 3 (1 point) 5-week moving average forecast for week 13 ? (round your answer to 2 nd decimal digit) entortelie wit