In: Statistics and Probability
Below are two judges’ rankings of bands at a marching band competition. Calculate the Covariance, Coefficient of Correlation, the Least Squares Equation and the Coefficient of Determination. Also, use your equation of calculate Judge 2’s rank of the bands if Judge 1 ranks them a 4. Judge 1 (x) Judge 2 (y) 1 6 3 4 4 5 7 1 5 3 6 2 2 7
Solution: The data given is:
Calculate the Covariance
Answer: To find the covariance, we can use excel data analysis tool to find the covariance. The excel output is given below:
Therefore, the covariance between Judge 1's and Judge 2's ranking of bands is:
Calculate the Coefficient of Correlation.
Answer: To find the coefficient of correlation, we can use excel data analysis tool to find the coefficient of correlation. The excel output is given below:
Therefore, the coefficient of correlation between Judge 1's and Judge 2's ranking of bands is:
Calculate the Least squares equation.
Answer: We can use excel regression data analysis tool to find the equation of the least squares. The excel output is given below:
Therefore, the equation of the regression line is:
Find the Coefficient of Determination
Answer: From the above output's we see R square = 0.862.
Therefore, the coefficient of determination = 0.862
Use your equation to calculate Judge 2’s rank of the bands if Judge 1 ranks them a 4.