RSquare (Square of Pearson Product Moment Correlation Coefficient)

Returns the square of the Pearson product moment correlation coefficient for a set of values. RSquare gives the proportion of the variance in y that is attributable to the variance in x.

Syntax

RSquare <FactID> (Argument1, Argument2)

Where:

Argument1 is a list of data-point coordinates.

Argument2 is a list of data point coordinates.

FactID is a parameter that forces a calculation to take place on a fact table that contains the selected fact.

Usage Notes

The following conditions are invalid:

• Argument1 and Argument2 have a different number of values.
• Either Argument1 or Argument2 contains one or more NULL values.