Exhibit 11.9 The Following Questions Use the Data Below

question 109

Multiple Choice

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 are predicted sales for the fourth quarter of year 4?

• A) 1020 ≤ predicted sales < 1025
• B) 1090 ≤ predicted sales < 1095
• C) 1160 ≤ predicted sales < 1165
• D) 1230 ≤ predicted sales < 1235

---

Definitions:

Cell References

In spreadsheet applications, the unique identifier of a cell, based on its column letter and row number, used in formulas to point to data.

Macro

A set of instructions or a script designed to automate repetitive tasks within software applications, allowing users to execute those tasks with a single command or click.

Absolute

A term used to describe values or measurements that are not relative and remain constant regardless of changes in other variables.

Assign Macro

The process of linking a macro (a set of programmed instructions) to a specific trigger, like a button or keyboard shortcut, in software applications.