Exhibit 11.6
The following questions use the data below.
A store wants to predict quarterly sales. The owner has collected 3 years of sales data and wants your help in analyzing the data using the double moving average model with k = 4.
-Refer to Exhibit 11.6. What formula should be entered in cell F9 to compute the second average when using the double moving average method with k = 4?
A) =Average($E$3:$E$9)
B) =Average($D$3:$D$9)
C) =Average(D3:D9)
D) =Average(D6:D9)

Question

Exhibit 11.6
The following questions use the data below.
A store wants to predict quarterly sales. The owner has collected 3 years of sales data and wants your help in analyzing the data using the double moving average model with k = 4. 
-Refer to Exhibit 11.6. What formula should be entered in cell F9 to compute the second average when using the double moving average method with k = 4?
A) =Average($E$3:$E$9) 
B) =Average($D$3:$D$9) 
C) =Average(D3:D9) 
D) =Average(D6:D9)

Quizplus · Accepted Answer

To compute the second average, we need to take the average of the first k values in column D. Since k is equal to 4, we need to take the average of cells D6:D9. Thus, the correct formula is =Average(D6:D9).

Exhibit 11.6 The Following Questions Use the Data Below