Calculates the linear regression of a set and returns the value of y in the regression line y = ax + b

Syntax

 

LinRegPoint(Numeric_expression_output_x, Set_expression, Numeric_expression y, Numeric_expression x)

Arguments

Numeric_expression_output_x

Numeric expression that represents values for the x axis function will be applied to
Set_ExpressionMDX expression that returns a set function is calculated by
Numeric_Expression_yNumeric expression that represents values for the y axis function is calculated by
Numeric_Expression_xNumeric expression that represents values for the x axis function is calculated by

Examples

 

See also