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)

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

Quizplus · Accepted Answer

The Answer of 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)

Exhibit 11.6 The Following Questions Use the Data Below