Spread Formula Reference
Formula Functions / Functions A to C / CORREL
In This Topic
    CORREL
    In This Topic

    This function returns the correlation coefficient of the two sets of data.

    Syntax

    CORREL(array1,array2)

    Arguments

    The two arrays of data in the arguments of this function should meet these criteria:

    Data Types

    Accepts arrays of numeric data for both arguments. Returns numeric data.

    Examples

    CORREL(C1:C10,D1:D10)

    CORREL(R1C3:R10C3,R1C4:R10C4)

    CORREL({5,10,15,20,25},{4,8,16,32,64}) gives the result 0.9332565253

    CORREL({73000,45000,40360},{42,70,40}) gives the result -0.3261046660

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    COVAR | Statistical Functions