o help consumers in purchasing a laptop computer, Consumer Reports calculates an overall test score for each computer tested based upon rating factors such as ergonomics, portability, performance, display, and battery life. Higher overall scores indicate better test results. The following data show the average retail price and the overall score for ten 13- inch models (Consumer Reports website, October 25, 2012). solution must be in excel format Brand & Model Price ($) Overall Score Samsung Ultrabook NP900X3C-A01US 1250 83 Apple MacBook Air MC965LL/A 1300 83 Apple MacBook Air MD231LL/A 1200 82 HP ENVY 13-2050nr Spectre XT 950 79 Sony VAIO SVS13112FXB 800 77 Acer Aspire S5-391-9880 Ultrabook 1200 74 Apple MacBook Pro MD101LL/A 1200 74 Apple MacBook Pro MD313LL/A 1000 73 Dell Inspiron I13Z-6591SLV 700 67 Samsung NP535U3C-A01US 600 63 a. Develop a scatter diagram with price as the independent variable. b. What does the scatter diagram developed in part (a) indicate about the relationship between the two variables? c. Use the Least Squares method to develop the estimated regression equation.
To help consumers in purchasing a laptop computer, Consumer Reports calculates an overall test score for each computer tested based upon rating factors such as ergonomics, portability, performance, display, and battery life. Higher overall scores indicate better test results. The following data show the average retail price and the overall score for ten 13- inch models (Consumer Reports website, October 25, 2012).
solution must be in excel format
Brand & Model |
Price ($) |
Overall Score |
Samsung Ultrabook NP900X3C-A01US |
1250 |
83 |
Apple MacBook Air MC965LL/A |
1300 |
83 |
Apple MacBook Air MD231LL/A |
1200 |
82 |
HP ENVY 13-2050nr Spectre XT |
950 |
79 |
Sony VAIO SVS13112FXB |
800 |
77 |
Acer Aspire S5-391-9880 Ultrabook |
1200 |
74 |
Apple MacBook Pro MD101LL/A |
1200 |
74 |
Apple MacBook Pro MD313LL/A |
1000 |
73 |
Dell Inspiron I13Z-6591SLV |
700 |
67 |
Samsung NP535U3C-A01US |
600 |
63 |
a. Develop a
b. What does the scatter diagram developed in part (a) indicate about the relationship between the two variables?
c. Use the Least Squares method to develop the estimated regression equation.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images