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 H9 to compute the trend using the double moving average model with k = 4?

A) =2*(AVERAGE(E9,F9) ) /4
B) =2*(E9-F9) /(4-1)
C) =2*(E9-F9) /(4*2)
D) =2*(D9-F9) /(4-1)