Skip to main content

PEARSON

Definition of PEARSON

Calculates r, the Pearson product-moment 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 with CORREL.

See Also

STEYX: Calculates the standard error of the predicted y-value 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 product-moment correlation coefficient of a dataset.

INTERCEPT: Calculates the y-value at which the line resulting from linear regression of a dataset will intersect the y-axis (x=0).

FORECAST: Calculates the expected y-value 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 product-moment 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
State
Independent values
Dependent values
2
Alabama
9
10
3
Alaska
7
6
4
Arizona
5
1
5
Arkansas
3
5
6
California
1
3
7
Colorado
6
2
8
Connecticut
2
9
9
Delaware
8
7
10
Florida
7
8
11
Georgia
5
4
12
Hawaii
4
3
13
Idaho
3
6
14
15
0.699378606

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.