LinRegPoint

Return to: Calculated Member Builder Function List

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

Syntax

LinRegPoint(«Numeric Expression», «Set», «Numeric Expression»[, «Numeric Expression»])

Remarks

Linear regression by using the least-squares method calculates the equation of the best-it line for a series of points. Let the regression line be given by the equation

y = ax+b

where a is called the intercept and b is called the slope.

LinRegPoint uses the last three arguments, that is «Set» and «Numeric Expression», like the other LinRegxxx functions to calculate the regression line. The function evaluates the first argument «Numeric Expression» and uses the resulting number as the “x” value in the regression equation (y = ax + b) to calculate the “y” value.


Note Empty cells or cells containing text or logical values are ignored; however, cells with zero values are included.


Example

To find the trend in Sales for the sales of the last nine periods and forecast the next period:

LinRegSlope(LastPeriods(9), Sales) returns the value for a.

LinRegIntercept(LastPeriods(9), Sales) returns the value for b.

LinRegPoint(10, LastPeriods(9), Sales) returns the next period.

 

(c) 1988-1998 Microsoft Corporation. All Rights Reserved.