Complete this question by entering your answers in the tabs below. 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.) the information from the Tableau dashboard to answer the following questions. Complete this question by entering your answers in the tabs below. 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 ? CandleStick Chart: All Complete this question by entering your answers in the tabs below. Based on the market capitalization chart, have companies increased or decreased in size over the life of the Dow jones stock matketindex? Increased Complete this question by entering your answers in the tabs below. With the "Company" filter still selected on "MCDonald's" 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.) Average dally market capitalteation ( 5K ) Complete this question by entering your answers in the tabs below. Use the "Company" filter to the right of the candlestick chart to select Mcoonald's" from the dropdown list. Wow use the prear" filter to solect 2010 from the dropdown list to thow stock prices for the entire year. Lasty. to dond down even farthec time? ncreased Decreased The foliowing 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 sorne 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 company's market cap represents the overall value of the company's stock and is commonly used to make size comparison between companies (f.e, larger market caps indicate larger-sized companies). Hovering over the lines in this chart will clisplay a text box showing the incustry 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 dose price represents the price of the stock When the inarket 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 individuat companies and dates for which you desire stock price information. The gray area within the visualization fepresents 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. Gleen 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. Companies on the DOW Jones (Market Cap) 1. Based on the market capitalization chart, have companies increased or decreased in size over the life of the DOW Jones stock market index? 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" fiter to select specific time periods to answer this question.) 3. Use the "Company" filter to the right of the candlestick chart to select "McDonald's" from the dropdown list. Now use the "Year" filter fiter to select "April." Over the time period shown, has McDonald's stock price increased or decreased over time? 4. With the "Company" filter still selected on "McDonald "s" 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 detalled stock price information on a particular day) 5. Using the fitter 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 ? Complete this question by entering your answers in the tabs below. Based on the market capitalization chart, have companies increased or decreased in aize ovec the life of the Dow Jones stock market index? Complete this question by entering your answers in the tabs below. 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.) the information from the Tableau dashboard to answer the following questions. Complete this question by entering your answers in the tabs below. 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 ? CandleStick Chart: All Complete this question by entering your answers in the tabs below. Based on the market capitalization chart, have companies increased or decreased in size over the life of the Dow jones stock matketindex? Increased Complete this question by entering your answers in the tabs below. With the "Company" filter still selected on "MCDonald's" 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.) Average dally market capitalteation ( 5K ) Complete this question by entering your answers in the tabs below. Use the "Company" filter to the right of the candlestick chart to select Mcoonald's" from the dropdown list. Wow use the prear" filter to solect 2010 from the dropdown list to thow stock prices for the entire year. Lasty. to dond down even farthec time? ncreased Decreased The foliowing 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 sorne 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 company's market cap represents the overall value of the company's stock and is commonly used to make size comparison between companies (f.e, larger market caps indicate larger-sized companies). Hovering over the lines in this chart will clisplay a text box showing the incustry 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 dose price represents the price of the stock When the inarket 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 individuat companies and dates for which you desire stock price information. The gray area within the visualization fepresents 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. Gleen 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. Companies on the DOW Jones (Market Cap) 1. Based on the market capitalization chart, have companies increased or decreased in size over the life of the DOW Jones stock market index? 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" fiter to select specific time periods to answer this question.) 3. Use the "Company" filter to the right of the candlestick chart to select "McDonald's" from the dropdown list. Now use the "Year" filter fiter to select "April." Over the time period shown, has McDonald's stock price increased or decreased over time? 4. With the "Company" filter still selected on "McDonald "s" 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 detalled stock price information on a particular day) 5. Using the fitter 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 ? Complete this question by entering your answers in the tabs below. Based on the market capitalization chart, have companies increased or decreased in aize ovec the life of the Dow Jones stock market index