Question: Develop a linear regression model for these data and indicate if there appears to be a strong relationship between website hits and orders. What would

Develop a linear regression model for these data and indicate if there appears to be a strong relationship between website hits and orders.
What would be the forecast for orders with 60,000 hits per month?
12-19. ITown is a large computer discount store that sells computers and ancillary equipment and software in the town where State University is located. It has collected historical data on computer sales and printer sales for the past 10 years as follows:
Year
2
3
Personal Computer Sales
1,045
1,610
860
Printers Sold
381
579
312
4
5
1,211
975
501
296
6
7
8
9
10
1,117
1,066
1,310
1,517
1,246
415
535
592
607
473
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 to forecast printer demand in year 11 if 1500 computers are sold.
c. Compare the forecasts developed in parts

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!