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.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.