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 E6 (and copied to E7:E14) to compute the first average when using the double moving average method with k = 4?
A) =Average($E$3:$E$6)
B) =Average($D$3:$D$6)
C) =Average(D3:D6)
D) =Average(D5:D6)

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 E6 (and copied to E7:E14) to compute the first average when using the double moving average method with k = 4?
A) =Average($E$3:$E$6) 
B) =Average($D$3:$D$6) 
C) =Average(D3:D6) 
D) =Average(D5:D6)

Quizplus · Accepted Answer

The correct formula to compute the first average using the double moving average method with k = 4 is =Average(D3:D6). This formula calculates the average of the first four data points in column D, which is necessary for the initial step in the double moving average method.

Exhibit 11.6 The Following Questions Use the Data Below