Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Tag: PEARSON function

PEARSON function: Description, Usage, Syntax, Examples and Explanation

What is PEARSON function in Excel? PEARSON function is one of Statistical functions in Microsoft Excel that returns the Pearson product moment correlation coefficient, r, a dimensionless index that ranges from -1.0 to 1.0 inclusive and reflects the extent of a linear relationship between two data sets. Syntax of PEARSON function PEARSON(array1, array2) The PEARSON function syntax has the following arguments:…