In Exercise 1, you collected data on and then graphed the Dow Jones Industrial Average (DJIA). This same site reports forecast values of the DJIA. Go to http://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?

Data from Exercise 1

In this exercise, we will practice collecting data from the Web and graphing it using Excel. Go to http://www.forecasts.org/data/index.htm, click on Stock Index Data at the top of the page, and choose the U.S. Stock Indices—Monthly option. Finally, choose the Dow Jones Industrial Average option.

a. Move the data into an Excel spreadsheet.

b. Using the data from part (a), prepare a graph. Use the Excel Chart Wizard to properly label your axes.