CORREL function
The CORREL function in Excel calculates the correlation coefficient between two data sets. The correlation coefficient measures the strength and direction of the linear relationship between two variables. It returns a value between -1 and 1:
- A value of 1 indicates a perfect positive linear relationship.
- A value of -1 indicates a perfect negative linear relationship.
- A value of 0 indicates no linear relationship.
Syntax:
CORREL(array1, array2)
Arguments:
- array1: The first range or array of values (the first data set).
- array2: The second range or array of values (the second data set).
Both arrays must have the same number of data points, and they should correspond to each other (i.e., each element in array1 should be paired with the corresponding element in array2).
Example:
Suppose you have two sets of data:
- Data set 1 (in range
A2:A10):10, 20, 30, 40, 50, 60, 70, 80, 90 - Data set 2 (in range
B2:B10):15, 25, 35, 45, 55, 65, 75, 85, 95
You would use:
=CORREL(A2:A10, B2:B10)
This function would return a value close to 1, indicating a strong positive linear relationship between the two sets of data.
Interpreting the result:
- A positive correlation (closer to 1) means that as one variable increases, the other also tends to increase.
- A negative correlation (closer to -1) means that as one variable increases, the other tends to decrease.
- A correlation close to 0 indicates little or no linear relationship between the two variables.