Home › Forums › ASREG : Rolling window and Fama-MacBeth Regressions › asreg root mean squared RMSE in Stata › Reply To: asreg root mean squared RMSE in Stata

Attaullah Shah
Keymaster
May 10, 2020 at 7:35 pm
Post count: 69
#3298

Here is my quick proof of asreg accuracy.
You can check your calculation

. sysuse auto, clear
(1978 Automobile Data)

. reg price mpg rep78

      Source |       SS           df       MS      Number of obs   =        69
-------------+----------------------------------   F(2, 66)        =     11.06
       Model |   144754063         2  72377031.7   Prob > F        =    0.0001
    Residual |   432042896        66  6546104.48   R-squared       =    0.2510
-------------+----------------------------------   Adj R-squared   =    0.2283
       Total |   576796959        68  8482308.22   Root MSE        =    2558.5

------------------------------------------------------------------------------
       price |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
         mpg |  -271.6425   57.77115    -4.70   0.000    -386.9864   -156.2987
       rep78 |   666.9568   342.3559     1.95   0.056     -16.5789    1350.492
       _cons |   9657.754    1346.54     7.17   0.000       6969.3    12346.21
------------------------------------------------------------------------------

. asreg reg price mpg rep78, rmse
variable reg not found
r(111);

. asreg  price mpg rep78, rmse

. list _rmse in 1

     +-----------+
     |     _rmse |
     |-----------|
  1. | 2558.5356 |
     +-----------+