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)
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we\'ll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.