Difference between revisions of "Documentation/How Tos/Calc: PEARSON function"

Latest revision as of 14:44, 2 February 2024

FUNCTIONS

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

Returns the Pearson correlation coefficient of two sets of data.

PEARSON(x; y)

where x and y are ranges or arrays containing the two sets of data.

Any text or empty entries are ignored.

PEARSON calculates:

where

are the averages of x,y.

Advanced topic:

The parameters x and y are always evaluated as array formulas.

PEARSON(A1:A30; B1:B30)

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

See Also

@@ Line 1: / Line 1: @@
-__NOTOC__
+{{DISPLAYTITLE:PEARSON function}}
+{{Documentation/CalcFunc StatisticalTOC
+|ShowPrevNext=block
+|PrevPage=Documentation/How_Tos/Calc:_INTERCEPT_function
+|NextPage=Documentation/How_Tos/Calc:_RSQ_function
+}}__NOTOC__
 == PEARSON ==
@@ Line 16: / Line 21: @@
 : <i>Advanced topic:</i>
-: The parameters <tt>'''x'''</tt> and <tt>'''y'''</tt> are always evaluated as * [[Documentation/How_Tos/Using Arrays|array formulas]].
+: The parameters <tt>'''x'''</tt> and <tt>'''y'''</tt> are always evaluated as  [[Documentation/How_Tos/Using Arrays|array formulas]].
 === Example: ===
@@ Line 22: / Line 27: @@
 : returns the Pearson correlation coefficient for the two sets of data in A1:A30 and B1:B30.
-{{Documentation/SeeAlso|
+=== Issues: ===
+* <tt>'''PEARSON'''</tt> is identical to <tt>'''CORREL'''</tt>.
+{{SeeAlso|EN|
 * [[Documentation/How_Tos/Calc: CORREL function|CORREL]]
 * [[Documentation/How_Tos/Calc: RSQ function|RSQ]]
@@ Line 30: / Line 38: @@
 * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
+[[Category: Documentation/Reference/Calc/Statistical functions]]
-=== Issues: ===
-* <tt>'''PEARSON'''</tt> is identical to <tt>'''CORREL'''</tt>.