consumer debt federal reserve

Need help with a problem of statistics ….:)?

1) Data from the U.S. Federal Reserve (House hold services load Debt, 2002) on the percentage of disposable income income requied to meet payments on consumer loans and mortgage payments for selected years are shown in the following table: Consumer Debt / House Hold Debt / Consumer debt / household debt 7.88/6.22/6.24/5.73 7.91/6.14/6.09/5.95 7.65/5.95/6.32/6.09 7.61/5.83/6.97/6.28 7.48/5.83/7.38/6.08 7.49/5.85/7.52/5.79 7.37/5.81/7.84/5.81 6.57/5.79 A) What is the correlation coefficient of this set of data? B) Is it reasonable to conclude that in this case there is no strong relationship between variables (linear or not) Use a graph to support your answer.

Excel Help: Correlation (rank 1, Series 2), I get 0.117813 Yes, there is no strong relationship. If the correlation coefficient is close to + / -1 then there is a strong relationship. If the correlation coefficient is close to 0, then there is little or nothing. You can plot each piece of digital data (debt household debt consumption) that (x, y) coordinates data show that looking straight at her.