Manuals/calci/CORREL
Jump to navigation
Jump to search
CORREL(A1,A2)
Where A1 is the first cell range and A2 is a second cell range.
CORREL (Correlation coefficient) is to determine the relationship between two properties
· Cells with value zero are included, but if an array or reference argument contains text, logical values, empty cells which are ignored
· CORREL returns the error value when either A1 or A2 is empty.
· The equation to find out the correlation coefficient is:
where x and y are the means A1and A2.
CORREL
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 8 | 3 | 0.421665 | |
| Row2 | 5 | 10 | ||
| Row3 | 12 | 15 | ||
| Row4 | 2 | 5 | ||
| Row5 | 3 | 11 | 0 | |
| Row6 | ||||
| Row7 |
AVEDEV (N1, N2...) Where N1, N 2 ... are positive integers.
|
=CORREL (B2:B6, C2:C6) is 0.4217 |
|
|
|
|