LinRegR2 (PQL)

* Click on the function's arguments above for more details on the input values.

Comments

The LinRegX functions calculate the linear regression for the supplied values / measures, and then return one of the values associated with that regression. The linear regression functions are:

• LinRegIntercept (PQL) - Returns the value of b, the y-intercept.
• LinRegPoint (PQL) - Returns the y-value for the regression line at a particular value of x.
• LinRegR2 (PQL) - Returns the coefficient of determination, R².
• LinRegSlope (PQL) - Returns the value of a, the slope.

Arguments

LinRegR2 returns the coefficient of determination, R², for the linear regression and requires the following arguments:

• The List parameter is a list or set of elements from an existing hierarchy in the model.
• The hierarchy name needs to be a Unique Name with the format [dimension].^[hierarchy] or [table].[column].
• The Numeric parameters following the set are each evaluated against the specified set to obtain the values for the y- and x-axes, respectively.
• The values can be returned from a hierarchy as a numeric expression.
• If the optional numeric value is not supplied, the current context of the cells is used for the x-axis.

Remarks

• For details on how to employ and use this function see the semantic calculation overview.

Different Function types

This function is like the MDX LinRegR2 function, returning the coefficient of determination, R².

Examples

The following example returns the statistical R² that describes the quality of fit of the linear regression equation to the points for the Fact Sales and the Profit measures

LinRegR2( Tail([Date].[dateKey].allmembers, 10), [Measures].[Fact Sales], [Measures].[Profit] )

Tip: Alternatively, use Last in place of Tail. Last and Tail are aliases for the function that retrieves the last X elements in a given hierarchy. For more information, see Tail (PQL).