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 Excel command can be used in cells F4:F14 in lieu of a formula based on the regression statistics?
A) =TREND($H$3:$H$14,$C$3:$G$14, C3:G3)
B) =TREND($H$3:$H$14,$B$3:$G$14, B3:G3)
C) =TREND($H$3:$H$14,$A$3:$G$14, A3:G3)
D) =TREND($H$3:$H$14,$C$3:$D$14, C3:D3)

Question

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 Excel command can be used in cells F4:F14 in lieu of a formula based on the regression statistics?
A) =TREND($H$3:$H$14,$C$3:$G$14, C3:G3) 
B) =TREND($H$3:$H$14,$B$3:$G$14, B3:G3) 
C) =TREND($H$3:$H$14,$A$3:$G$14, A3:G3) 
D) =TREND($H$3:$H$14,$C$3:$D$14, C3:D3)

Quizplus · Accepted Answer

The TREND function in Excel is used to predict values based on linear regression. The correct range for the independent variables (X) should match the columns used in the regression analysis, which is $C$3:$G$14, and the dependent variable (Y) range is $H$3:$H$14.

Exhibit 11.12 The Following Questions Use the Data Below