Free Time Series Trend Calculator
Estimate a linear trend from time-series data using the slope of the regression line over time periods.
Trend Slope (per period)
7.2000
Trend Intercept93.0000
Forecast Period 6136.2000
Average Value114.6000
Trend Slope (per period) vs Period 1 Value
How to Estimate a Time Series Trend
Method
Fit a least-squares regression line Y = a + b*t where t is the time period (1, 2, 3, ...). The slope b is the average change per period. The intercept a is the estimated value at t=0. Extrapolating the line gives forecasts for future periods.
Slope b = [n*Sum(t*y) - Sum(t)*Sum(y)] / [n*Sum(t^2) - (Sum(t))^2]
Example Calculation
Five periods with values 100, 108, 115, 120, 130.
- 01Sum(y) = 573, Sum(t) = 15, Sum(t^2) = 55
- 02Sum(t*y) = 1*100 + 2*108 + 3*115 + 4*120 + 5*130 = 1791
- 03Slope = (5*1791 - 15*573) / (5*55 - 225) = (8955-8595)/50 = 7.2
- 04Intercept = (573 - 7.2*15)/5 = (573 - 108)/5 = 93
- 05Forecast for period 6: 93 + 7.2*6 = 136.2
Frequently Asked Questions
Learn More
Understanding the Normal Distribution
Learn what the normal distribution is, why it matters in statistics, and how to use the bell curve for probability calculations, z-scores, and real-world data analysis.