| Company | Year | Rating | Price |
| 3M (MMM) | 1976 | ** | 192.36 |
| American Express (AXP) | 1982 | *** | 79.25 |
| Apple (AAPL) | 2015 | *** | 139.99 |
| Boeing (BA) | 1987 | *** | 180.10 |
| Caterpillar (CAT) | 1991 | ** | 92.91 |
| Chevron Corp. (CVX) | 2008 | ** | 107.68 |
| Cisco Systems (CSCO) | 2009 | ** | 34.23 |
| Coca-Cola (KO) | 1987 | **** | 42.03 |
| Disney (DIS) | 1991 | **** | 111.76 |
| DuPont (DD) | 1935 | ** | 81.25 |
| ExxonMobil (XOM) | 1928 | *** | 82.00 |
| General Electric (GE) | 1907 | *** | 29.28 |
| Goldman Sachs (GS) | 2013 | ** | 243.94 |
| Home Depot (HD) | 1999 | ** | 149.60 |
| Intel (INTC) | 1999 | ** | 35.27 |
| IBM (IBM) | 1979 | *** | 175.65 |
| Johnson & Johnson (JNJ) | 1997 | ** | 128.06 |
| JPMorgan Chase (JPM) | 1991 | ** | 90.68 |
| McDonald's (MCD) | 1985 | *** | 128.64 |
| Merck (MRK) | 1979 | *** | 63.90 |
| Microsoft (MSFT) | 1999 | *** | 64.87 |
| Nike (NKE) | 2013 | *** | 57.80 |
| Pfizer (PFE) | 2004 | **** | 34.32 |
| Proctor & Gamble (PG) | 1932 | *** | 91.00 |
| Travelers (TRV) | 2009 | *** | 123.14 |
| United Technologies (UTX) | 1939 | *** | 113.45 |
| UnitedHealth (UNH) | 2012 | ** | 169.70 |
| Verizon Comm. (VZ) | 2004 | *** | 50.39 |
| Visa (V) | 2013 | **** | 90.24 |
| Wal-Mart (WMT) | 1991 | **** | 69.89 |
1 1. Use \"DOW_Characteristics\" data in Chapter1.xlsx to answerthe following questions. For questions that require Excel, includethe appropriate output (copy + paste) along with an explanation.Data description: The accompanying table shows a portion of the 30companies that comprise the Dow Jones Industrial Average (DJIA).The second column shows the year that the company joined the DJIA(Year). The third column shows each company’s Morningstar rating(Rating). (Five stars is the best rating that a company canreceive, indicating that the company’s stock price is undervaluedand thus a very good buy. One star is the worst rating a companycan be given, implying that the stock price is overvalued and a badbuy.) Finally, the fourth column shows each company’s stock priceas of March 17, 2017 (Price in $).
Questions: a. Are data in the table from a sample or from apopulation? Explain.
b. Are data in the table time series data or not? Explain
c. What is the measurement scale of the Year data? What are thestrengths of this type of data? What are the weaknesses?
d. What is the measurement scale of Morningstar’s star-basedrating system? Summarize Morningstar’s star-based rating system forthe companies in tabular form. Let 5 denote *****, 4 denote ****,and so on. What information can be extracted from these data?
e. What is the measurement scale of the Stock Price data? Whatare its strengths?
f. List the qualitative and quantitative variables in the datatable.
