SpreadJS 13
SpreadJS Documentation / Formula Reference / Formula Functions / COVARIANCE.P
In This Topic
    COVARIANCE.P
    In This Topic

    This function returns the population covariance, which is the average of the products of deviations for each data point pair in two sets of numbers.

    Syntax

    COVARIANCE.P(array1,array2)

    Arguments

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

    Remarks

    Use this covariance function to determine the relationship between two sets of data. For example, you can determine whether greater income accompanies greater levels of education in a population.

    The covariance is calculated as follows, where n and y are the sample means, AVERAGE(array1) and AVERAGE(array2), and n is the sample size.

    COVARIANCE.P Equation

    Data Types

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

    Examples

    COVARIANCE.P(J2:J5,L2:L5)

    COVARIANCE.P(R2C12:R15C12,R2C14:R15C14)

    COVARIANCE.P({7,5,6},{7,4,4}) gives the result 1

    COVARIANCE.P({5,10,15,20,25},{4,8,16,32,64}) gives the result 144