Slope

Top  Previous  Next

Calculation:

[ n * sum(X*Y) - sum(X) * sum(Y) ]
[ n * sum(X*X) - sum(X) * sum(X) ]

where

sum(X*X) = sum of X*X over the last n periods

sum(X*Y) = sum of X*Y over the last n periods

sum(X) = sum of X over the last n periods

sum(Y) = sum of Y over the last n periods

X = Period Number

Y = Time Series

n = Regression Periods

Discussion:
Computes the slope of the linear regression line. Note that the linear regression line is the straight line that provides the best fit to the time series points (y axis) and their corresponding time period (x axis) over the last n periods.