Spread Formula Reference
Formula Functions / Functions R to S / RSQ
In This Topic
    RSQ
    In This Topic

    This function returns the square of the Pearson product moment correlation coefficient (R‑squared) through data points in known y’s and known x’s.

    Syntax

    RSQ(array_dep,array_ind)

    Arguments

    This function has these arguments:

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

    The arrays must be the same size.

    Data Types

    Accepts numeric data for both arguments. Returns numeric data.

    Examples

    RSQ(B2:B14,H2:H14)

    RSQ(R2C2:R14C2,R2C8:R14C8)

    RSQ({2,4,6},{10,15,25}) gives the result 0.964286

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    PEARSON | Statistical Functions