Question: 1. Calculate the b parameter for the linear regression of the following data: Period Value 1 507 2 520 3 544 4 539 5 562
1. Calculate the b parameter for the linear regression of the following data:
| Period | Value |
| 1 | 507 |
| 2 | 520 |
| 3 | 544 |
| 4 | 539 |
| 5 | 562 |
| 6 | 532 |
| 7 | 537 |
| 8 | 529 |
(Keep 3 decimals in your answer)
2. Calculate the a parameter for the linear regression of the following data:
| Period | Value |
| 1 | 8,997 |
| 2 | 9,111 |
| 3 | 9,114 |
| 4 | 9,007 |
| 5 | 9,023 |
| 6 | 9,021 |
| 7 | 8,890 |
| 8 | 8,963 |
(Keep 3 decimals in your answer)
3. Calculate the Standard Error of Estimate for the linear regression of the following data:
| Period | Value |
| 1 | 9,420 |
| 2 | 9,138 |
| 3 | 9,187 |
| 4 | 8,840 |
| 5 | 8,742 |
| 6 | 9,021 |
| 7 | 8,890 |
| 8 | 9,140 |
(Keep 2 decimals in your answer)
4. What is the seasonality factor for sales in Month 5?
| Month | Sales |
| 1 | 17,601 |
| 2 | 15,303 |
| 3 | 15,970 |
| 4 | 17,156 |
| 5 | 16,144 |
| 6 | 15,865 |
| 7 | 15,101 |
| 8 | 15,917 |
| 9 | 18,476 |
| 10 | 18,339 |
| 11 | 17,253 |
| 12 | 18,654 |
(Keep 3 decimals in your answer)
5. What is the exponential smoothing forecast for period 5 assuming that alpha = 0.5?
| Period | Heat |
| 1 | 418 |
| 2 | 411 |
| 3 | 412 |
| 4 | 413 |
| 5 | 418 |
| 6 | 414 |
| 7 | 421 |
(Keep 2 decimals in your answer)
6. What is the five period moving average for period 10 for the following data:
| Period | Gallons |
| 1 | 288 |
| 2 | 286 |
| 3 | 300 |
| 4 | 290 |
| 5 | 276 |
| 6 | 318 |
| 7 | 331 |
| 8 | 298 |
| 9 | 308 |
(Keep 2 decimal places in your answer)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
