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

Latest revision as of 14:40, 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.

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.

CORREL(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:CORREL function}}
+{{Documentation/CalcFunc StatisticalTOC
+|ShowPrevNext=block
+|PrevPage=Documentation/How_Tos/Calc:_ZTEST_function
+|NextPage=Documentation/How_Tos/Calc:_COVAR_function
+}}__NOTOC__
 == CORREL ==
@@ Line 13: / Line 18: @@
 :<tt>'''CORREL'''</tt> calculates:
 ::[[Image:Calc_pearson_equation.png]]
+:: where [[Image:Calc_xymean.png]] are the averages of <i>x</i>,<i>y</i>.
 : <i>Advanced topic:</i>
@@ Line 20: / Line 26: @@
 <tt>'''CORREL(A1:A30; B1:B30)'''</tt>
 : returns the Pearson correlation coefficient for the two sets of data in A1:A30 and B1:B30.
-=== See also: ===
-[[Documentation/How_Tos/Calc: PEARSON function|'''PEARSON''']]
-[[Documentation/How_Tos/Calc: Statistical functions|'''Statistical functions''']]
 === Issues: ===
 * <tt>'''CORREL'''</tt> is identical to <tt>'''PEARSON'''</tt>.
+{{SeeAlso|EN|
+* [[Documentation/How_Tos/Calc: PEARSON function|PEARSON]]
+* [[Documentation/How_Tos/Calc: RSQ function|RSQ]]
+* [[Documentation/How_Tos/Calc: Statistical functions|Statistical functions]]
+* [[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]]