Question: how to calculate correlation coefficient from variance?
Answer: The strength of the relationship between X and Y is sometimes expressed by squaring the correlation coefficient and multiplying by 100. The resulting statistic is known as variance explained (or R2). Example: a correlation of 0.5 means 0.52x100 = 25% of the variance in Y is "explained" or predicted by the X variable.