How to find relationship between two variables in excel?
Answers
Answered by
1
Explanation:
select a blank cell that you will put the calculation result enter this formula Correl A2 ratio A7, B2 ratio B7 and press enter key to get the correlation coefficient
Answered by
1
Answer:
Answer is here
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. See screenshot: In the formula, A2:A7 and B2:B7 are the two variable lists you want to compare.
Similar questions