Exhibit 11.1 The Following Questions Use the Data Below

question 67

Multiple Choice

Exhibit 11.1
The following questions use the data below.
Honest Al's Used Cars wants to predict how many cars are sold each month. He has collected data for 12 months. He needs your help in analyzing this data using moving averages.
-Refer to Exhibit 11.1. What formula should be entered in cell C13 to compute the 4-month moving average forecast for month 11?

• A) =AVERAGE(B9:B12)/4
• B) =AVERAGE(B7+B10)
• C) =AVERAGE(A9:A12)
• D) =AVERAGE(B9:B12)

---

Definitions:

Alternatives

Other options or choices available in a situation from which a selection can be made.

Investments

The allocation of resources, usually financial, into assets or endeavors expected to yield returns or profits over time.

Distress-Maintaining

Cycles or patterns of behavior and thought that contribute to preserving or increasing psychological distress.

Relationship-Enhancing

Any behavior or action that strengthens the bond between individuals in a relationship.