[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

PEARSON

Syntax:

PEARSON ( array-1 , array-2 )

Description: Computes the Pearson product moment correlation coefficient, a dimensionless index that ranges from -1.0 to 1.0, inclusive, and reflects the extent of a linear relationship between two data sets.

Mathematical Formula:

The formula for the Pearson product moment correlation coefficient, r, is:

where x and y are the sample means AVERAGE(array-1) and AVERAGE(array-2).

Arguments:

Name

Type

Description

array-1

number, name, array, reference to number

The set of independent numerical values. If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value 0 are included.

array-2

number, name, array, reference to number

The set of dependent numerical values. If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value 0 are included.

 

Return Type and Value: number – The Pearson product moment correlation coefficient.

However, if

array-1 and array-2 have a different number of data points, the return value is unspecified.

array-1 or array-2 is empty, the return value is unspecified.

[Example:

PEARSON({9,7,5,3,1},{10,6,1,5,3}) results in 0.699378606


end example]