PEARSON
Definition of PEARSON
Calculates r, the Pearson productmoment correlation coefficient of a dataset.
Sample Usage
PEARSON(A2:A100,B2:B100)
Syntax
PEARSON(data_y, data_x)
data_y
 The range representing the array or matrix of dependent data.data_x
 The range representing the array or matrix of independent data.
Notes
Any text encountered in the
value
arguments will be ignored.PEARSON
is synonymous withCORREL
.
See Also
STEYX
: Calculates the standard error of the predicted yvalue for each x in the regression of a dataset.
SLOPE
: Calculates the slope of the line resulting from linear regression of a dataset.
RSQ
: Calculates the square of r, the Pearson productmoment correlation coefficient of a dataset.
INTERCEPT
: Calculates the yvalue at which the line resulting from linear regression of a dataset will intersect the yaxis (x=0).
FORECAST
: Calculates the expected yvalue for a specified x based on a linear regression of a dataset.
FISHERINV
: Returns the inverse Fisher transformation of a specified value.
FISHER
: Returns the Fisher transformation of a specified value.
COVAR
: Calculates the covariance of a dataset.
CORREL
: Calculates r, the Pearson productmoment correlation coefficient of a dataset.
In order to use the PEARSON formula, start with your edited Excellentable
Then type in the PEARSON Formula in area you would like to display the outcome:
Type in the complete PEARSON formula for a cell as shown below:
Excellentable will generate the outcome when hitting enter.
A

B

C



1


2


3


4


5


6


7


8


9


10


11


12


13


14


15
