MicroStrategy ONE
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.