Q 48

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. img -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)

Multiple Choice