Question

In: Statistics and Probability

For the following data, calculate the correlation coefficient. (Show the code) Y X 72 45 73...

  1. For the following data, calculate the correlation coefficient. (Show the code)

    Y

    X

    72

    45

    73

    38

    75

    41

    76

    35

    77

    31

  2. B.Plot the scatterplot of the data above AND add the scatterplot here. (Show code) What type of relationship do you see?
  3. Using the information from problem 1 calculate the intercept and   coefficient. Then write the regression equation to explain the relationship. (Show the code)
  4. Interpret the R-squared.

Solutions

Expert Solution

1.

> data
Y X
1 72 45
2 73 38
3 75 41
4 76 35
5 77 31
> cor(data$Y,data$X,method = "pearson")
[1] -0.8507273

Correlation between X and Y = -0.8507

2. > plot(data$X, data$Y,type = "p",main = "Scatterplot",xlab = "x", ylab = "Y")

It represents a strong linear (but negative) relationship.

3.

> model = lm(Y~X,data=data)
> summary(model)

Call:
lm(formula = Y ~ X, data = data)

Residuals:
1 2 3 4 5
-0.3069 -1.6000 1.3828 0.4172 0.1069

Coefficients:
Estimate Std. Error t value Pr(>|t|)
(Intercept) 87.0483 4.4759 19.448 0.000297 ***
X -0.3276 0.1169 -2.803 0.067660 .
---
Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1

Residual standard error: 1.259 on 3 degrees of freedom
Multiple R-squared: 0.7237,   Adjusted R-squared: 0.6316
F-statistic: 7.859 on 1 and 3 DF, p-value: 0.06766

Equation : Y = 87.05 - 0.33 X

R-squared = 0.7237

Interpretation :

X explains 72.37% variability in Y

Please rate my answer and comment for doubt.


Related Solutions

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 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...
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.
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...
Consider this code snippet: if (x < 512) { y = 73; } else { y...
Consider this code snippet: if (x < 512) { y = 73; } else { y = 42; } Which of these goto-style code snippets is equivalent to that if/else code? Consider this code snippet: if (x < 512) { y = 73; } else { y = 42; } Which of these goto-style code snippets is equivalent to that if/else code? a. if (x >= 512) goto Label1; y = 73; goto Label2; Label1: y = 42; Label2: b....
Calculate the Coefficient of Correlation and the Least Squares Equation for the following data, hours of...
Calculate the Coefficient of Correlation and the Least Squares Equation for the following data, hours of study (x) and hours of sleep(y). Using your equation, if the hours of study is 5, what is the expected hours of sleep? For any credit, make sure you show your work and submit a PDF or picture of it via the test assignment in Week 5. Hours of Study Hours of Sleep 2 10 6 6 6 5 3 9 2 12
Calculate the correlation coefficient for the following data: X=0, -1, -2, -3, -2, -2, 0, 1,...
Calculate the correlation coefficient for the following data: X=0, -1, -2, -3, -2, -2, 0, 1, 2, 3, 2, 1 Y=3, 2, 1, 0, -1, -2, -3, -2, -1, 0, 1, 2 Find through Excel.
Based on the data shown below, calculate the correlation coefficient (rounded to three decimal places) x...
Based on the data shown below, calculate the correlation coefficient (rounded to three decimal places) x y 2 1.6 3 2.67 4 3.84 5 3.71 6 0.48 7 1.75 8 3.42 9 0.89 10 1.96 11 3.13 12 0.1
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
Determine the value of the coefficient of correlation, r, for the following data. X 3 6...
Determine the value of the coefficient of correlation, r, for the following data. X 3 6 7 11 13 17 21 Y 18 13 13 8 7 7 5 (Round the intermediate values to 3 decimal places. Round your answer to 3 decimal places.) r =
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT