SheetFX
≡
<< Go back to all functions

PEARSON

The PEARSON function in Google Sheets calculates r, the Pearson product-moment correlation coefficient of a dataset. This function is commonly used in statistical analysis to measure the strength and direction of the linear relationship between two sets of data.

Function Syntax and Parameters

Syntax: PEARSON(data_y, data_x)

Parameters:

  • data_y: The array or range containing the dependent variable data points.
  • data_x: The array or range containing the independent variable data points.

Step-by-Step Tutorial

  1. Using PEARSON function:
    • Example: If A1:A5 has the dependent variable values and B1:B5 has the independent variable values, then =PEARSON(A1:A5, B1:B5) will return the Pearson correlation coefficient.

Use Cases and Scenarios

  1. Financial Analysis: Measure the correlation between stock prices of two companies.
  2. Economic Research: Analyze the relationship between income and expenditure.
  3. Marketing Analytics: Determine the correlation between advertising spend and sales revenue.

Related Functions

  • CORREL: Calculate the correlation coefficient between two datasets.
  • COVARIANCE.P: Calculate the covariance between two datasets.

Related Articles