Pearson product moment correlation coefficient

This function returns the Pearson product moment correlation coefficient of a set of values. The coefficient is a dimensionless index that ranges from -1.0 to 1.0 (inclusive). It is used to determine the extent of a relationship between two data sets.

Syntax

Pearson <FactID> (Argument1, Argument2)

Where:

Argument1 is a list of independent values represented by a fact or metric.

Argument2 is a list of dependent values represented by a fact or metric.

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

Expression

In the expression that follows, Argument1 = X, Argument2 = Y.

Usage Notes

The following conditions are invalid:

• Either Argument1 or Argument2 contains one or more null values
• Argument1 and Argument2 contain a different number of data points