5 Estimation
5 Estimation
5 Estimation
Linear relations
• Yt = b0 + b1 Xt
• Where Yt is the dependent variable being forecasted
• Xt is the independent variable being used to explain Y. In
Linear Trend Lines, Xt is assumed to be t.
• b1 is the slope of the line, determined by Excel
• b0 is the y intercept of the line, determined by Excel
Coefficient of Determination: R-square
10000
8000
6000
4000
2000
0
0 1000 2000 3000 4000 5000 6000
S q u a re F e e t
Equation for the Sample
Regression Line: Example
Yˆi b0 b1 X i
1636.415 1.487 X i
Interpretation of Results: Example