Northwoods Year Quarter Quarterly Sales Revenue ($1000s) 20 100 175 Northwoods Outdoor Company sells outdoor recreational clothing by catalog and internet. Sales for its items is very seasonal. The company has accumulated sales revenue data per quarter (in $1000s) during the past 5 years. The columns for dummy variables Q1, Q2, Q3, and time variable t are already set up. (a) Plot the data on a line graph. What pattern do you observe? (b) Find the regression equation and state it here in the form of F= b0 + b1*Q1 + b2*Q2 + b3*Q3+b4*t. (c) Find the quarterly forecasts for year 6. Do the calculation and show your answers in the yellow highlighted part. (d) Which quarter in year 6 will have the highest sales? Q1 Q2 Q3 Time (t) Forecasts 1 1 1 1 2 1 O O 2 3 3 4 4 2 1 1 O O O O O O O 5 O o C 2 6 3 1 7 4 0 8 3 1 9 1 2 0 1 10 (a) O O O O O O O O O O O O O OO (b) 3 0 0 1 11 13 37 136 245 26 75 155 326 48 92 202 384 82 176 282 445 181 4 0 0 12 4 1 1 0 13 2 1 14 3 o od 0 1 15 4 0 16 5 1 1 0 17 2 0 18 1 0 3 0 19 4 0 0 20 6 1 2 3 4 (d) Northwoods Year Quarter Quarterly Sales Revenue ($1000s) 20 100 175 Northwoods Outdoor Company sells outdoor recreational clothing by catalog and internet. Sales for its items is very seasonal. The company has accumulated sales revenue data per quarter (in $1000s) during the past 5 years. The columns for dummy variables Q1, Q2, Q3, and time variable t are already set up. (a) Plot the data on a line graph. What pattern do you observe? (b) Find the regression equation and state it here in the form of F= b0 + b1*Q1 + b2*Q2 + b3*Q3+b4*t. (c) Find the quarterly forecasts for year 6. Do the calculation and show your answers in the yellow highlighted part. (d) Which quarter in year 6 will have the highest sales? Q1 Q2 Q3 Time (t) Forecasts 1 1 1 1 2 1 O O 2 3 3 4 4 2 1 1 O O O O O O O 5 O o C 2 6 3 1 7 4 0 8 3 1 9 1 2 0 1 10 (a) O O O O O O O O O O O O O OO (b) 3 0 0 1 11 13 37 136 245 26 75 155 326 48 92 202 384 82 176 282 445 181 4 0 0 12 4 1 1 0 13 2 1 14 3 o od 0 1 15 4 0 16 5 1 1 0 17 2 0 18 1 0 3 0 19 4 0 0 20 6 1 2 3 4 (d)