Exhibit 18

question 6

Essay

Exhibit 18.8.Quarterly sales of a department store for the last 7 years are given in the following table. The Excel scatterplot shown above indicates that the quarterly sales have an increasing trend and seasonality.Therefore,the linear regression model,Sales = β₀ + β₁Qtr1 + β₂Qtr2 + β₃Qtr3 + β₄t + ε with three seasonal dummy variables Qtr1,Qtr2 and Qtr3,and the decomposition method are proposed to make sales forecasts.For the regression model,the following Excel partial output is available. Refer to Exhibit 18.8.(Use Excel or statistical software. )Using the decomposition method,
A)compute the adjusted seasonal indices for the four quarters.
B)find the linear trend equation for the seasonally adjusted quarterly sales.
C)make the sales forecasts for the first and fourth quarter of Year 8.

• A)compute the adjusted seasonal indices for the four quarters.
• B)find the linear trend equation for the seasonally adjusted quarterly sales.
• C)make the sales forecasts for the first and fourth quarter of Year 8.

---

Definitions:

Stimulus

An event or object that evokes a specific functional reaction in an organ or tissue.

Formal Operational Thought

A stage in Piaget's cognitive development theory (beginning around age 12) where individuals develop the ability to think abstractly, logically, and systematically.

Cognition Stage

A phase in cognitive development processes, per developmental theories, where individuals acquire, process, and utilize knowledge.

Jean Piaget

was a Swiss psychologist known for his pioneering work in child development, particularly his theory of cognitive development.