11 May CPI and S&P 500 Index
Order Instructions
2.12. Table 2-9 gives data on the Consumer Price Index (CPI) for all items (1982-1984 = 100) and the Standard and Poor’s (S&P) index of 500 common stock prices (base of index: 1941-1943 = 10).
Plot the data on a scattergram with the S&P index on the vertical axis and CPI on the horizontal axis.
What can you say about the relationship between the two indexes? What does economic theory have to say about this relationship?
Consider the following regression model: (S&P)t = B1 + B2CPIt + ut
Use the method of least squares to estimate this equation from the preceding data and interpret your results.
Do the results obtained in part (c) make economic sense?
Do you know why the S&P index dropped in 1988?
To be done in excel
