Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Data from the U.S. Federal Reserve Board on the percentage of disposable persona

ID: 3176767 • Letter: D

Question

Data from the U.S. Federal Reserve Board on the percentage of disposable personal income required to meet consumer loan payments and mortgage payments for selected years are shown in the following table. What is the value of the correlation coefficient for this data set? (Give the answer to four decimal places.)

r =

Consumer Debt Household Debt Consumer Debt Household Debt

7.88 6.23 6.25 5.72

7.91 6.13 6.10 5.95

7.65 5.96 6.33 6.10

7.60 5.84 6.98 6.27

7.48 5.82 7.39 6.07

7.49 5.84 7.53 5.78

7.37 5.82 7.83 5.81

6.58 5.79

Explanation / Answer

Solution:

Using Excel: =CORREL(range 1, range 2), I get 0.117813

If the correlation coefficient is close to +/-1 then there is a very strong relationship. If the correlation coefficient is close to 0.