Question: Given the attached data. Answer the following questions using an initial alpha value of 0.2. 1. Compute your forecast for period 51. The potential answers
Given the attached data. Answer the following questions using an initial alpha value of 0.2.
1. Compute your forecast for period 51.
The potential answers are:
A: 5901.35 units.
B: 5663.93 units.
C: 6462.49 units.
D: 7204.02 units.
E: 10407.5 units.
2. Compute the MAD value for period 50.
The potential answers are:
A: 3523.23 units.
B: 2127.42 units.
C: 3292.58 units.
D: 4026.28 units.
E: 4811.36 units.
3. Compute standard deviation of forecast for period 51.
The potential answers are:
A: 2659.28 units.
B: 3404.66 units.
C: 4115.73 units.
D: 5032.85 units.
E: 6014.2 units.
4. Compute the best alpha value to three decimal points.
The potential answers are:
A: 0.001.
B: 0.217.
C: 0.068.
D: 0.261.
E: 0.185.
(Excel attached data below)
| t | At |
| 1 | 1592 |
| 2 | 5478 |
| 3 | 5555 |
| 4 | 7672 |
| 5 | 5309 |
| 6 | 6409 |
| 7 | 8722 |
| 8 | 5285 |
| 9 | 3773 |
| 10 | 3800 |
| 11 | 9565 |
| 12 | 3904 |
| 13 | 4229 |
| 14 | 3798 |
| 15 | 7997 |
| 16 | 2352 |
| 17 | 7059 |
| 18 | 5040 |
| 19 | 4440 |
| 20 | 3864 |
| 21 | 7228 |
| 22 | 4681 |
| 23 | 5951 |
| 24 | 5561 |
| 25 | 7538 |
| 26 | 3407 |
| 27 | 9060 |
| 28 | 5079 |
| 29 | 9079 |
| 30 | 2240 |
| 31 | 2066 |
| 32 | 6838 |
| 33 | 8252 |
| 34 | 6069 |
| 35 | 1791 |
| 36 | 3169 |
| 37 | 4269 |
| 38 | 3040 |
| 39 | 4067 |
| 40 | 3032 |
| 41 | 5004 |
| 42 | 5953 |
| 43 | 8731 |
| 44 | 5218 |
| 45 | 8368 |
| 46 | 10285 |
| 47 | 3430 |
| 48 | 6658 |
| 49 | 8713 |
| 50 | 2538 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
