[Solved] The sales, billion of dollars, of Keller Overhead Door, Inc. for 1995 t o2000 are: Year t Sales, $ billion 1995 1 7.45 1996 2 7.83 1997 3 8.07
Question:
The sales, billion of dollars, of Keller Overhead Door, Inc. for 1995 t o2000 are:
| Year | t | Sales, $ billion | |||||
| 1995 | 1 | 7.45 | |||||
| 1996 | 2 | 7.83 | |||||
| 1997 | 3 | 8.07 | |||||
| 1998 | 4 | 7.94 | |||||
| 1999 | 5 | 7.76 | |||||
| 2000 | 6 | 7.90 | |||||
- Plot the data
-
Determine the least squares trend equation.
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 7.634 0.192840423 39.58714 2.43E-06 7.098588 8.169412 t 0.05457 0.049516849 1.102078 0.33228 -0.08291 0.192053
This means that the regression equation is
\[Sales=7.634+0.05457t\] - Use the trend equation to calculate the point for 1997 and 1999. Plot them on the graph and draw regression line.
- Estimate the net sales for 2003.
- By how much sales increased (or decreased) per year on the average during the period?
Price: $2.99
Solution: The downloadable solution consists of 3 pages
Deliverable: Word Document 