The Economics of Money, Banking, and Financial Markets 10th Edition by Frederic Mishkin

Exercise 1

In Web Exercise 1 you collected and graphed the Dow Jones Industrial Average (DJIA). This same site reports forecast values of the DJIA. Go to www.forecasts.org/ data/index.htm and click on FFC Home at the top of the page. Click on the Dow Jones Industrial link under Forecasts in the far left column.
a. What is the Dow forecast to be in six months?
b. What percentage increase is forecast for the next six months?
Reference: Web Exercise 1:
In this exercise we will practice collecting data from the Web and graphing it using Excel. Use the example on pages 15-18 as a guide. Go to www.forecasts.org/data/index.html, click on Stock Index Data at the top of the page, then choose the U.S. Stock Indices-Monthly option. Finally, choose the Dow Jones Industrial Average option.
a. Using the method presented in this chapter, move the data into an Excel spreadsheet.
b. Using the data from part a, prepare a graph. Use the graphing wizard to properly label your axes.