Question

In: Economics

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.

Solutions

Expert Solution

The Pearson correlation coefficient

\(\mathrm{r}=\frac{s_{x y}}{\sqrt{S_{x x} S_{y y}}}\)

where;

\(\mathrm{S}_{\mathrm{xy}}=\Sigma x y-\frac{\Sigma x \Sigma y}{n}\)

\(\mathrm{S}_{\mathrm{xx}}=\Sigma x^{2}-\frac{(\Sigma \mathrm{x})^{2}}{n}\)

\(\mathrm{S}_{\mathrm{yy}}=\Sigma y^{2}-\frac{(\Sigma y)^{2}}{n}\)

Income (X)

Expenditure (Y)

X2

Y2

XY

35

9

1225

81

315

49

15

2401

225

735

21

7

441

49

147

39

11

1521

121

429

15

5

225

25

75

28

8

784

64

224

25

9

625

81

225

∑= 212

∑= 64

∑= 7222

∑= 646

∑= 2150

 

 

 

 

 

 

 

 

 

 

\(\mathrm{S}_{\mathrm{xy}}=2150-\frac{(212 \times 64)}{7}=211.71\)

\(\mathrm{~S}_{\mathrm{xx}}=7222-\frac{(212)^{2}}{7}=801.4\)

\(\mathrm{~S}_{\mathrm{yy}}=64-\frac{(64)^{2}}{7}=60.86\)

\(\mathrm{r}=\frac{s_{x y}}{\sqrt{S_{x x} S_{y y}}}=\frac{211.71}{\sqrt{801.4 \times 60.86}}\)

r = 0.9586

There is a strong positive correlation between income and expenditure.


There is a strong positive correlation between income and expenditure.

Related Solutions

Calculate the Spearman rank correlation and interpret the results
The following data relates to scores awarded by 2 architects for a certain building design. Calculate the Spearman rank correlation and interpret the results.   Architect No. 1 2 1 37 42 2 28 34 3 30 40 4 18 28 5 31 30 6 40 43
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
Find the Spearman’s rank correlation for the given data and interpret the results.
  Find the Spearman’s rank correlation for the given data and interpret the results. X 7 2 3 5 4 6 7 9 Y 5 6 5 7 4 7 9 8
Compute the Pearson correlation and the values needed to calculate it for the following data. SSx...
Compute the Pearson correlation and the values needed to calculate it for the following data. SSx = ? SSy= ? SP =  ? r = ? Please answer to TWO decimal places. X     Y                  2      3                  3      1                  6      5                  4      4
Pearson Correlation Use the Pearson Correlation to analyze the data below. 1. Report the strength (number)...
Pearson Correlation Use the Pearson Correlation to analyze the data below. 1. Report the strength (number) of the correlation (2 points). 2. Is the correlation statistically significant (alpha .05 two-tailed)? (3 points) income $ fireworks $ 5000 500 10000 450 15000 400 20000 350 25000 300 30000 250 35000 200 40000 150 45000 100 50000 50 55000 25 60000 20 65000 15 70000 10 75000 5 80000 2 85000 1 90000 0 95000 0 100000 0 105000 0 110000 0...
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...
a. Draw a scatter plot. Is this a positive or negative correlation? Explain what a positive correlation and negative correlation are. b.Compute the pearson correlation.
 For the following scores, x y 0 4 2 9 1 6 1 9 a. Draw a scatter plot. Is this a positive or negative correlation? Explain what a positive correlation and negative correlation are. b.Compute the pearson correlation.
Chapter 7 Correlation 7.1. Does correlation show causality? Why or why not? 7.2. For a Pearson...
Chapter 7 Correlation 7.1. Does correlation show causality? Why or why not? 7.2. For a Pearson Correlation, show what a perfect relationship looks like on a graph. 7.3. When do you use Pearson’s correlation and when do you use Spearman’s correlation? Kendall’s tau correlation? 7.4. Describe the difference between a biserial correlation and a point-biserial correlation.
a. Describe what the Pearson correlation coefficient is and what the coefficient of determination is. compare...
a. Describe what the Pearson correlation coefficient is and what the coefficient of determination is. compare it to a real world example or a example problem
To compute a Pearson correlation coefficient, data must be measured on an ordinal scale. true or...
To compute a Pearson correlation coefficient, data must be measured on an ordinal scale. true or false Scatter plots give a visual representation of the strength and direction of the correlation coefficient true or false When you have significant results in data analysis, it is customary to report all relevant means and standard deviations. true or false
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT