[Solution Library] Infoworks is a discount computer store. Infoworks has collected data on computer and printer sales for the past 10 years as follows. Computers
Question: Infoworks is a discount computer store. Infoworks has collected data on computer and printer sales for the past 10 years as follows.
| Computers | Printers | |
| Year | Sold | Sold |
| 1 | 1045 | 326 |
| 2 | 1610 | 510 |
| 3 | 860 | 296 |
| 4 | 1211 | 478 |
| 5 | 975 | 305 |
| 6 | 1117 | 506 |
| 7 | 1066 | 612 |
| 8 | 1310 | 560 |
| 9 | 1517 | 590 |
| 10 | 1246 | 676 |
-
Develop a linear trend line forecast to forecast printer demand in year 11
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 298.1333 62.80307 4.747114 0.001451 153.3091 442.9576 Year 34.13939 10.12163 3.372914 0.009743 10.79886 57.47993
This means that the regression model is
\[\text{Printers}=298.1333+34.13939\,t\]
For t = 11, we get
\[\text{Printers}=298.1333+34.13939\times 11=673.6667\approx 674\] -
Develop a linear regression model relating printer sales to computer sales to forecast printer demand in year 11 if 1300 computers are sold.
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 74.76874578 197.4138886 0.378741 0.714734 -380.469 530.0063 Computers 0.343841477 0.162301617 2.118534 0.066978 -0.03043 0.71811
This means that the regression model is
\[\text{Printers}=74.7687+0.34384\text{ Computers}\]
If the computer sales are 1,300, we get
\[\text{Printers}=74.7687+0.34384\times 1,300=521.763\approx 522\] - Compare the two forecasts developed above and indicate which you think is more accurate. Why?
Price: $2.99
Solution: The downloadable solution consists of 3 pages
Deliverable: Word Document 