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:

Conditional Sale Contracts

agreement for the sale of goods where the price is payable in instalments and the goods remain the property of the seller until the full price is paid.

Purchase Price

Purchase price is the amount of money paid to buy goods, services, or assets.

Combined Equivalent

The equivalent total effect or value when multiple factors or values are considered together.

Scheduled Payments

Pre-determined payments made at regular intervals, such as monthly or quarterly, often related to loans or leases.