02 May Data Collection & Probability Distribution
Order Instructions
1.6. Table 1-2 gives data on the Consumer Price Index (CPI), S&P 500 stock index, and three-month Treasury bill rate for the United States for the years 1980-2007.
Plot these data with time on the horizontal axis and the three variables on the vertical axis. If you prefer, you may use a separate figure for each variable.
What relationships do you expect to find between the CPI and the S&P index and between the CPI and the three-month Treasury bill rate? Why?
For each variable, “eyeball” a regression line for the scattergram.
1.7. Table 1-3 gives you data on the exchange rate between the U.K. pound and the U.S. dollar (number of U.K. pounds per U.S. dollar) as well as the consumer price indexes in the two countries for the period 1985-2007.
Plot the exchange rate (ER) and the two consumer price indexes against time, measured in years.
Divide the U.S. CPI by the U.K. CPI and call it the relative price ration (RPR).
Plot ER against RPR.
Visually sketch a regression line through the scatterpoints.
(These are all excel problems)
