The city golf course is interested in starting a junior golf program.The golf pro has collected data on the number of youths under 13 that have played golf during the last 4 months.Using a three-month moving average (with weights of 5,3,and 1 for the most current value,next most current value and oldest value,respectively),the forecast value for October made at the end of September in the following time series would be __________.
A) 24
B) 21
C) 21.56
D) 19.22
E) 22

Question

The city golf course is interested in starting a junior golf program.The golf pro has collected data on the number of youths under 13 that have played golf during the last 4 months.Using a three-month moving average (with weights of 5,3,and 1 for the most current value,next most current value and oldest value,respectively),the forecast value for October made at the end of September in the following time series would be __________. 
A) 24 
B) 21 
C) 21.56 
D) 19.22 
E) 22

Quizplus · Accepted Answer

To calculate the three-month moving average with the given weights, we need to sum the product of the number of youths and their corresponding weights for the current month, the previous month, and the month before that, and then divide by the sum of the weights (5+3+1=9).

For September, the weights are 5, 3, and 1, and the numbers of youths for July, August, and September are 16, 23, and 25, respectively.

The forecast value for October, made at the end of September, would use the moving averages for August, September, and October, which would be:

(23 x 5) + (25 x 3) + (X x 1) = (115 + 75 + X) / 9

Simplifying this equation, we get:

115 + 75 + X = 9(21.56)
X = 21.56

Therefore, the forecast value for October would be 21.56, rounded to two decimal places. The best choice is C.

The City Golf Course Is Interested in Starting a Junior