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 Y 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 Y 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 Y Range in the Regression command settings dialog box refers to the range of cells that contain the dependent variable data. Since the question does not provide specific details about the content of Exhibit 11.12, the correct answer cannot be determined without seeing the exhibit. However, typically in regression analysis, the Y range would consist of a single column of data representing the dependent variable, which makes option B ($H$3:$H$14) a plausible choice assuming it represents such a column in the context of the exhibit.

Exhibit 11.12 The Following Questions Use the Data Below