The exercise involving data in this and subsequent sections were designed to be solved using Excel. PCWorld
Question:
The exercise involving data in this and subsequent sections were designed to be solved using Excel.
PCWorld rated four component characteristics for 10 ultraportable laptop computers: features; performance; design; and price. Each characteristic was rated using a 0?100 point scale. An overall rating was then developed for each laptop. The following table shows the performance rating, features rating, and the overall rating for the 10 laptop computers ( PCWorld website, February 5, 2009). Click on the web file logo to reference the data.
Excel or Minitab users: The data set is available in file named Laptop. All data sets can be found in your eBook or on your Student CD.
Round your answers to four decimal places.
a. Determine the estimated regression equation that can be used to predict the overall rating using the performance rating as the independent variable.
? = + Performance
b. Determine the estimated regression equation that can be used to predict the overall rating using both the performance rating and the features rating.
? = + Performance + Features
c. Predict the overall rating for a laptop computer that has a performance rating of 80 and a features rating of 70.
Essentials of Statistics for Business and Economics
ISBN: 978-1305081598
7th edition
Authors: David Anderson, Thomas Williams, Dennis Sweeney, Jeffrey Cam