Question: Can someone help me with this problem, Thank you 2) Problem #2: -44.31 Emergency calls to the 911 system of Durham, North Carolina, for the

Can someone help me with this problem, Thank you

Can someone help me with this problem, Thank you 2) Problem \#2:

2) Problem \#2: -44.31 Emergency calls to the 911 system of Durham, North Carolina, for the past 24 weeks are shown in the following table: a) Select any 3 alpha values for an exponential smoothing forecast, and determine which alpha is the better one using the MAPE to measure the forecasting error. b) Using the alpha found in part a), find the forecast for week 25 using exponential smoothing. c) Using the alpha in a) and =0.2, and assuming that the initial forecast was 50 calls, and the initial trend is 1 , find the forecast for week 25 using a trend-adjusted exponential smoothing model. d) Using MAPE to measure the forecast error, determine which of the two methods ( b and c ) is a better method for this data. You are expected to use one of the LOOKUP functions

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!