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

Revision as of 13:36, 25 February 2009

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.

@@ Line 16: / Line 16: @@
 : <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 22: @@
 : returns the Pearson correlation coefficient for the two sets of data in A1:A30 and B1:B30.
-=== See also: ===
+{{Documentation/SeeAlso|
-[[Documentation/How_Tos/Calc: PEARSON function|'''PEARSON''']],
+* [[Documentation/How_Tos/Calc: PEARSON function|PEARSON]],
-[[Documentation/How_Tos/Calc: RSQ function|'''RSQ''']]
+* [[Documentation/How_Tos/Calc: RSQ function|RSQ]]
-[[Documentation/How_Tos/Calc: Statistical functions|'''Statistical functions''']]
+* [[Documentation/How_Tos/Calc: Statistical functions|Statistical functions]]
-[[Documentation/How_Tos/Calc: Functions listed alphabetically|'''Functions listed alphabetically''']],
+* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
-[[Documentation/How_Tos/Calc: Functions listed by category|'''Functions listed by category''']]
+* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 === Issues: ===
 * <tt>'''CORREL'''</tt> is identical to <tt>'''PEARSON'''</tt>.