Embedded Files
COMPUTATION OF CORRELATION
Correlation The correlation coefficient (a value between -1 and +1) tells how strongly two variables are related to each other. A correlation coefficient of +1 indicates a perfect positive correlation. As variable X increases, variable Y increases. As variable X decreases, variable Y decreases.Excel has the CORREL function or Data Analysis to find the correlation coefficient between two variables. The syntax for CORREL FUNCTION is =CORREL(array1, array2) array1 : array of variable x array2 : array of variable yExample : =CORREL(A2:A6, B2:B6)
Page updated
Report abuse