Question

In: Statistics and Probability

Calculate the coefficient of correlation, and interpret the result. (not from software or excel) X Y...

Calculate the coefficient of correlation, and interpret the result. (not from software or excel)

X Y
1870 3.38
1330 1.16
1760 1.58
1520 2.65
1300 1.98
1520 2.39
1640 2.49
1490 2.81
1300 2.95
1360 1.69
1940 3.49
1730 2.8
1790 2.95
1780 3.8
1730 2.64
1380 2.36
1580 3.1
1900 1.96
1640 3.08
1540 2.24
1350 2.59
1380 2.43
1780 1.95
1700 2.07
1610 2.34
1720 3.59
2070 3.59
1210 2.12
1720 2.48
1510 2.37
1790 2.1
2100 2.55
1690 3.01
1490 2.67
1760 1.87
1540 2.21
1810 2.37
1430 3.37
1540 1.84
1270 2.96

Solutions

Expert Solution

Following table shows the calculations:

X

Y X^2 Y^2 XY
1870 3.38 3496900 11.4244 6320.6
1330 1.16 1768900 1.3456 1542.8
1760 1.58 3097600 2.4964 2780.8
1520 2.65 2310400 7.0225 4028
1300 1.98 1690000 3.9204 2574
1520 2.39 2310400 5.7121 3632.8
1640 2.49 2689600 6.2001 4083.6
1490 2.81 2220100 7.8961 4186.9
1300 2.95 1690000 8.7025 3835
1360 1.69 1849600 2.8561 2298.4
1940 3.49 3763600 12.1801 6770.6
1730 2.8 2992900 7.84 4844
1790 2.95 3204100 8.7025 5280.5
1780 3.8 3168400 14.44 6764
1730 2.64 2992900 6.9696 4567.2
1380 2.36 1904400 5.5696 3256.8
1580 3.1 2496400 9.61 4898
1900 1.96 3610000 3.8416 3724
1640 3.08 2689600 9.4864 5051.2
1540 2.24 2371600 5.0176 3449.6
1350 2.59 1822500 6.7081 3496.5
1380 2.43 1904400 5.9049 3353.4
1780 1.95 3168400 3.8025 3471
1700 2.07 2890000 4.2849 3519
1610 2.34 2592100 5.4756 3767.4
1720 3.59 2958400 12.8881 6174.8
2070 3.59 4284900 12.8881 7431.3
1210 2.12 1464100 4.4944 2565.2
1720 2.48 2958400 6.1504 4265.6
1510 2.37 2280100 5.6169 3578.7
1790 2.1 3204100 4.41 3759
2100 2.55 4410000 6.5025 5355
1690 3.01 2856100 9.0601 5086.9
1490 2.67 2220100 7.1289 3978.3
1760 1.87 3097600 3.4969 3291.2
1540 2.21 2371600 4.8841 3403.4
1810 2.37 3276100 5.6169 4289.7
1430 3.37 2044900 11.3569 4819.1
1540 1.84 2371600 3.3856 2833.6
1270 2.96 1612900 8.7616 3759.2
Total 64570 101.98 106105700 274.051 166087.1

Sample size : n = 40


Related Solutions

From the table below, calculate the correlation coefficient and the coefficient of determination. Inflation rate (x)...
From the table below, calculate the correlation coefficient and the coefficient of determination. Inflation rate (x) Prime lending rate (y) 3.2 5.2 6.2 8.0 11.0 10.8 9.1 7.9 5.8 6.8 6.5 6.9 7.6 9.0
1. Use the following table to calculate the correlation coefficient (r).             and Interpret the results...
1. Use the following table to calculate the correlation coefficient (r).             and Interpret the results in words. Credibility X Persuasion Y 59 64 54 60 59 63 58 72 71 78 55 69 55 69 54 67 2.Explain Type I error
SPSS: Correlation Use SPSS or Excel to calculate the appropriate correlation coefficient for the following data...
SPSS: Correlation Use SPSS or Excel to calculate the appropriate correlation coefficient for the following data for “Hours of Exercise” and “Life Satisfaction.” (0 = Not at all satisfied). Provide an APA-style results section write – up. (b) Graph the relationship. HINT: Below you will find instructions for the APA-style write-up. Complete the write-up on a word document and upload the file for submission. Hours of Exercise.    2 0 5 6 1 2 4 4 3 4 life satisfaction...
For the following data, calculate the correlation coefficient. (Show the code) Y X 72 45 73...
For the following data, calculate the correlation coefficient. (Show the code) Y X 72 45 73 38 75 41 76 35 77 31 B.Plot the scatterplot of the data above AND add the scatterplot here. (Show code) What type of relationship do you see? Using the information from problem 1 calculate the intercept and   coefficient. Then write the regression equation to explain the relationship. (Show the code) Interpret the R-squared.
Based on the data shown below, calculate the correlation coefficient (to three decimal places) x y...
Based on the data shown below, calculate the correlation coefficient (to three decimal places) x y 1 7.58 2 7.32 3 9.06 4 8.1 5 5.84 6 6.58 7 8.32 8 4.46 9 5.9 10 7.44 11 3.48 12 4.02 13 3.16 14 2.3
Calculate the correlation coefficient​ r, letting Row 1 represent the​ x-values and Row 2 the​ y-values....
Calculate the correlation coefficient​ r, letting Row 1 represent the​ x-values and Row 2 the​ y-values. Then calculate it​ again, letting Row 2 represent the​ x-values and Row 1 the​ y-values. What effect does switching the variables have on​ r? Row 1 18 20 36 48 52 66 75 Row 2 118 110 206 200 141 171 202 Calculate the correlation coefficient​ r, letting Row 1 represent the​ x-values and Row 2 the​ y-values. requals Calculate the correlation coefficient​ r,...
Calculate the Pearson correlation and interpret the results.
The data below relates to income levels and expenses of foods in U.S dollars (00). Income (X) Expenditure (Y) 35 9 49 15 21 7 39 11 15 5 28 8 25 9                   Calculate the Pearson correlation and interpret the results.
Assume that it is appropriate and meaningful to calculate the correlation coefficient of two variables X...
Assume that it is appropriate and meaningful to calculate the correlation coefficient of two variables X and Y. If the correlation coefficient, r, has a value -0.95 Select one: a. it is impossible to tell if there is a linearly relationship between the two variables b. there is a strong linear relationship between the two variables c. there is no relationship between the two variables d. the slope of the regression line will be -0.95 2. The father's height (in...
Identify the type of correlation coefficient apprpriate for measuring the relationship between X and Y :...
Identify the type of correlation coefficient apprpriate for measuring the relationship between X and Y : 1. X= sex (M or F); Y= income (dollars) 2. X= IQ (above of below 100); Y= GPA (above or below 60%)
Using the data below find the linear correlation coefficient. x              y               xy    
Using the data below find the linear correlation coefficient. x              y               xy               x2               y2 3              4               12              9                 16 4             6                24              16               36 5             7               35              25               49 7            12              84              49               144 8            14              112             64               196 ___________________________________________ 27           43              267           163              441 Also, utilizing the above data, find the slope and intercept.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT