Exhibit 11.11 The Following Questions Use the Data Below

question 5

Multiple Choice

Exhibit 11.11
The following questions use the data below.
Joe's Sporting Goods wants to forecast quarterly sales figures using seasonal indices. 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.11. What formula should be entered in cell C18 to compute the Seasonal Index value for quarter 1?

• A) =SUM($B$3:$B$14)/COUNTIF($B$3:$B$14,B18)
• B) =SUMIF($B$3:$B$14,B18,$G$3:$G$14)/COUNTIF($B$3:$B$14,B18)
• C) =SUMIF($B$3:$B$14,$G$3:$G$14)/COUNT($B$3:$B$14,B18)
• D) =SUMIF($B$3:$B$14,B18)/COUNTIF($B$3:$B$14,B18)

---

Definitions:

Unconventional

Unconventional refers to something that does not follow traditional or expected norms, methods, or practices.

Illogical

Lacking in sound reasoning or coherent argumentation, often leading to conclusions or actions that defy rational thought.

Ambiguous

Open to more than one interpretation or having a double meaning.

Emotions

Complex psychological states involving an individual's physiological response, subjective experience, and behavioral expression in response to stimuli.