Multiple Choice
Exhibit 11.12
The following questions use the data below.
Joe's Sporting Goods wants to forecast quarterly sales figures using a seasonal regression model. The store has collected 12 quarters of data and needs your help to analyze the data. The relevant regression output is provided in the following table.
-Refer to Exhibit 11.12. What formula should be entered in cell I3 to compute the Seasonal Value for year 1 Quarter 1?
A) =388.88+10.052*C3+4.248*D3+79.917*E3+296.008*F3+84.924*G3
B) =10.052*C3+4.248*D3-79.917*E3-296.008*F3-84.924*G3
C) =388.88+10.052*C3+4.248*D3-79.917*E3-296.008*F3-84.924*G3
D) =I3+10.052*C3+4.248*D3-79.917*E3-296.008*F3-84.924*G3
Correct Answer:

Verified
Correct Answer:
Verified
Q111: Exhibit 11.12<br>The following questions use the data
Q112: Exhibit 11.2<br>The following questions use the data
Q113: Exhibit 11.4<br>The following questions use the data
Q114: Exhibit 11.3<br>The following questions use the data
Q115: Exhibit 11.7<br>The following questions use the data
Q117: Exhibit 11.11<br>The following questions use the data
Q118: Exhibit 11.22<br>The following questions use the data
Q119: The correct formula for the weighted moving
Q120: Exhibit 11.10<br>The following questions use the data
Q121: Exhibit 11.5<br>The following questions use the data