(Solution Library) Savings-Mart sells patio and lawn furniture. Sales are seasonal, with higher sales during the spring and summer quarters and lower sales
Question: Savings-Mart sells patio and lawn furniture. Sales are seasonal, with higher sales during the spring and summer quarters and lower sales during fall and winter quarters. The company developed the following quarterly sales forecasting model using data from 2005Q1 to \(2009 \mathrm{Q} 4\) i.e. \(\mathrm{n}=20\) quarters:
\[\begin{matrix} \widehat{\text{Y}}\text{t}=8.25+0.125\text{t}-2.75\text{D}1\text{t}+0.25\text{D}2\text{t}+3.50\text{D}3\text{t} & {{\text{R}}^{2}}=0.789 & {} & {} \\ (2.5)\,(3.1)\,\,(1.8) & {} & {} & {} \\ \end{matrix}\]where the numbers in parenthesis are t-values, \(\hat{\mathrm{Y}} \mathrm{t}=\) predicted quarterly sales (\$million) in quarter \(\mathrm{t}\) \(t=\) time period
D1 \(t=\) dummy variable \(=1\) for \(1^{\text {st }}\) quarter, 0 otherwise \(\mathrm{D} 2 \mathrm{t}=\) dummy variable \(=1\) for \(2^{\text {nd }}\) quarter, 0 otherwise \(\mathrm{D} 3 \mathrm{t}=\) dummy variable \(=1\) for \(3^{\text {rd }}\) quarter, 0 otherwise
- Explain what \(\mathrm{R}^{2}=0.789\) means.
- Forecast Savings-Mart's sales for each of the quarters in 2010 .
- Which variables of the model are statistically significant? Use t-test for \(\alpha=.05\).
Deliverable: Word Document 