PEARSON Excel Formula

Author Zaheer    Category Formulas     Tags ,

There’s a lot of functions that you can use in MS Excel. These functions allow you to do graphs, compute values, and many others. Excel is composed of Engineering Functions, Math Functions, Statistical Function and others which you are use to easily manage data.

The functions in Excel are divided into sub-groups which will allow you to easily find the function you need and perform it. Excel has Statistical Functions which includes the Distribution and Tests of Probability. Included in this sub-group is PEARSON function which basically allows you to calculate Pearson Product-Moments Correlation Coefficients for 2 groups of value.

The syntax of PEARSON functions include:

=PEARSON (array1, array2)

…whereas array1 argument refers to the group of independent values and the array2 argument is a group of dependent values. The given arrays arguments can be in the form of cell that contains the values and names or numbers. If the given cells in the syntax contains tests, logical cells, or when the cell is empty then it will not be included. If the cell in the argument contains the numerical value zero then it will still be included. The error #N/A will occur if the cells are empty and if it does not have the same data point.

In blank Excel worksheet or spreadsheet input the independent values 9 in cell A1, 7 in cell A2, 5 in cell A3, 3 in cell A4, and 1 in cell A5. Likewise, input the independent values 10 in cells B1, 6 in cell B2, 1 in cell B3, 5 in cell B4, and 3 in cell B5. Now input the formula =PEARSON (A1:A5, B1, B5) and the result will be 0.699379. The result is described as Pearson products moment correlation coefficients of the given data in cells.

The #N/A error occurs in PEARSON function if the given arrays or source cells which contains the values differ in lengths or number of cells. The #DIV/0! Error happens if the given arrays or source cells does not contain any data and when the standard deviations of the given values will equate to zero.

Additionally, if you want to change the data from formula to values and vice versa you can hit the Ctrl+` (grave accent) in the keys. In addition, you can do the change of viewing by hitting the Formulas bar, and in Formula Auditing group slot the Show Formulas option.

Post comment