Exhibit 11.6 The Following Questions Use the Data Below

Multiple Choice

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)