Question

In: Finance

Using the following 5 year data series, calculate the correlation between interest rates and US new...

Using the following 5 year data series, calculate the correlation between interest rates and US new home sales.

Year Home sales (thousands) Interest rate (%)
1 520 8
2 673 5
3 631 3
4 581 8
5 658 10

The answer is -.263

Please show how to get there

Solutions

Expert Solution

  • Let 'x' be the data set of home sales & 'y' be the data set of interest rates.
  • Find the mean of x (let it be x̄) and the mean of y (let it be ȳ).
    • x
      1 520
      2 673
      3 631
      4 581
      5 658
      Sum of x 3063
    • Mean 'x̄' = Sum of the terms/number of terms = 3063 ÷ 5 = 612.6
    • y
      1 8
      2 5
      3 3
      4 8
      5 10
      Sum of y 34
    • Mean 'ȳ' = Sum of the terms/number of terms = 34 ÷ 5 = 6.8
  • Subtract mean from each value in the data series. i,e, find (x - x̄) & (y - ȳ)
  • FInd covariance of both 'x' & 'y': Cov(x, y) = [Σ(x - x̄) * (y - ȳ)] / n = -182.4/5 = -36.48
  • Find standard deviation of x and y.
    • Standard deviation (σx) = √Σ(x - x̄)2/n = √15621.2/5 = √3124.24 = 55.8949
    • Standard deviation (σy) = √Σ(y - ȳ)2/n = √30.8/5 = √6.16 = 2.481935
  • Correlation between x & y = Cov (x, y) ÷ (σxy) = -36.48 ÷ (55.8949 * 2.481935) = -36.48 ÷ 138.7275 = -0.263

Related Solutions

1. Calculate the Correlation between height and weight, using centimeters and kilograms 2. Calculate the Correlation...
1. Calculate the Correlation between height and weight, using centimeters and kilograms 2. Calculate the Correlation between height and weight, using inches and pounds 3. Compare these correlations. What would you conclude? 4. Create a Scatter plot graph of these data. Graph: Select Pounds in the X axis and Inches in the Y Insert a scatter graph Click on the first graph Click on Drawing Tools and then layout: Select Axis Titles: write the titles Do the same thing for...
Calculate the net future value at year 2 for the following cashflows and interest rates...
Calculate the net future value at year 2 for the following cash flows and interest rates compounded quarterly (rounded $ to two places after the decimal). The year 0 cash flow is $399, the year 1 cash flow is $204, and the year 2 cash flow is $-155. The interest rate for the first period (year 0 to 1) is 3% and the interest rate for the second period (year 1 to 2) is 4.7%.
Using the data in the following? table, and the fact that the correlation of A and...
Using the data in the following? table, and the fact that the correlation of A and B is 0.02?, calculate the volatility? (standard deviation) of a portfolio that is 80% invested in stock A and 20% invested in stock B.              Stock A   Stock B 2005       -12           16 2006        13           20 2007          8           7 2008         -1         -1 2009          5        -12 2010          6          15 The standard deviation of the portfolio is?
Using the data in the following​ table, and the fact that the correlation of A and...
Using the data in the following​ table, and the fact that the correlation of A and B is 0.32​, calculate the volatility​ (standard deviation) of a portfolio that is 80% invested in stock A and 20% invested in stock B.    Stock A   Stock B 2005   -4   28 2006   19   20 2007   3   8 2008   -1   -8 2009   5   -9 2010   13   30
Using the data in the following​ table, and the fact that the correlation of A and...
Using the data in the following​ table, and the fact that the correlation of A and B is 0.39​, calculate the volatility​ (standard deviation) of a portfolio that is 70% invested in stock A and 30% invested in stock B. Realized Returns Year Stock A Stock B 2008 −8​% 27​% 2009 17​% 28​% 2010 1​% 11​% 2011 −3​% −2​% 2012 1​% −3​% 2013 8​% 26​% The standard deviation of the portfolio is _%?
For the following data​ (a) display the data in a scatter​ plot, (b) calculate the correlation...
For the following data​ (a) display the data in a scatter​ plot, (b) calculate the correlation coefficient​ r, and​ (c) make a conclusion about the type of correlation. The ages​ (in years) of 6 children and the number of words in their vocabulary ​ Age, x 1 2 3 4 5 6 Vocabulary​ size, y 150 1100 1150 1800 2050 2700 A] The correlation coefficient r is
Calculate the net present value at year 0 for the following cash flows and interest rates...
Calculate the net present value at year 0 for the following cash flows and interest rates compounded semi-annually (rounded $ to two places after the decimal). The year 0 cash flow is $373, the year 1 cash flow is $200, and the year 2 cash flow is $-147. The interest rate for the first period (year 0 to 1) is 3% and the interest rate for the second period (year 1 to 2) is 4.5%.
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...
Calculate the wavelengths (in nm) of the first 5 transitions in the Balmer series using the...
Calculate the wavelengths (in nm) of the first 5 transitions in the Balmer series using the Rydberg equation. Convert the wavelengths calculated into frequencies.
Use the data values in the table below to calculate the correlation, r, between the variables...
Use the data values in the table below to calculate the correlation, r, between the variables x and y. x y 4 12.32 5 13.1 6 16.68 7 20.26 8 22.44 9 22.72 10 23.4 11 26.98 12 28.66 Give your answer to rounded three decimal places.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT