Question

question 19: The number of passengers arriving at San Francisco on the Amtrak cross-country express on 6 successive Mondays were: 60, 72, 96, 84, 36, and 48.
Referring to Table 16-5, the number of arrivals will be smoothed with a 3-term moving average. The first smoothed value will be ________.

question 20: The number of passengers arriving at San Francisco on the Amtrak cross-country express on 6 successive Mondays were: 60, 72, 96, 84, 36, and 48.
Referring to Table 16-5, the number of arrivals will be smoothed with a 3-term moving average. The last smoothed value will be ________.

question 21: Referring to Table 16-5, the number of arrivals will be exponentially smoothed with a smoothing constant of 0.1. The smoothed value for the second Monday will be ________.

question 22: Referring to Table 16-5, the number of arrivals will be exponentially smoothed with a smoothing constant of 0.1. Then the forecast for the seventh Monday will be ________.

Answer 1

Solved the above one in excel. the formulas for each calculation below

Hope the above answer has helped you in understanding the problem. Please upvote the ans if it has really helped you. Good Luck!!