i need the values for smoothed level forecast for next period forecast error
Widget Sales Volume Smoothed Level Forecast for Next Period Forecast Error Squared Error Year Month 1 365 381 317 297 389 402 385 349 386 332 389 353 276 . 317 Seq No. 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 13 14 15 16 17 18 19 20 21 22 23 24 2 January February March April May June July August September October November December January February March April May June July August September October November December January February March April May June July August September October November December 394 334 384 324 344 337 351 362 314 365 285 328 378 326 393 304 354 317 321 357 297 358 3 Times 2 pts 1 Minute 32 Second We need to start with a value for lo Use the monthly average of sales volume for the first year as What is the value of to? 360.4167 @ 3612500 3620833 360.6667 Question 2 2 pts Assume an initial value of 0.4 for the exponential smoothing factor (Le alpha-041 What is the exponentially smoothed value of level for the first period 01.12 362.7500 363 2500 361.2000 362.2500 Question 3 2 pts What is the forecasted value and error for period 1. respectively! 360.4167.45833 361.2500.37500 360.6667. 1.3333 362.0633.29167 Question 4 2 pts What is the estimated level for the second period (1) 369.7500 3700500 370 3500 369.1200 Question 5 2 pts punt Populate the rest of the table. What is the value of SSE? s Doard 35688 53408 ses 54394 8 ups 53033 dar D 9 2 pts Question 6 ry Now use Solver to minimize the SSE by changing the value of alpha. What is the optimal alpha value? 0.0782 0.0774 0.034 0.0623 Question 7 2 pts Account What is the optimal value of the standard error? Dashboard 35.02 Courses 3463 34.95 28 Groups 3533 Calendar 2 pts 6 D Question 8 Inbox What are the forecasted values for January, February and March of year periods 37.38 and 39? 4 History 341 13.341.13.341.13 Help 339.6971.341.1275, 314.4677 344 76.344.76.344.76 O 340-36, 340, 36, 340 36 O 341.13.341.13.341.13 339.6971.341.1275.314.4677 O 344.76, 344.76.344.76 340,36,340.36.340.36 Question 9 2 pts Assume the sales in January of year 4 jumps to 400 units. What impact will it have on the forecasted value for February of year 4 (period 38)? Increase to 400.00 Increase to 345.73 Increase to 344.98 Increase to 348.20 Submit Quiz No new data to save. Last checked at 12:42pm Widget Sales Volume Smoothed Level Forecast for Next Period Forecast Error Squared Error Year Month 1 365 381 317 297 389 402 385 349 386 332 389 353 276 . 317 Seq No. 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 13 14 15 16 17 18 19 20 21 22 23 24 2 January February March April May June July August September October November December January February March April May June July August September October November December January February March April May June July August September October November December 394 334 384 324 344 337 351 362 314 365 285 328 378 326 393 304 354 317 321 357 297 358 3 Times 2 pts 1 Minute 32 Second We need to start with a value for lo Use the monthly average of sales volume for the first year as What is the value of to? 360.4167 @ 3612500 3620833 360.6667 Question 2 2 pts Assume an initial value of 0.4 for the exponential smoothing factor (Le alpha-041 What is the exponentially smoothed value of level for the first period 01.12 362.7500 363 2500 361.2000 362.2500 Question 3 2 pts What is the forecasted value and error for period 1. respectively! 360.4167.45833 361.2500.37500 360.6667. 1.3333 362.0633.29167 Question 4 2 pts What is the estimated level for the second period (1) 369.7500 3700500 370 3500 369.1200 Question 5 2 pts punt Populate the rest of the table. What is the value of SSE? s Doard 35688 53408 ses 54394 8 ups 53033 dar D 9 2 pts Question 6 ry Now use Solver to minimize the SSE by changing the value of alpha. What is the optimal alpha value? 0.0782 0.0774 0.034 0.0623 Question 7 2 pts Account What is the optimal value of the standard error? Dashboard 35.02 Courses 3463 34.95 28 Groups 3533 Calendar 2 pts 6 D Question 8 Inbox What are the forecasted values for January, February and March of year periods 37.38 and 39? 4 History 341 13.341.13.341.13 Help 339.6971.341.1275, 314.4677 344 76.344.76.344.76 O 340-36, 340, 36, 340 36 O 341.13.341.13.341.13 339.6971.341.1275.314.4677 O 344.76, 344.76.344.76 340,36,340.36.340.36 Question 9 2 pts Assume the sales in January of year 4 jumps to 400 units. What impact will it have on the forecasted value for February of year 4 (period 38)? Increase to 400.00 Increase to 345.73 Increase to 344.98 Increase to 348.20 Submit Quiz No new data to save. Last checked at 12:42pm
