Exhibit 11.6 The Following Questions Use the Data Below

question 96

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)