Spread Formula Reference
RSQ
Formula Functions > Functions R to S > RSQ

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