Documentation/How Tos/Calc: PEARSON function

From Apache OpenOffice Wiki
< Documentation‎ | How Tos
Revision as of 10:15, 26 May 2008 by Drking (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


PEARSON

Returns the Pearson correlation coefficient of two sets of data.

Syntax:

PEARSON(independent; dependent)

where independent and dependent are ranges or arrays containing the first and second sets of data.
Any text or empty entries are ignored.
Advanced topic:
The parameters independent and dependent are always evaluated as array formulas.

Example:

PEARSON(A1:A30; B1:B30)

returns the Pearson correlation coefficient for the two sets of data in A1:A30 and B1:B30.

See also:

Statistical functions

Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_PEARSON_function&oldid=78754"
Personal tools