Chapter 1: Q 1. (page 68)
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.
Short Answer
a.
a. The excel data can be shown as follows:
| Date | Dow Jones Industrial Average | Average of Month | Note |
| Mar-17 | 20827.11 | Actual |
| Apr-17 | 20686.54 | Actual |
| May-17 | 20931.48 | Actual |
| Jun-17 | 21313.8 | Actual |
| Jul-17 | 21570.95 | Actual |
| Aug-17 | 21916.99 | Actual |
| Sep-17 | 22165.64 | Actual |
| Oct-17 | 23020.69 | Actual |
| Nov-17 | 23538.69 | Actual |
| Dec-17 | 24555.37 | Actual |
| Jan-18 | 25782.18 | Actual |
| Feb-18 | 25006.63 | Actual |
| Mar-18 | 24617.27 | Actual |
| Apr-18 | 24313.65 | Actual |
| May-18 | 24554.64 | Actual |
| Jun-18 | 24795.94 | Actual |
| Jul-18 | 24962.51 | Actual |
| Aug-18 | 25620.62 | Actual |
| Sep-18 | 26231.39 | Actual |
| Oct-18 | 25640.71 | Actual |
| Nov-18 | 25235.62 | Actual |
| Dec-18 | 23854.36 | Actual |
| Jan-19 | 24115.19 | Actual |
| Feb-19 | 25579.37 | Actual |
| Mar-19 | 25716.07 | Actual |
| Apr-19 | 26384.66 | Actual |
| May-19 | 25744.93 | Actual |
| Jun-19 | 26145.37 | Actual |
| Jul-19 | 27080.87 | Actual |
| Aug-19 | 26064.62 | Actual |
| Sep-19 | 26895.4 | Actual |
| Oct-19 | 26742.02 | Actual |
| Nov-19 | 27773.13 | Actual |
| Dec-19 | 28167.96 | Actual |
| Jan-20 | 28872.08 | Actual |
| Feb-20 | 28568.16 | Actual |
| Mar-20 | 22612.3 | Actual |
| Apr-20 | 23282.81 | Actual |
| May-20 | 24269.68 | Actual |
| Jun-20 | 26056.15 | Actual |
| Jul-20 | 26381.27 | Actual |
| Aug-20 | 27788.86 | Actual |
| Sep-20 | 27756.69 | Actual |
| Oct-20 | 28029.2 | Actual |
| Nov-20 | 29110.34 | Actual |
| Dec-20 | 30138.69 | Actual |
| Jan-21 | 30834.13 | Actual |
| Feb-21 | 31252.92 | Actual |
| Mar-21 | 32346.05 | Actual |
| Apr-21 | 33774.76 | Actual |
| May-21 | 34259.08 | Actual |
| Jun-21 | 34295.95 | Actual |
| Jul-21 | 34772.46 | Actual |
| Aug-21 | 35232.1 | Actual |
| Sep-21 | 34737.34 | Actual |
| Oct-21 | 35016.81 | Actual |
| Nov-21 | 35872.25 | Actual |
| Dec-21 | 35616.98 | Actual |
| Jan-22 | 35460.29 | Actual |
| Feb-22 | 34653.11 | Actual |
| Mar-22 | 34015.27 | Actual |
| Apr-22 | 35090 | Forecast |
| May-22 | 35610 | Forecast |
| Jun-22 | 35960 | Forecast |
| Jul-22 | 36300 | Forecast |
| Aug-22 | 35640 | Forecast |
| Sep-22 | 35150 | Forecast |
| Oct-22 | 35780 | Forecast |
| Nov-22 | 36300 | Forecast |
b.
Step by step solution
Step 1. Introduction
Stock or shares are instruments to raise fund that are sold by corporations in the market through IPO and then are exchanged by share holders in the secondary market. Stock indices are indicators that are used to indicate the situation in stock market.
Step 2. Explanation Part a
a. The excel data can be shown as follows:
| Date | Dow Jones Industrial Average | Average of Month | Note |
| Mar-17 | 20827.11 | Actual |
| Apr-17 | 20686.54 | Actual |
| May-17 | 20931.48 | Actual |
| Jun-17 | 21313.8 | Actual |
| Jul-17 | 21570.95 | Actual |
| Aug-17 | 21916.99 | Actual |
| Sep-17 | 22165.64 | Actual |
| Oct-17 | 23020.69 | Actual |
| Nov-17 | 23538.69 | Actual |
| Dec-17 | 24555.37 | Actual |
| Jan-18 | 25782.18 | Actual |
| Feb-18 | 25006.63 | Actual |
| Mar-18 | 24617.27 | Actual |
| Apr-18 | 24313.65 | Actual |
| May-18 | 24554.64 | Actual |
| Jun-18 | 24795.94 | Actual |
| Jul-18 | 24962.51 | Actual |
| Aug-18 | 25620.62 | Actual |
| Sep-18 | 26231.39 | Actual |
| Oct-18 | 25640.71 | Actual |
| Nov-18 | 25235.62 | Actual |
| Dec-18 | 23854.36 | Actual |
| Jan-19 | 24115.19 | Actual |
| Feb-19 | 25579.37 | Actual |
| Mar-19 | 25716.07 | Actual |
| Apr-19 | 26384.66 | Actual |
| May-19 | 25744.93 | Actual |
| Jun-19 | 26145.37 | Actual |
| Jul-19 | 27080.87 | Actual |
| Aug-19 | 26064.62 | Actual |
| Sep-19 | 26895.4 | Actual |
| Oct-19 | 26742.02 | Actual |
| Nov-19 | 27773.13 | Actual |
| Dec-19 | 28167.96 | Actual |
| Jan-20 | 28872.08 | Actual |
| Feb-20 | 28568.16 | Actual |
| Mar-20 | 22612.3 | Actual |
| Apr-20 | 23282.81 | Actual |
| May-20 | 24269.68 | Actual |
| Jun-20 | 26056.15 | Actual |
| Jul-20 | 26381.27 | Actual |
| Aug-20 | 27788.86 | Actual |
| Sep-20 | 27756.69 | Actual |
| Oct-20 | 28029.2 | Actual |
| Nov-20 | 29110.34 | Actual |
| Dec-20 | 30138.69 | Actual |
| Jan-21 | 30834.13 | Actual |
| Feb-21 | 31252.92 | Actual |
| Mar-21 | 32346.05 | Actual |
| Apr-21 | 33774.76 | Actual |
| May-21 | 34259.08 | Actual |
| Jun-21 | 34295.95 | Actual |
| Jul-21 | 34772.46 | Actual |
| Aug-21 | 35232.1 | Actual |
| Sep-21 | 34737.34 | Actual |
| Oct-21 | 35016.81 | Actual |
| Nov-21 | 35872.25 | Actual |
| Dec-21 | 35616.98 | Actual |
| Jan-22 | 35460.29 | Actual |
| Feb-22 | 34653.11 | Actual |
| Mar-22 | 34015.27 | Actual |
| Apr-22 | 35090 | Forecast |
| May-22 | 35610 | Forecast |
| Jun-22 | 35960 | Forecast |
| Jul-22 | 36300 | Forecast |
| Aug-22 | 35640 | Forecast |
| Sep-22 | 35150 | Forecast |
| Oct-22 | 35780 | Forecast |
| Nov-22 | 36300 | Forecast |
Step 3. Explanation part b
The graph drawn from the above data can be shown as:
Over 30 million students worldwide already upgrade their learning with Vaia!
