The covariance of the returns between Willow Stock and Sky Diamond Stock is 0.0990. The variance is 0.2540, and the variance of Sky Diamond is 0.1370. What is the correlation coefficient between the returns of the two stocks?
Can this be computed in Excel using one of the Covariance functions? Can you screen shot which one?