Exhibit 11.9
The following questions use the data below.
Joe's Sporting Goods wants to forecast quarterly sales figures using a linear trend model. The store has collected 12 quarters of data and needs your help to analyze the data. The relevant regression output is in the following table.
-Refer to Exhibit 11.9. What is the Input Y Range in the Regression command settings dialog box?
A) B3:B14
B) C3:C14
C) D3:D14
D) B3:D14

Question

Exhibit 11.9
The following questions use the data below.
Joe's Sporting Goods wants to forecast quarterly sales figures using a linear trend model. The store has collected 12 quarters of data and needs your help to analyze the data. The relevant regression output is in the following table.  
-Refer to Exhibit 11.9. What is the Input Y Range in the Regression command settings dialog box?
A) B3:B14 
B) C3:C14 
C) D3:D14 
D) B3:D14

Quizplus · Accepted Answer

The Input Y Range in the Regression command settings dialog box refers to the dependent variable's data range. Since Exhibit 11.9 is not visible, the correct answer is inferred based on common practices in regression analysis, where the Y range typically corresponds to a single column of data representing the dependent variable.

Exhibit 11.9 The Following Questions Use the Data Below