CORREL
Returns the correlation coefficient between two data sets
Syntax
CORREL(array1, array2)
Arguments
| Argument | Description | Required |
|---|---|---|
array1 |
A cell range of values | Required |
array2 |
A second cell range of values | Required |
Examples
Correlation between two data sets
=CORREL(A1:A5, B1:B5)
Result ⇒ 0.6396
| A | B | |
| 1 | 3 | 2 |
| 2 | 2 | 4 |
| 3 | 4 | 5 |
| 4 | 5 | 4 |
| 5 | 6 | 6 |
Correlation with perfect positive correlation
=CORREL(A1:A3, B1:B3)
Result ⇒ 1
| A | B | |
| 1 | 1 | 2 |
| 2 | 2 | 4 |
| 3 | 3 | 6 |
Correlation with mixed values
=CORREL(A1:A3, B1:B3)
Result ⇒ 1
| A | B | |
| 1 | 10 | 5 |
| 2 | 20 | 15 |
| 3 | 30 | 25 |
Related Functions
Other Statistical functions:
- AVEDEV - Returns the average of the absolute deviations of data points from their mean
- AVERAGE - Returns the average of given arguments. Text is ignored.
- COUNT - Returns the count of numeric values in a dataset.
- COUNTA - Returns the count of values in a list of arguments including text, logical values, error values, and empty text.
- COUNTIF - Returns the count of cells that meet a specified criteria
- COUNTIFS - Returns the count of criteria_ranges based on the given criterions.
- FORECAST - Calculates, or predicts, a future value by using existing values
- LARGE - Returns the k-th largest value in a data set
- MAX - Returns the largest number from the provided arguments
- MEDIAN - Returns the median of the given numbers
- MIN - Returns the smallest number from the provided arguments
- MINIFS - Returns the minimum value from a range that meets multiple criteria.
- MODE - Returns the most frequently occurring value in a data set
- PERCENTILE - Returns the k-th percentile of values in a range
- PERCENTRANK - Returns the rank of a value in a dataset as a percentage (0 to 1) of the dataset
- RANK - Returns the rank of a number from the list of other numeric values
- SMALL - Returns the k-th smallest value in a data set
- STDEV - Returns the estimated standard deviation based on a sample
- STDEVP - Calculates standard deviation based on the entire population
- SUMIF - Returns the sum of a range depending on criteria
- SUMPRODUCT - Returns the sum of products for a list of arguments
- VAR - Returns the estimated variance for a sample of data
- VARP - Calculates variance based on the entire population