Calculates the linear regression of a set, and returns the value of the y-intercept in the regression line, y = ax + b for a particular value of x.
Syntax
LinRegPoint(Slice_Expression_x, Set_Expression, Numeric_Expression_y [ ,Numeric_Expression_x ] )
Arguments
Slice_Expression_x | A valid numeric expression that is typically a Multidimensional Expressions (MDX) expression of cell coordinates that return a number that represents values for the slicer axis. |
---|---|
Set_Expression | A valid Multidimensional Expressions (MDX) expression that returns a set. |
Numeric_Expression_y | A valid numeric expression that is typically a Multidimensional Expressions (MDX) expression of cell coordinates that return a number that represents values for the y-axis. |
Numeric_Expression_x | A valid numeric expression that is typically a Multidimensional Expressions (MDX) expression of cell coordinates that return a number that represents values for the x-axis. |
Examples