Consider the following daily time series representing the number
of clients visiting the Small Business Development Center over the
previous 10 days.
| Day | Clients |
|---|---|
| 1 | 1 |
| 2 | 2 |
| 3 | 1 |
| 4 | 3 |
| 5 | 0 |
| 6 | 2 |
| 7 | 1 |
| 8 | 1 |
| 9 | 4 |
| 10 | 1 |
Step 1 of 3: What is the 3-day Moving Average Forecast for day
11 (t = 11)?
Round to 2 decimal places.
Step 2 of 3: What is the 4-day Moving Average Forecast for day
11 (t = 11)?
Round to 2 decimal places.
Step 3 of 3: What is the 5-day Moving Average Forecast for day
11 (t = 11)?
Round to 2 decimal places.
Can you show me how to do this in excel? Any help would be appreciated!
Step 1 of 3
| Day | Clients | 3-day moving average |
| 1 | 1 | |
| 2 | 2 | |
| 3 | 1 | |
| 4 | 3 | 1.333333333 |
| 5 | 0 | 2 |
| 6 | 2 | 1.333333333 |
| 7 | 1 | 1.666666667 |
| 8 | 1 | 1 |
| 9 | 4 | 1.333333333 |
| 10 | 1 | 2 |
| 11 | 2 |
The forecasted value of the number of clients by 3-day moving average method for the say 11 is 2
Step 2 of 3
| Day | Clients | 4-day moving average |
| 1 | 1 | |
| 2 | 2 | |
| 3 | 1 | |
| 4 | 3 | |
| 5 | 0 | 1.75 |
| 6 | 2 | 1.5 |
| 7 | 1 | 1.5 |
| 8 | 1 | 1.5 |
| 9 | 4 | 1 |
| 10 | 1 | 2 |
| 11 | 1.75 |
The forecasted value of the number of clients by 4-day moving average method for the say 11 is 1.75
Step 3 of 3
| Day | Clients | 5-day moving average |
| 1 | 1 | |
| 2 | 2 | |
| 3 | 1 | |
| 4 | 3 | |
| 5 | 0 | |
| 6 | 2 | 1.4 |
| 7 | 1 | 1.6 |
| 8 | 1 | 1.4 |
| 9 | 4 | 1.4 |
| 10 | 1 | 1.6 |
| 11 | 1.8 |
The forecasted value of the number of clients by 5-day moving average method for the say 11 is 1.8
Get Answers For Free
Most questions answered within 1 hours.