Quarterly Sales of a Department Store for the Last Seven

question 46

Essay

Quarterly sales of a department store for the last seven years are given in the following table. The scatterplot shows that the quarterly sales have an increasing trend and seasonality. A linear regression model given by, Sales = β₀ + β₁Qtr1 + β₂Qtr2 + β₃Qtr3 + β₄t + ε, where t is the time period (t = 1, ..., 28) and Qtr1, Qtr2, and Qtr3 are quarter dummies, is estimated and then used to make forecasts. For the regression model, the following partial output is available. 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:

Battle of Vicksburg

A significant military engagement during the American Civil War, where Union forces gained control of Vicksburg, Mississippi, and the Mississippi River.

Republican National Convention

A quadrennial event where the Republican Party of the United States selects its candidates for President and Vice President and adopts its political platform.

Prohibiting Slavery

The act of legally banning or abolishing the practice of enslavement and the trade in enslaved individuals.