Exhibit 11.4 The Following Questions Use the Data Below

question 105

Multiple Choice

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

• A) =AVERAGE($E$3:$E$6)
• B) =AVERAGE(E3, E7, E11)
• C) =AVERAGE($D$3:$D$6)
• D) =AVERAGE(D3, D7, D11)

---

Definitions:

Hammer

A tool with a heavy, typically metal, head attached to a long handle, used for breaking things apart or driving in nails.

Stirrup

A tiny bone in the middle ear that plays a critical role in the process of hearing by transmitting sound vibrations to the inner ear.

Middle Ear

The part of the ear located between the eardrum and the inner ear, containing three small bones that transmit sound vibrations.

Cones

Specialized photoreceptor cells in the retina of the eye responsible for color vision and functioning best in relatively bright light.