Menu
EXCEL PEARSON FUNCTION
Excel PEARSON Function Introduction
For two sets of data, the Pearson function in Excel computes the Pearson Product-Moment Correlation Coefficient.
Description of Excel PEARSON Function
Syntax :
=PEARSON( array1, array2 )
Parameters :
array1 is a collection of independent variables, whereas array2 is a collection of dependent variables. The lengths of these two arrays should be the same.
Step By Step Guide of PEARSON Function
Example :
Pearson’s Product-Moment Correlation The Pearson function in Excel may be used to determine the coefficient of these numbers, as shown below: PEARSON = ( A2:A21, B2:B21 ) The resulting number is 0.870035104, suggesting a significant positive correlation between the two sets of data.
| A | B | |
|---|---|---|
| 1 | x | y |
| 2 | 1 | 10.11 |
| 3 | 2 | 22.90 |
| 3 | 2 | 27.61 |
| 4 | 3 | 27.61 |
| 5 | 4 | 11.15 |
| 6 | 5 | 31.08 |
| 7 | 6 | 37.90 |
| 8 | 7 | 33.49 |
| 9 | 8 | 21.05 |
| 10 | 9 | 27.01 |
| 11 | 10 | 45.78 |
| 12 | 11 | 31.32 |
| 13 | 12 | 50.57 |
| 14 | 13 | 45.48 |
| 15 | 14 | 40.94 |
| 16 | 15 | 53.76 |
| 17 | 16 | 36.18 |
| 18 | 17 | 49.77 |
| 19 | 18 | 55.66 |
| 20 | 19 | 63.83 |
| 21 | 20 | 63.60 |
Key Points
- #N/A – Occurs if the array parameters given are of different lengths.
- #DIV/0! – Occurs if either of the array arguments is empty or the standard deviation of their values is zero.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
