CORREL function
From Apache OpenOffice Wiki
< Documentation | How Tos
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Spreadsheet Lookup functions
Measures of dispersion / spread
Probability and statistics
Correlation and line fitting
See also (in the Arrays Functions category); GROWTH, LINEST, LOGEST, TREND
Ranking
CORREL
Returns the Pearson correlation coefficient of two sets of data.
Syntax:
CORREL(x; y)
- where x and y are ranges or arrays containing the two sets of data.
- Any text or empty entries are ignored.
- CORREL calculates:
- where
are the averages of x,y.
- Advanced topic:
- The parameters x and y are always evaluated as array formulas.
Example:
CORREL(A1:A30; B1:B30)
- returns the Pearson correlation coefficient for the two sets of data in A1:A30 and B1:B30.
Issues:
- CORREL is identical to PEARSON.
See Also
