Spread WPF 17
Spread WPF Documentation / Formula Reference / Formula Functions / PEARSON
In This Topic
    PEARSON
    In This Topic

    Summary

    This function returns the Pearson product moment correlation coefficient, a dimensionless index between -1.0 to 1.0 inclusive indicative of the linear relationship of two data sets.

    Syntax

    PEARSON(array_ind,array_dep)

    Arguments

    This function has these arguments:

    Argument Description
    array_ind Array of independent values (x’s)
    array_dep Array of dependent values (y’s)

    The arrays must be the same size.

    Data Types

    Accepts numeric data for both arguments. Returns numeric data.

    Examples

    PEARSON(B4:G7,B8:G11)

    PEARSON(R4C2:R7C7,R8C2:R11C7)

    PEARSON({2,8,4,16,10,12},{8,2,15,14,18,11}) gives the result 0.262017

    See Also