Respuesta :
Answer:
Correlation coefficients relating the distributions to FFO = 0.8393
Correlation coefficients relating the distributions to EPS = –0.0880
Explanation:
Let X represents distributions, Y represents FFO, and, Z represents EPS.
Note: See the attached excel file for the calculations of Means of X, Y and Z as well as other values.
Therefore, we have:
Correlation coefficients relating the distributions to FFO = (Total of (X - Mean of X) * (Y - Mean of Y)) / ((Total of (X - Mean of X)^2) * (Total of (Y - Mean of Y)^2))^0.5 = 0.7529 / (0.8554 * 0.9408)^0.5 = 0.8393
Correlation coefficients relating the distributions to EPS = (Total of (X - Mean of X) * (Z - Mean of Z)) / ((Total of (X - Mean of X)^2) * (Total of (Z - Mean of Z)^2))^0.5 = –0.1391 / (0.8554 * 2.9200)^0.5 = –0.0880