Question: using the following 5 year data series calculate the correlation...
Using the following 5 year data series, calculate the correlation between interest rates and US new home sales.
|Year||Home sales (thousands)||Interest rate (%)|
the correct answer is :
Hint: Use the definition of correlation to calculate the result. Some useful intermediate values would be the means of the two variables, their covariance, and their standard deviations.
Double check your results with spreadsheet functions COVARIANCE.S, VAR.S, CORREL. please show the work on excel. Thank you.