Exhibit 11.10 The Following Questions Use the Data Below

question 57

Multiple Choice

Exhibit 11.10
The following questions use the data below.
Joe's Sporting Goods wants to forecast quarterly sales figures using a quadratic 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.10. What Excel command can be used in cells F4:F14 in lieu of a formula based on the regression statistics?

• A) =TREND($E$3:$E$14,$C$3:$C$14,C4)
• B) =TREND($E$3:$E$14,$C$3:$D$14,C4:D4)
• C) =TREND($E$3:$E$14,$C$3:$D$14,D4)
• D) =TREND($E$3:$E$14,$B$3:$D$14,B4:D4)

---

Definitions:

Radium Dial

A watch or clock dial that was painted with radium-based luminescent paint to glow in the dark, commonly used in the early 20th century.

Reality Television Shows

A genre of TV programs that document unscripted real-life situations, often featuring unknown individuals rather than professional actors.

Project Runway

A reality television show focusing on fashion design, where contestants compete to create the best clothes within restricted time, materials, and theme.

Dancing With The Stars

A popular television dance competition where celebrities partner with professional dancers to compete in various dance styles and are judged on their performances.