I made the same mistake until I read the section more carefully.
It has to do with the "conditional" part of the explanation, I believe. I got the same .49 value when I calculated Y-bar using all 9 values. Based on the equation at the top of page 155, Y-bar should be the average of the first 8 Y values only. This makes sense based on the sentence right above equation 7.2.2 on page 154 too and the basic idea that we're using the Y_t_1 observations as X and Y_t observations as Y.
Doing this results in the same estimate of .54 that the Excel regression tool returns.
|