Exhibit 11.12 The Following Questions Use the Data Below

question 48

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

---

Definitions:

Wheelchair

A chair mounted on wheels for use by individuals who cannot walk due to illness, injury, or disability.

Social Policy

Policies designed to address social issues and improve human welfare, including education, health, housing, and employment.

Collective Strategy

A cooperative approach by a group to achieve a shared goal.

Legislative Leaders

Elected officials who hold significant positions of authority within legislative bodies and play key roles in shaping and passing laws.