Q 47

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 E6 (and copied to E7:E14) to compute the first average when using the double moving average method with k = 4?
A)=Average($E$3:$E$6)
B)=Average($D$3:$D$6)
C)=Average(D3:D6)
D)=Average(D5:D6)

Q 49

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)

Q 50

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 I16 to compute the forecast for time period 14?
A)=I15+2*$H$14
B)=G14+B16*H14
C)=G14+3*H14
D)=G12+H12