Exhibit 11.12 The Following Questions Use the Data Below

question 31

Multiple Choice

Exhibit 11.12
The following questions use the data below.
Joe's Sporting Goods wants to forecast quarterly sales figures using a seasonal regression model. The store has collected 12 quarters of data and needs your help to analyze the data. The relevant regression output is provided in the following table.
-Refer to Exhibit 11.12. What formula should be entered in cell E3 to compute the value for the indicator variable for year 1 Quarter 1?

• A) =IF($B$3<>$E$2,1,0)
• B) =IF($B3=E$2,1)
• C) =IF($B$3=$E$2,0,1)
• D) =IF($B3=E$2,1,0)

---

Definitions:

Heart Disease

A range of conditions affecting the heart, including blood vessel diseases, heart rhythm problems, and heart defects among others.

Cancer

A disease characterized by the uncontrolled division of abnormal cells in a part of the body.

Alternative Medical Treatments

Health care practices and products used instead of conventional Western medicine, often involving herbal, acupuncture, and holistic approaches.

Traditional Treatments

Health remedies and techniques that are rooted in ancient or cultural practices, often passed down through generations and distinct from modern medicine.