Regression Forecast. Using the data in the table for questions #7 calculate the four items below. You may do this on your calculator or in Excel, however, please be sure to indicate the primary formula that you would use for each calculation. If you make your calculations in Excel be sure to export your work into Word before submitting your work to your mentor.
a. What is the slope? The slope is
b. What is the intercept?
c. Write the regression equation.
d. Calculate a regression forecast for month 25.
| Table. Actual Sales Data |
| Time Period |
Actual Sales ($000) |
| 1 |
445 |
| 2 |
478 |
| 3 |
525 |
| 4 |
660 |
| 5 |
570 |
| 6 |
600 |
| 7 |
632 |
| 8 |
648 |
| 9 |
690 |
| 10 |
725 |
| 11 |
750 |
| 12 |
722 |