Check My Work (1 remaining) PC Magazine provided ratings for several characteris
ID: 3055023 • Letter: C
Question
Check My Work (1 remaining)
PC Magazine provided ratings for several characteristics of computer monitors, including an overall rating (PC Magazine website, April, 2015). The following data show the rating for contrast ratio, resolution, and the overall rating for ten monitors tested using a 0–100 point scale. The highest rated monitor was the BenQ BL3201PH, with an overall rating of 87.
Click on the datafile logo to reference the data.
a. Develop the estimated regression equation that can be used to predict the Overall Rating using the Contrast Ratio Rating (to 4 decimals if necessary).
The regression equation is:
Overall Rating = + Contrast Ratio
b. Develop the estimated regression equation that can be used to predict the Overall Rating using both the Contrast Ratio Rating and the Resolution Rating (to 4 decimals if necessary).
The regression equation is:
Overall Rating = + Contrast Ratio + Resolution
c. Predict the overall Overall Rating for a computer monitor computer that has a Contrast Ratio Rating of 85 and a Resolution Rating of 74 (to the nearest whole number).
Explanation / Answer
a. Develop the estimated regression equation that can be used to predict the Overall Rating using the Contrast Ratio Rating
Sol:Using Excel.....> data analysis
the regression equation is
Overall rating=69.8924+0.1698 contrast ratio
b. Develop the estimated regression equation that can be used to predict the Overall Rating using both the Contrast Ratio Rating and the Resolution Rating
sol: Using Excel.....> data analysis
The regression equatio is
overall rating=43.1045+0.1133 contrast ratio+0.3820 Resolution
c. Predict the overall Overall Rating for a computer monitor computer that has a Contrast Ratio Rating of 85 and a Resolution Rating of 74
sol:overall rating=43.1045+0.1133 contrast ratio+0.3820 Resolution
=43.1045+0.1133(85)+0.3820(74)
=43.1045+9.6305+28.268
=81
over all rating contrast ratio 87 78 86 98 85 84 82 78 82 65 82 57 81 56 79 77 77 47 76 55