Question

In: Statistics and Probability

Calculate the covariance and correlation coefficients by completing the below table, assuming sample data. Show all...

  1. Calculate the covariance and correlation coefficients by completing the below table, assuming sample data. Show all workings. (Note: You can calculate the mean and standard deviation of X & Y with Excel or your calculator; no working for their calculation is required.)

X

Y

(X - X bar)

(Y - Y bar)

(X - X bar)(Y - Y bar)

5

5

2

3

5

4

8

7

6

9

(b)       Comment on the direction and strength of the association between X and Y.

Solutions

Expert Solution

Here,

and

Since correlation coefficient of X and Y = 0.737391

So, we can conclude that there is a almost strong positive linear relationship between X and Y.


Related Solutions

7) COVARIANCE AND CORRELATION COEFFICIENT. What is covariance? How is covariance and correlation coefficients linked? How...
7) COVARIANCE AND CORRELATION COEFFICIENT. What is covariance? How is covariance and correlation coefficients linked? How does the concept of covariance link to the Timura depiction of an efficient frontier oriented “silver bullet” In addition, draw a graphic that explains your thinking using real estate, international, private equity, venture capital, etc.
The table below shows standard deviations and correlation coefficients for seven stocks from different countries. Calculate...
The table below shows standard deviations and correlation coefficients for seven stocks from different countries. Calculate the variance of a portfolio with equal investments in each stock. (Use decimals, not percents, in your calculations. Do not round intermediate calculations. Round your answer to 4 decimal places.) Portfolio Varience:? BHP Billiton Siemens Nestlé LVMH Toronto Dominion Bank Samsung BP BHP Billiton 1.00 0.28 0.37 0.40 0.16 0.40 0.14 Siemens 1.00 0.34 0.16 0.14 0.31 –0.12 Nestlé 1.00 0.09 0.10 0.02 0.10...
The table below shows standard deviations and correlation coefficients for eight stocks from different countries. Calculate...
The table below shows standard deviations and correlation coefficients for eight stocks from different countries. Calculate the variance of a portfolio with equal investments in each stock. (Use decimals, not percents, in your calculations. Do not round intermediate calculations. Round your answer to 5 decimal places.) BHP BP Fiat Chrysler Heineken Korea Electric Nestlè Sony Tata Motors BHP 1.00 .34 .38 .45 .14 .45 .16 .29 BP .34 1.00 .29 .14 .16 .36 −.07 .12 Fiat .38 .29 1.00 −.03...
The table below shows standard deviations and correlation coefficients for eight stocks from different countries. Calculate...
The table below shows standard deviations and correlation coefficients for eight stocks from different countries. Calculate the variance of a portfolio with equal investments in each stock. (Use decimals, not percents, in your calculations. Do not round intermediate calculations. Round your answer to 5 decimal places.) BHP BP Fiat Chrysler Heineken Korea Electric Nestlè Sony Tata Motors BHP 1.00 .26 .42 .40 .17 .40 .12 .34 BP .26 1.00 .34 .17 .12 .33 .49 .17 Fiat .42 .34 1.00 .09...
Calculate the sample correlation and covariance for (i) Final_exam and assignment_grade; (ii) Final_exam and Tutorial_attend; and...
Calculate the sample correlation and covariance for (i) Final_exam and assignment_grade; (ii) Final_exam and Tutorial_attend; and (iii) assignment_grade and Tutorial_ attend. Once again using Excel formulae without the use of Data Analysis Tool Pack very important the teacher wants us to use hand by hand using excel in a step by step manner: e.g. calculating the sample mean which would be sum (x) /n... we can't use excel formula that is (=covariance(A..) please show steps with snipping tool. Final_exam assignment_grade...
Calculate the sample correlation and covariance for (i) Final_exam and assignment_grade; (ii) Final_exam and Tutorial_attend; and...
Calculate the sample correlation and covariance for (i) Final_exam and assignment_grade; (ii) Final_exam and Tutorial_attend; and (iii) assignment_grade and Tutorial_ attend, Carefully interpret your results. Once again use Excel for these calculations using both methods i.e. Data Analysis Tool Pack (options covariance, correlation) and using Excel formulae without use of Data Analysis Tool Pack. (Hint- if you find a discrepancy in your answers between the 2 excel methods can you explain why?) Final_exam assignment_grade Tutorial_attend 100 90 5 100 75...
Use the data values in the table below to calculate the correlation, r, between the variables...
Use the data values in the table below to calculate the correlation, r, between the variables x and y. x y 4 12.32 5 13.1 6 16.68 7 20.26 8 22.44 9 22.72 10 23.4 11 26.98 12 28.66 Give your answer to rounded three decimal places.
Use the data in the table below to calculate Cp, Cpl, Cpu, and Cpk, assuming that...
Use the data in the table below to calculate Cp, Cpl, Cpu, and Cpk, assuming that the specifications are 3.60 ± 1.30. Do not round intermediate calculations. Round your answers to three decimal places. Sample 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Observations 3.50 3.53 3.69 4.17 4.02 3.50 3.22 4.26 4.44 3.72 4.12 3.28 3.91 3.67 3.68 3.65 3.41 3.32 3.48 3.34 4.32 3.60 3.28 3.69 3.63 3.25 3.16 3.41 3.67...
what is the significance of covariance and oefficient of correlation in understanding the data
what is the significance of covariance and oefficient of correlation in understanding the data
The table below is the Monthly return Correlation Coefficients between two stocks: RIO & ANZ 0.6162...
The table below is the Monthly return Correlation Coefficients between two stocks: RIO & ANZ 0.6162 RIO & WES 0.7593 RIO & TLS -0.6850 ANZ & WES 0.5970 ANZ & TLS -0.1865 WES & TLS -0.5192 Required: a. Which pair of two stocks have the highest and lowest correlations? b. Suggest some economic reasons to explain the high and low correlation between these stocks. If you were to form a portfolio of two stocks, which ones would you choose to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT