Formulas > =PEARSON()

How To Use PEARSON() Function in Google Sheets


Calculates r, the Pearson product-moment correlation coefficient of a dataset.

Common Questions about the PEARSON Formula:
-What is the PEARSON formula?
-What does the PEARSON formula do?
-How do I calculate PEARSON in Google Sheets?

How can the PEARSON formula be used appropriately?
The PEARSON formula can be used to calculate the Pearson correlation coefficient to measure the strength and direction of the linear relationship between two variables. It can also be used to generate a P-value which tests the significance of the correlation.

How can the PEARSON formula be commonly mistyped?
The PEARSON formula in Google Sheets uses the syntax PEARSON (x data range, y data range). A common mistake is to forget to include the parentheses or to mistype the name as ‘person’ instead of ‘pearson’.

What are some common ways the PEARSON formula is used inappropriately?
The PEARSON formula should only be used to measure linear relationships, while non-linear relationships should be analyzed with other statistical models. The formula should also not be used to analyze more than two variables at a time.

What are some common pitfalls when using the PEARSON formula?
The PEARSON formula does not indicate anything about the form of the relationship between the two variables, so a correlation coefficient of ‘1’ does not necessarily indicate the variables are perfectly related. Additionally, the PEARSON formula can be influenced by outliers or extreme values, so any data should be examined for irregularities before calculating the PEARSON.

What are common mistakes when using the PEARSON Formula?
-Using the formula on data with non-linear relationships.
-Failing to use P-values to assess significance of the correlation.
-Forgetting to remove outliers or extreme values before calculating the PEARSON.
-Incorrectly typing/formatting the formula into the Google Sheets document.

What are common misconceptions people might have with the PEARSON Formula?
-That a correlation coefficient of ‘1’ indicates a perfect relationship between two variables.
-That the PEARSON formula can be used to analyze more than two variables. 
-That the PEARSON formula can be used to determine causality between two variables.

How To Actually Use PEARSON() in Sheets

PEARSON(data_y, data_x)

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Generate a PEARSON() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.