Navigation:  Formula Reference > Spreadsheet Formula Functions >

RSQ

Previous pageReturn to chapter overviewNext page

 

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

 

See Also

PEARSON