Question: how to calculate linear correlation coefficient r in excel?
Answer: For example, there are two lists of data, and now I will calculate the correlation coefficient between these two variables.
Select a blank cell that you will put the calculation result, enter this formula =CORREL(A2:A7,B2:B7), and press Enter key to get the correlation coefficient.