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. solutions only on excel Model Contrast Ratio Resolution Overall Rating BenQ BL3201PH 78 89
Inverse Normal Distribution
The method used for finding the corresponding z-critical value in a normal distribution using the known probability is said to be an inverse normal distribution. The inverse normal distribution is a continuous probability distribution with a family of two parameters.
Mean, Median, Mode
It is a descriptive summary of a data set. It can be defined by using some of the measures. The central tendencies do not provide information regarding individual data from the dataset. However, they give a summary of the data set. The central tendency or measure of central tendency is a central or typical value for a probability distribution.
Z-Scores
A z-score is a unit of measurement used in statistics to describe the position of a raw score in terms of its distance from the mean, measured with reference to standard deviation from the mean. Z-scores are useful in statistics because they allow comparison between two scores that belong to different normal distributions.
3. 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.
solutions only on excel
|
Model |
Contrast Ratio |
Resolution |
Overall Rating |
|
BenQ BL3201PH |
78 |
89 |
87 |
|
AOC U2868PQU |
98 |
87 |
86 |
|
NEC MultiSync PA322UHD |
84 |
82 |
85 |
|
Acer XB280HK |
78 |
77 |
82 |
|
Asus ROG Swift PG278Q |
65 |
82 |
82 |
|
AOC E1759Fwu |
57 |
78 |
82 |
|
Dell UltraSharp UZ2715H |
56 |
83 |
81 |
|
NEC MultiSync EA244UHD |
77 |
75 |
79 |
|
HP DreamColor Z27x |
47 |
81 |
77 |
|
Dell UltraSharp UZ2315H |
55 |
70 |
76 |
a. Develop the estimated regression equation that can be used to predict the Overall Rating using the Contrast Ratio Rating.
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.
c. Predict the Overall Rating for a computer monitor computer that has a Contrast Ratio Rating of 85 and a Resolution Rating of 74.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
