. webuse sunspot,clear
(TIMESLAB: Wolfer sunspot data)
. gen trend=_n
.
. list in 1/10
+---------------------+
| spot time trend |
|---------------------|
1. | 80.9 1749 1 |
2. | 83.4 1750 2 |
3. | 47.7 1751 3 |
4. | 47.8 1752 4 |
5. | 30.7 1753 5 |
|---------------------|
6. | 12.2 1754 6 |
7. | 9.6 1755 7 |
8. | 10.2 1756 8 |
9. | 32.4 1757 9 |
10. | 47.6 1758 10 |
+---------------------+
.
. reg spot time
Source | SS df MS Number of obs = 215
-------------+------------------------------ F( 1, 213) = 2.28
Model | 3527.57557 1 3527.57557 Prob > F = 0.1325
Residual | 329410.313 213 1546.52729 R-squared = 0.0106
-------------+------------------------------ Adj R-squared = 0.0060
Total | 332937.888 214 1555.78452 Root MSE = 39.326
------------------------------------------------------------------------------
spot | Coef. Std. Err. t P>|t| [95% Conf. Interval]
-------------+----------------------------------------------------------------
time | .0652643 .0432132 1.51 0.132 -.019916 .1504446
_cons | -71.92639 80.24853 -0.90 0.371 -230.1094 86.25662
------------------------------------------------------------------------------
. predict e1,r
. est store ols1
.
. reg spot trend
Source | SS df MS Number of obs = 215
-------------+------------------------------ F( 1, 213) = 2.28
Model | 3527.57557 1 3527.57557 Prob > F = 0.1325
Residual | 329410.313 213 1546.52729 R-squared = 0.0106
-------------+------------------------------ Adj R-squared = 0.0060
Total | 332937.888 214 1555.78452 Root MSE = 39.326
------------------------------------------------------------------------------
spot | Coef. Std. Err. t P>|t| [95% Conf. Interval]
-------------+----------------------------------------------------------------
trend | .0652643 .0432132 1.51 0.132 -.019916 .1504446
_cons | 42.15564 5.382776 7.83 0.000 31.54531 52.76597
------------------------------------------------------------------------------
. predict e2,r
. est store ols2
.
.
. list spot time trend e1 e2 in 1/10
+---------------------------------------------+
| spot time trend e1 e2 |
|---------------------------------------------|
1. | 80.9 1749 1 38.6791 38.6791 |
2. | 83.4 1750 2 41.11383 41.11383 |
3. | 47.7 1751 3 5.348568 5.348568 |
4. | 47.8 1752 4 5.383302 5.383302 |
5. | 30.7 1753 5 -11.78196 -11.78196 |
|---------------------------------------------|
6. | 12.2 1754 6 -30.34723 -30.34723 |
7. | 9.6 1755 7 -33.01249 -33.01249 |
8. | 10.2 1756 8 -32.47776 -32.47776 |
9. | 32.4 1757 9 -10.34302 -10.34302 |
10. | 47.6 1758 10 4.791715 4.791715 |
+---------------------------------------------+
.
. est tab ols1 ols2
----------------------------------------
Variable | ols1 ols2
-------------+--------------------------
time | .06526432
trend | .06526432
_cons | -71.926385 42.15564
----------------------------------------
|