Exhibit 11.12 The Following Questions Use the Data Below

question 111

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 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

---

Definitions:

Portfolio Beta

A measure of the volatility, or systematic risk, of a portfolio in comparison to the market as a whole.

Index Model

A statistical model to represent the returns of a security or a portfolio as a function of the returns of the market as a whole, along with random error.

Market Return

The overall return generated by the stock market or a specific segment of the market, over a given period.

Residual

The amount remaining after the major part or parts have been accounted for; in finance, often refers to the remainder left after specific calculations, such as dividends from a corporation after major expenses are paid.