Export (0) Print
Expand All
Avg
IIf
Lag
Max
Min
Mtd
Qtd
Sum
Var
Wtd
Ytd
Expand Minimize

LinRegSlope (MDX)

Updated: 17 July 2006

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


LinRegSlope(Set_Expression, Numeric_Expression_y [ ,Numeric_Expression_x ] )

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.

Linear regression, that uses the least-squares method, calculates the equation of a regression line (that is, the best-fit line for a series of points). The regression line has the following equation, where a is the slope and b is the intercept:

y = ax+b

The LinRegSlope function evaluates the specified set against the first numeric expression to obtain the values for the y-axis. The function then evaluates the specified set expression against the second numeric expression, if specified, to get the values for the x-axis. If the second numeric expression is not specified, the function uses the current context of the cells in the specified set as the values for the x-axis. Not specifying the x-axis argument is frequently used with the Time dimension.

After obtaining the set of points, the LinRegSlope function returns the slope of the regression line (a in the previous equation).

ms146085.note(en-US,SQL.90).gifNote:
The LinRegSlope function ignores empty cells or cells that contain text or logical values. However, the function includes cells with values of zero.

Example

The following example returns the slope of a regression line for the unit sales and the store sales measures.

LinRegSlope(LastPeriods(10),[Measures].[Unit Sales],[Measures].[Store Sales])

Release History

17 July 2006

Changed content:
  • Updated syntax and arguments to improve clarity.
  • Added updated examples.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft