Exhibit 11.7 The Following Questions Use the Data Below

question 26

Multiple Choice

Exhibit 11.7
The following questions use the data below.
Joe's Sporting Goods wants to forecast quarterly sales figures using Holt's method. The store has collected 12 quarters of data and needs your help to analyze the data.
-Refer to Exhibit 11.7. What formula should be entered in cell F4 to compute the trend when using Holt's method?

• A) =$J$3*D4+(1-$J$3)*(E3+F3)
• B) =$J$4*(E4-E3)+(1-$J$4)*F3
• C) =$J$4*(E4-E3)+(1-$J$4)*G3
• D) =$J$4*G3+(1-$J$4)*(D3+G3)

---

Definitions:

Capacitive Reactance

The resistance that a capacitor offers to alternating current, depending on the frequency of the current and the capacitor value, measured in ohms.

AC Circuit

A circuit in which the current changes direction periodically, powered by an alternating voltage source.

Inductive Reactance

A measure of the opposition by an inductor to changes in current, dependent on frequency.

Inductance

A property of an electrical conductor by which a change in current in the conductor induces an electromotive force in both the conductor itself and in any nearby conductors by mutual inductance.