Computown is a large computer discount store than sells computers and ancillary equipment and softwa


Question: Computown is a large computer discount store than sells computers and ancillary equipment and software in the town where Tech University is located. Computown has collected historical data on computer sales, average printer price and printer sales for the past 10 years, as follows:

Year Personal Computers Sold Average Printer Price Printers Sold
1 1058 $490 339
2 1623 505 523
3 873 535 309
4 1224 435 491
5 988 425 318
6 1130 385 519
7 1079 365 625
8 1323 315 573
9 1530 295 603
10 1259 265 689

a) Develop a linear trend line forecast to forecast printer demand in year 11.

b) Develop a linear regression model relating printer sales to computer sales in order to forecast printer demand in year 11 if 1250 computers are sold.

c) Develop the multiple linear regression for this data (printers sold is the y or dependent variable, Personal computers sold and average printer price are the independent variables).

d) What is the coefficient of determination for the multiple regression equation?

e) Determine the forecast for printer sales, based upon personal computer sales of 1300 and an average printer price of $250.

Price: $2.99
Solution: The solution consists of 4 pages
Deliverables: Word Document

log in to your account

Don't have a membership account?
REGISTER

reset password

Back to
log in

sign up

Back to
log in