12 13 14 15 16 Important: Re. the quantitative problems, do all calculations in Excel. I'd like to see your work. Just one number in a cell as an answer without the formula or calculations behind it is not sufficient, you will not get points for that. Home Data Insert Draw Formulas BI U abe Review View A .. Calibri (Body) 14 AB EX 123 fx A B D E F 1 The table on the right shows widget sales by the time of the day. 25 pts. 2 3 Month 1 a. Visualize the time series. Is it stationary or non-stationary? Explain. 3 pts 4 5 6 Month 2 7 b. Use the trend function to forecast morning, afternoon, and evening sales for Month 6. State the trend model. Measure the accuracy of the forecast and explain the meaning of the numerical measure you used. 9 pts 8 9 Month 3 Widget sales (1000) 10 8 15 16 14 19 18 14 21 25 20 28 50 46 54 10 11 morning afternoon evening morning afternoon evening morning afternoon evening morning afternoon evening morning afternoon evening morning afternoon evening c. Use trend + seasonal variations method to forecast morning, afternoon, and evening sales for Month 6. State the model, measure its accuracy, and explain the meaning of the accuracy measure you got. 13 pts 12 Month 4 13 14 15 25 pts. Month 5 16 17 18 Month 6 19 20 21 22 23 24 25