PEARSON

Formulas / PEARSON
Calculate the Pearson product moment correlation coefficient.
=PEARSON(array1,array2)
  • array1 - a collection of independent variables
  • array2 - a list of dependent variables

Examples

  • =PEARSON(A2:A10, B2:B10)

    In this example, the PEARSON function is used to calculate the Pearson correlation coefficient between two sets of data points in the ranges A2:A10 and B2:B10. The Pearson correlation coefficient measures the linear relationship between two variables, with values ranging from -1 (perfect negative correlation) to 1 (perfect positive correlation). The formula returns the Pearson correlation coefficient for the given data sets, indicating the strength and direction of the linear relationship between the two variables.

  • =PEARSON(C2:C15, D2:D15)

    In this example, the PEARSON function is used to calculate the Pearson correlation coefficient between two sets of data points in the ranges C2:C15 and D2:D15. The formula returns the Pearson correlation coefficient for the given data sets. A positive value close to 1 indicates a strong positive linear relationship between the two variables, while a negative value close to -1 indicates a strong negative linear relationship. A value close to 0 suggests little to no linear relationship between the variables.


Summary

The PEARSON function calculates the Pearson product moment correlation coefficient, which measures the linear relationship between two data sets. It takes two arrays of numbers, names, array constants, or references containing numbers.

  • The PEARSON function returns the Pearson product moment correlation coefficient, a dimensionless index of correlation that ranges from -1 to 1, which measures the linear relationship between data sets.
  • The arguments for the PEARSON function must be numbers or names, array constants, or references containing numbers.
  • The PEARSON function ignores empty cells in the array arguments and includes cells with the value zero.

Frequently Asked Questions

What is the PEARSON function?
The PEARSON function is a statistical function that calculates the Pearson product moment correlation coefficient. This coefficient reflects the degree of a linear relationship between two data sets.
What is the range of the Pearson product moment correlation coefficient?
The Pearson product moment correlation coefficient ranges from -1.0 to 1.0.
What are the arguments for the PEARSON function?
The PEARSON function takes two arguments. These arguments must be numbers, names, array constants, or references containing numbers.
Does the PEARSON function take other data types?
The PEARSON function ignores text, logical values, and empty cells.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV