Solve by using Excel.

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.

Model Contrast RatioResolutionOverall Rating

BenQ BL3201PH 78 89 87

AOC U2868PQU 98 87 86

NEC MultiSync PA322UHD 84 82 85

Acer XB280HK 78 79 82

Asus ROG Swift PG278Q 65 80 82

AOC E1759Fwu 57 78 82

Dell UltraSharp UZ2715H 56 83 80

NEC MultiSync EA244UHD 77 72 79

HP DreamColor Z27x 47 81 78

Dell UltraSharp UZ2315H 55 70 76

A) Develop the estimated regression equation that can be used to predict the Overall Rating

using the Contrast RatioRating. Add a plot that shows the estimated line along with all

the sample data.

B) Predict the Overall Rating for a computer monitor computer that has a Contrast Ratio

Rating of 85.

C) Use Minitab 19 to create both Confidence Interval and Prediction Interval plots, and

provide the lower limits and upper limits of both C.I. and P.I. Clearly, distinguish

between these two predictions.

D) Develop the estimated regression equation that can be used to predict the Overall Rating

using both the Contrast Ratio Rating and the Resolution Rating.

E) Predict the Overall Rating for a computer monitor computer that has a Contrast Ratio

Rating of 85 and a Resolution Rating of 74.

F) Compare and contrast your findings in part (b) and (e), any comments?