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 is the Input X Range in the Regression command settings dialog box?
A) $C$3:$C$14
B) $H$3:$H$14
C) $C$3:$G$14
D) $H$3:$I$14

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 is the Input X Range in the Regression command settings dialog box?
A) $C$3:$C$14 
B) $H$3:$H$14 
C) $C$3:$G$14 
D) $H$3:$I$14

Quizplus · Accepted Answer

The input X range is the range of cells that contain the independent variables used in the regression. In this case, the independent variables are the quarter (coded as 1, 2, 3, or 4) and an indicator variable for each of the four quarters. These variables are located in columns C through G, and the data covers rows 3 through 14. Therefore, the correct input X range for the regression is $C$3:$G$14.

Exhibit 11.12 The Following Questions Use the Data Below