Question: Using data in Table 2, respond to the following. Present a graph to observe the behavior of the dat Is there seasonality? Is there a

  1. Using data in Table 2, respond to the following.

  1. Present a graph to observe the behavior of the dat Is there seasonality? Is there a positive or negative trend? Explain based on the graph. (Value: 5% total).
  2. Report the values of the intercept and the coefficient of the slope for the linear regression. (Value: 5% total).
  3. Use the parameters obtained in the linear regression to calculate the forecast (Ft) for periods 1 to 24. (Value: 5% total).
  4. Calculate MAPE, MSE, and MAD for the forecast calculated in part (c). (Value: 5% total).
  5. Using the results of part (b), calculate forecast (Ft) for periods 25 to 30. (Value: 5% total).

Using data in Table 2, respond to the following.

Table 2. Records of demand for Linear Regression. Period Actual demand [u] Period Actual demand [u] 1 1359 13 426 2 1302 14 459 3 1323 15 462 4 16 411 1305 1332 5 17 429 6 18 468 1356 924 7 19 137 8 864 20 147 9 897 21 153 10 888 22 168 11 900 23 174 12 957 24 131

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!