Question: what is the formula in excel to calculate the correlation coefficient?
Answer: =CORREL(A2:A11,B2:B11) A correlation coefficient of 0.998829 means there's a strong positive correlation between the two sets. As the 'X Variables' increase, the 'Y Variables' increases also.