Tableau Dashboard Activity 16-1 (Static)

Tableau Dashboard Activity 16-1 (Static) [The following information applies to the questions displayed below] This exercise provides a total of13 data visualizations that describe a real company's performance based on 17 quarters of financial data. The visualizations are grouped into ve dashboards that were created in Tableau: (1) sales analysis, (2) gross margin analysis, (3) operating expense analysis, (4) protability analysis, and (5) market performance analysis. Required: For each section, review the Tableau visualizations and answer the questions. Tableau Dashboard Activity 16-1 (Static) Part 5 Refer to the Market Performance Analysis below and answer the questions. Price-Earnings Ratio Price-Earnings Ratio Year/Quarter 600 528.0 400 316.3 314.2 Price-Earnings Ratio 238.4 174.5 187.7 198.8 198.9 200 168.1 177.6 131.3 109.3 72.7 72.6 Y3Q3-Y402 Y4Q1-Y4Q4 Y2Q3-Y3Q2 Y2Q2-Y3Q1 Y2Q4-Y3Q3 Y1Q1 - Y1.. Y2Q1-Y2Q4 Y3Q4-Y4Q3 Y4Q2-Y5Q1 Y1Q3-Y2Q2 Y3Q1-Y3Q4 Y1Q2-Y2Q1 Y3Q2-Y4Q1 Y1Q4-Y2Q3 The first bar in this chart is computed by dividing the stock price at the end of year 1 by the sum of that year's quarterly earnings per share. Each subsequent bar in the chart rolls forward one quarter at a time. So, for example, the second bar divides the stock price at the end of the first quarter of year 2 by the sum of the earnings per share from the four most recent quarters. Earnings Per Share (EPS) vs. Stock Price Year/QuarterEarnings Per Share Stock price $2,000 $1,000 $6.00 $4.00 $2.00 $0.00 $0 tableau Y1 - Q1 Y1 - Q2 Y1 - Q3 Y1 - Q4 Y2 - Q1 Y2 - Q2 boxes left with a question mark will be automatically graded as incorrect.) Y2 - Q3 Y2 - Q4 Year/Quarter Y3 - Q1 Y3 - Q2 Y3 - Q3 a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any Y3 - Q4 (Note that for all questions below you may select more than one answer. Single click the box with the question mark to produce Y4 - Q1 Y4- Q2 Y4 - Q3 Y4 - Q4 Y5 - Q15 3-1. Which of the following statements are true with respect to Visualization 1: Price-Earnings Ratio? 9 The chart depicts the company's stock price relative to its net prot margin percentage. 8 Each bar in the chart is calculated using that quarter's stock price divided by the cumulative earnings per share for the most recently completed four quarters. a The chart provides a trend analysis of the company's priceearnings ratio from the end of year 1 through the rst quarter of year 5. 5 3-2. Which of the following statements are true with respect to Visualization 2: Earnings Per Share (EPS) vs. Stock Price? a The bottomhalf of the visualization provides a trend analysis of the company's earnings per share beginning with the rst quarter of year1 and running consecutively through the rst quarter of year 5. a The top and bottom halves of the visualization provide a yearoveryear depiction of stock price and earnings per share beginning with the rst quarter of years 15 and ending with the fourth quarter of years 14. a The tophalf of the visualization provides a trend analysis of the company's stock price beginning with the rst quarter of year 1 and running consecutively through the rst quarter of year 5. 5 b-1. Which ofthe following statements are true with respect to Visualization 1: Price-Earnings Ratio? 9 The priceearnings ratiojumped by more than 100 at one point during years 2 and 3. a The price-earnings ratio has declined from 528.0 in the rst quarter of year 1 to 72.6 by the first quarter of year 5. a The last eight blue bars indicate a steady decline in the priceearnings ratio. 5 b-2. Which ofthe following statements are true with respect to Visualization 2: Earnings Per Share (EPS) vs. Stock Price? a The company's stock price has increased over the 17month period whereas its earnings per share has decreased. 9 The company's earnings per share experienced its biggest quarterly increase from the third quarter to the fourth quarter of year 3. a The company's earnings per share experienced its biggest decrease from the second quarter to the third quarter of year 3. 5c. Which of the following statements are true with respect to the two visualizations contained in the Market Performance Analysis Dashboard? a The stock price was higher at the end of the third quarter of year 3 compared to the same quarter in the prior year; however, the earnings per share wasthe same in the third quarter ofyears 2 and 3. a The second visualization suggests that the company's plummeting earnings per share in years 4 and 5 is largely responsible for the drop in the price-earnings ratio depicted in the first visualization. 5c. Which of the following statements are true with respect to the two visualizations contained in the Market Performance Analysis Dashboard? a The stock price was higher at the end of the third quarter of year 3 compared to the same quarter in the prior year; however, the earnings per share wasthe same in the third quarter ofyears 2 and 3. a The second visualization suggests that the company's plummeting earnings per share in years 4 and 5 is largely responsible for the drop in the priceearnings ratio depicted in the first visualization. a The second visualization separately depicts the numerator and denominator that comprise the measure depicted in the first visualization