The following Tableau dashboard is an analysis of the Dow Jones Industrial Average (DOW) from its inception to 2015. The Dow is an index fund consisting of 30 large public companies listed on stock exchanges within the United States (US). These 30 companies are considered some of the most established American companies and often serve as a benchmark for the overall health of the economy. This dashboard contains two visualizations; the first is a chart showing the market capitalization (market cap) of each company over time. A companys market cap represents the overall value of the companys stock and is commonly used to make size comparison between companies (i.e., larger market caps indicate larger-sized companies). Hovering over the lines in this chart will display a text box showing the industry and a short description of each company listed. A filter to the right of this chart will allow you to select which years you want the chart to display, with all years being selected as the default option. The second visualization is a candlestick chart exhibiting stock price information for each of the 30 companies. The candlestick chart shows the open, close, high, and low prices of the stock for each selected company over a particular time period. The open price represents the price of the stock when the market opened for the trading day, and the close price represents the price of the stock when the market closed on a particular trading day. The high and low amounts represent the highest price the stock reached during the trading day and lowest price the stock reached during the trading day. The filters to the right of this visualization can be used to select individual companies and dates for which you desire stock price information. The gray area within the visualization represents the high and low price points reached during a trading day, and the green or red bars represent whether the stock increased or decreased in value during the day based on its open and close prices. Green bars represent an increase in value, while red bars indicate a decrease in the value of the stock on a particular trading day. Use the information from the Tableau dashboard to answer the following questions.

REQ 1

Based on the market capitalization chart, have companies increased or decreased in size over the life of the DOW Jones stock market index?

-Increased

-Decreased

REQ 2

Which of the following statements is true about the data shown in the market capitalization chart? (Hint: You will need to use the Year filter to select specific time periods to answer this question.)

-On average, the size of companies listed in the Dow from 1929 to 1933 increased in size.

-Between 2008 and 2010, the Dow experienced a large increase in value as a result of booming economic conditions.

-The Dow experienced a large increase in value in the late 90s as a result of the technology boom.

-None of these choices are true.

REQ 3

Use the Company filter to the right of the candlestick chart to select McDonalds from the dropdown list. Now use the Year filter to select 2010 from the dropdown list to show stock prices for the entire year. Lastly, to drill down even further, use the Month filter to select April. Over the time period shown, has McDonalds stock price increased or decreased over time?

-Increased

-Decreased

REQ 4

With the Company filter still selected on McDonalds and the Year filter still set to 2010, change the Month filter to select June. Having drilled down this far, you can see the individual prices for each day in the month of June. What is the close price of the stock on June 22, 2010? (Hint: Hover over the candlestick bars to see detailed stock price information on a particular day.)

-$70.01

-$70.37

-$68.55

-$68.64

REQ 5

Using the filter techniques you applied in question 4, did the stock price for Coca-Cola increase or decrease in value on the trading day of November 18, 2014?

-Increase

-Decrease

Companies on the DOW Jones (Market Cap) Year All 5B Company AIG 4B 3B Average daily market capitalization ($K) 2B Alcoa American Can American Express American Smelting American Sugar American Tobacco Anaconda Copper AT&T AT&T(SBC) Atlantic Refining Bank of America Bethlehem Steel Boeing Barden 1B OB 1934 1944 1954 1964 1974 1984 1994 2004 2014 Candle Stick Chart: All 400 800 Company All 300 600 Year All Stock Prices 400 Avg. Open 200 Month All 200 100 0 96/82/9 2/28/97 26/S/TT 86/ET/2 3/20/99 11/25/99 00/1/8 TO/8/ TO/V1/ZT 20/12/8 4/28/03 1/3/04 10/6/6 SO/T/S 90/22/1 90/62/6 20/9/9 80/11/2 80/8T/OT 60/S2/9 OT/2/ OT/L/TT 7/15/11 3/21/12 11/26/12 //8 4/10/14 01/91/21 8/23/15 91/62/