BUSN 278 Homework week 2
100% All correct answers + Instructor’s explanations
1. Question : (TCO 3) Using the following information regarding actual sales for Paradise Pools, calculate the regression (trend) line:
Sales for Paradise Pools ($000s)
Month First Year Second Year
January 84 84
February 80 82
March 88 98
April 100 120
May 150 160
June 200 210
July 240 250
August 220 215
September 180 195
October 160 165
November 120 130
December 92 100
2. Question : (TCO 3) Using the following information regarding actual sales for Seafood City, project sales for Friday of Week 3 using simple linear regression:
Sales for Seafood City ($)
Day Week 1 Week 2
Monday 1,700 1,800
Tuesday 1,900 2,000
Wednesday 2,100 2,100
Thursday 2,300 2,200
Friday 4,200 4,300
Saturday 4,400 4,600
Sunday 2,100 2,200
3,076.04
3,567.91
3,649.89
3,731.87
3. Question : (TCO 3) Using the following information regarding actual sales for Seafood City, calculate the seasonal ratio for Saturday of Week 3:
Sales for Seafood City ($)
Day Week 1 Week 2
Monday 1,700 1,800
Tuesday 1,900 2,000
Wednesday 2,100 2,100
Thursday 2,300 2,200
Friday 4,200 4,300
Saturday 4,400 4,600
Sunday 2,100 2,200
0.84
0.95
1.58
1.70
4. Question : (TCO 3) Using the following information regarding actual sales for Paradise Pools, calculate the seasonal forecast of sales for April of Year 3:
Sales for Paradise Pools ($000s)
Month First Year Second Year
January 84 84
February 80 82
March 88 98
April 100 120
May 150 160
June 200 210
July 240 250
August 220 215
September 180 195
October 160 165
November 120 130
December 92 100
122
137
165
193
5. Question : (TCO 3) The regression statistic that measures the accuracy of regression predictions is the:
correlation coefficient.
coefficient of determination.
standard error of the estimate.
t-statistic.
