Data analytics is the process of examining data sets in order to draw conclusions about the information they contain. If you haven’t completed any of the prior data analytics cases, follow the instructions listed in the Chapter 1 Data Analytics case to get set up. You will need to watch the videos referred to in the Chapters 1 - 3 Data Analytics cases. No additional videos are required for this case. All short training videos can be found here: https://www.tableau.com/learn/training#getting-started. In the Data Analytics Cases in the previous chapter, you used Tableau to examine two (hypothetical) publicly traded companies: GPS Corporation and Tru, Inc. regarding the return on stockholders’ equity. This time, you investigate two aspects of the relative desirability of investing in stock of the two companies. 

Required: 

For each of the two companies in the most recent five-year period, 2017-2021, use Tableau to calculate and display the trends for (a) the dividend payout ratios [Dividends paid / Income from continuing operations] and (b) the price-earnings ratio [Market price per share / Diluted earnings per share]. The 2021 industry averages for the dividend payout and the price-earnings ratio are 20.2% and 27.9%, respectively. Based upon what you find, answer the following questions: 

1. Which of the two companies, GPS Corporation or Tru, Inc., pays investors the greater percentage of its earnings during the period 2017-2021? 

2. Is the dividend payout ratio for Tru, Inc. (a) increasing significantly, (b) decreasing significantly, or (c) remaining relatively the same during the period 2017-2021? 

3. Is the price-earnings ratio for GPS Corporation (a) increasing significantly, (b) decreasing significantly, or (c) remaining relatively the same during the period 2017-2021? 

4. Is the price-earnings ratio for Tru, Inc. (a) increasing significantly, (b) decreasing significantly, or (c) remaining relatively the same during the period 2017-2021?