Excel PEARSON Function

What is PEARSON function in Excel?


The PEARSON function is one of the Statistical functions of Excel.

It returns the Pearson product moment correlation coefficient, r.

We can find this function in Statistical of insert function Tab.

How to use PEARSON function in excel

  1. Click on an empty cell (like F5).
 an empty cell in excel

2. Click on the fx icon (or press shift+F3).

fx icon in excel

3. In the insert function tab you will see all functions.

function list in excel

4. Select STATISTICAL category.

5. Select PEARSON function.

6. Then select ok.

Excel PEARSON function

7. In the function arguments Tab you will see PEARSON function.

8. Array1 is a set of independent values.

9. Array2 is a set of dependent values.

10. You will see the results in the formula result section.

Examples of PEARSON function in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *