Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Cleaning and Inspecting data: The le Stocks.csv contains data on the closing stock price on a single day for a large number of companies. For
Cleaning and Inspecting data: The le Stocks.csv contains data on the closing stock price on a single day for a large number of companies. For each company, the dataset provides the name (Name), stock market ticker symbol (Symbol), sector (Sector), stock price (Price), dividend as a percent- age of stock price (Dividend), price-to-earnings ratio (PE), earnings per share (EPS), book value in billions of dollars (Book Value), lowest and highest share price over the last 52 weeks (52 week low and 52 week high), market value of the company's shares in billions of dollars (Market Cap), and earnings before interest, taxes, depreciation, and amortization in billions of dollars (EBITDA). 1. Data Cleaning: (a) (2pts) How many companies are included in the Stockscsv dataset? (b) (4pts) How many missing values are there for each variable? How many in- complete observations are there? (c) (Spts) Clean up the missing data by either removing all incomplete observations or by imputing values for the missing data. Which option did you choose? Why? ((1) (2pts) Add a column to this dataset obtained by taking the log base 10 of the book value. (e) (2pts) Add a column to this dataset obtained by taking the log base 10 of the market cap. (t) (2pts) Add a column to this dataset obtained by taking the log base 10 of the EBITDA. (g) (4pts) Create a variable that is 1 if the company has a price-to-earnings ratio greater than 15 and is 0 otherwise. Add this variable as a column in the dataset. (Hint: The ifelse 0 function can do this fairly easily. Try looking at the help le to see how to do this.) (h) (3pts) Replace the 3rd entry of the Name variable with your full name. (i) (3pts) Save this cleaned dataset as a .csv le. 2. Data Inspection: For this section, use the cleaned dataset from Part 1. (a) (4pts) How many different sectors are included in the dataset and how many companies of each sector of the dataset are there? (b) (8pts) For each sector, give the mean and standard deviation of the stock price for companies within that sector. (Hint: It may be easiest formatting-wise and effort-wise to create a table and combine your answers to part a) and b) by inputting them into this table) (c) (lpt) Compute the correlation between the book value and the market value across all companies. ((1) (2pts) Give the ve companies with the largest dividends. (e) (2pts) Give the ve companies with the smallest earnings per share. (f) (3pts) How many companies have a book value greater than their market value? (g) (6pts) Make histograms of price, 52 week low, and 52 week high. Describe the shape of each of these histograms. (h) (4pts) Make a scatterplot where book value is on the z-axis and market cap is on the y-axis. Describe the shape of this plot. Does the shape of this plot match your answer to that in part c) of this question? (i) (5pts) Make side-by-side boxplots comparing the distribution of stock prices of companies with a price-to-earnings ratio greater than 15 to that of companies with a price-to-earnings ratio less than or equal to 15. (Hint: It may be useful to use the variable created in Problem 1, Part g) to do make this graph) Name Symbol Sector Price Dividend PE EPS Book Value 52 week low 52 week high Market Cap EBITDA 3M Company MMM Industrials 189.09 2.48 23.17 8.16 17.26 158.28 190.54 112.74 8.7 Abbott Laboratories ABT Health Care 45 2.34 48.03 0.94 13.94 36.76 45.83 77.76 4.59 Accenture plc ACN Information Technology 124.14 1.96 18.37 6.76 11.95 102.1 125.72 77.29 5.66 Activision Blizzard ATVI Information Technology 48.06 0.64 37.55 1.28 12.23 30.37 48.36 36.13 2.14 Acuity Brands Inc AYI Industrials 205.41 0.25 29.68 6.92 39.5 193.06 280.89 9 0.5862 Advance Auto Parts AAP Consumer Discretionary 151.99 0.15 24.51 6.2 39.66 132.98 177.83 11.18 1.12 Aetna Inc AET Health Care 130.59 1.53 20.37 6.41 50.84 104.59 136.5 45.93 6.2 Affiliated Managers Group Inc AMG Financials 166.56 0.47 19.44 8.57 63.84 130.48 179.85 9.44 0.835 AFLAC Inc AFL Financials 71.95 2.38 11.21 6.42 50.47 59.66 74.5 28.88 4.78 Agilent Technologies Inc A Health Care 51.21 1.02 32.85 1.56 13.35 37.62 52.26 16.49 0.942 Air Products & Chemicals Inc APD Materials 139.64 2.72 53.77 2.6 32.91 123.05 150.45 30.38 3.13 Alaska Air Group Inc ALK Industrials 95.12 1.21 14.54 6.54 23.77 54.51 101.43 11.74 1.82 Albemarle Corp ALB Materials 103.79 1.22 18.26 5.68 33.73 58.6 105.2 11.68 0.702 Allegion ALLE Industrials 72.86 0.87 30.87 2.36 1.19 61.47 75 6.96 0.4789 Allergan, Plc AGN Health Care 239.6 1.14 6.28 38.18 212.79 184.5 299.11 80.32 6.1 Alliance Data Systems ADS Information Technology 245.05 0.85 33.39 7.34 28.89 185.02 249.22 13.7 1.46 Alliant Energy Corp LNT Utilities 39.28 3.22 24.01 1.64 16.96 34.04 40.99 8.94 1.03 Allstate Corp ALL Financials 81.46 1.66 17.44 4.67 51.44 63.73 83.05 29.74 3.46 Altria Group Inc MO Consumer Staples NA 3.23 10.45 7.28 6.58 59.48 76.3 147.64 9.5 Ameren Corp AEE Utilities 54.82 3.21 20.46 2.68 29.28 46.29 55.51 13.3 2.3 American Airlines Group AAL Industrials 44.84 0.85 9.32 4.81 7.46 24.85 50.64 22.61 7.83 American Electric Power AEP Utilities 66.24 3.55 53.29 1.24 35.38 57.89 71.32 32.57 5.29 American Express Co AXP Financials 79.58 1.6 14.08 5.65 22.68 57.15 82 71.72 0 American Tower Corp A AMT Real Estate 114.7 2.01 57.93 1.98 15.84 93.69 118.26 49 3.46 American Water Works Company Inc AWK Utilities 76.89 1.94 29.35 NA 29.3 NA 85.24 13.7 1.62 Ameriprise Financial AMP Financials 132.18 2.25 16.92 7.81 40.66 84.92 135.2 20.36 2.77 AmerisourceBergen Corp ABC Health Care 88.48 1.58 14.78 5.99 9.75 68.38 94.5 19.22 2.16 AMETEK Inc AME Industrials 54.51 0.66 24.89 2.19 14.2 43.28 55.48 12.51 1.01 Amgen Inc AMGN Health Care 177.38 2.55 17.32 10.24 40.47 133.64 180.53 130.63 12 Amphenol Corp APH Information Technology 70.27 0.91 26.92 2.61 11.92 54.87 71 21.62 1.46 Analog Devices, Inc. ADI Information Technology 83.41 2.16 28.45 2.93 17.16 52.17 84.24 25.79 1.37 Anthem Inc. ANTM Health Care 166.01 1.57 18.02 9.21 95.17 114.85 169.2 43.89 5.78 Aon plc AON Financials 115.54 1.13 22.39 5.16 20.9 97.62 117.89 30.34 2.39 Apple Inc. AAPL Information Technology 139.52 1.63 16.75 8.33 25.19 89.47 140.28 732 69.75 Applied Materials Inc AMAT Information Technology 36.97 1.08 19.02 1.94 7.12 18.94 37.26 39.92 2.99 Archer-Daniels-Midland Co ADM Consumer Staples 44.46 2.83 NA 2.16 29.97 34.55 47.88 25.39 2.54 Arthur J. Gallagher & Co. AJG Financials 56.32 2.74 24.28 2.32 20.17 40.76 57.82 10.06 0.8688 Assurant Inc AIZ Financials 99.6 2.12 10.91 9.13 73.26 75.2 101.32 5.54 1.04AT& TInc T Telecommunication Services 41.88 4.67 19.95 2.1 20.06 36.1 43.89 257.21 49.74 Automatic Data Processing ADP Information Technology 104.27 2.18 28.01 3.72 8.5 84.36 105 46.81 2.73 AvalonBay Communities, Inc. AVB Real Estate 183.05 3.14 24.34 7.52 74.07 158.32 192.29 25.14 1.32 Avery Dennison Corp AVY Materials 80.4 2.01 22.71 3.54 10.48 68.06 82.11 7.09 0.7403 Ball Corp BLL Materials 72.28 0.7 52 1.39 20.04 66.41 82.24 12.63 1.28 Bank of America Corp BAC Financials 25.21 1.18 16.84 1.5 24.04 12.05 NA 265.12 0 Baxter International Inc. BAX Health Care 51.04 1.02 5.67 9.01 15.36 38.99 51.4 27.57 1.97 BB&T Corporation BBT Financials 47.93 2.47 17.3 2.77 33.14 32.22 49.88 38.75 0 Becton Dickinson BDX Health Care 183.94 1.58 30.62 6.01 35.63 145.78 186.11 39.15 3.26 Best Buy Co. Inc. BBY Consumer Discretionary 44.55 2.64 11.71 3.81 15.03 28.76 49.4 13.96 2.6 BlackRock BLK Financials 385.35 2.56 20.24 19.04 178.38 317.6 399.46 62.86 4.88 Boeing Company BA Industrials 182.02 3.12 23.92 7.61 1.32 121.43 185.71 111.48 8.68 BorgWarner BWA Consumer Discretionary 41.69 1.3 75.8 0.55 15.16 27.52 43.43 8.87 0.8076 Boston Properties BXP Real Estate 135.66 2.21 41.61 3.26 36.32 113.69 144.02 20.87 1.53 Bristol-Myers Squibb BMY Health Care 56.33 2.72 21.26 2.65 9.68 46.01 77.12 94.22 5.7 C. H. Robinson Worldwide CHRW Industrials 78.94 2.26 21.99 3.59 8.9 65.57 81.16 11.15 0.9008 CA, Inc. CA Information Technology 31.97 3.14 16.95 1.89 13.49 29.12 34.99 13.36 1.28 Campbell Soup CPB Consumer Staples 59.09 2.35 36.82 1.61 4.83 52.58 67.89 18.08 1.57 Capital One Financial COF Financials 92.82 1.7 13.47 6.89 98.96 58.03 96.92 44.57 0 Cardinal Health Inc. CAH Health Care 81.21 2.17 19.55 4.15 17.91 62.7 87.85 25.62 3.07 Carnival Corp CCL Consumer Discretionary 55.53 2.51 14.93 3.72 31.12 42.94 57.79 40.31 4.76 CBOE Holdings CBOE Financials 77.97 1.28 34.35 2.27 3.91 61.22 81.36 6.34 0.3573 CBS Corp. CBS Consumer Discretionary 67.94 1.06 24.18 2.81 8.95 48.88 68.59 27.82 3.1 CenterPoint Energy CNP Utilities 28 3.84 28 8.03 19.83 28.08 12.06 2.09 CenturyLink Inc CTL Telecommunication Services 22.5 9.2 19.4 1.16 24.52 22.37 33.45 12.3 5.49 Charles Schwab Corporation SCHW Financials 41.66 0.75 31.8 1.31 10.23 23.83 43.36 55.61 Chubb Limited CB Financials 137.41 1.99 15.49 8.87 103.6 115.5 140.55 64 5.69 Church & Dwight CHD Consumer Staples 49.55 1.45 28.31 1.75 7.79 42.56 53.68 12.62 0.8367 CIGNA Corp. CI Health Care 151.84 0.03 21.12 7.19 53.42 115.03 154.24 39.03 3.85 Cincinnati Financial CINF Financials 73.17 2.7 20.61 3.55 42.95 63.57 79.6 12.05 0.913 Cintas Corporation CTAS Industrials 118.27 0.89 24.65 4.8 19.29 85.86 122.21 12.42 0.9833 Cisco Systems CSCO Information Technology 34.2 3.38 17.63 1.94 12.74 25.81 34.53 171.27 14.67 Citigroup Inc. C Financials 60.5 1.05 12.82 4.72 74.26 38.31 61.94 167.63 0 Citizens Financial Group CFG Financials 37.97 1.46 19.27 1.97 38.09 18.34 39.75 19.33 0 CME Group Inc. CME Financials 123.56 2.13 27.28 4.53 60.14 89 127.6 41.97 2.45 CMS Energy CMS Utilities 44.44 22.44 1.98 15.23 38.78 46.25 12.42 Comcast Corp. CMCSA Consumer Discretionary 37.42 1.69 20.96 1.78 11.38 29.03 38.44 177.45 26.48 Comerica Inc. CMA Financials 72.63 1.25 27.1 2.68 44.47 35.58 75 12.77 Consolidated Edison ED Utilities 76.64 3.6 18.6 4.12 46.88 68.76 81.88 23.38 3.69Constellation Brands STZ Consumer Staples 157.21 1.01 24.33 6.46 35.26 139.11 173.55 30.82 2.4 Corning Inc. GLW Information Technology 27.72 2.22 8.58 3.23 16.84 18.21 28.36 25.73 2.56 Crown Castle International Corp. CCI Real Estate 91.5 4.14 96.32 0.95 20.96 79.38 102.82 32.99 2.07 CSRA Inc. CSRA Information Technology 28.5 1.34 24.05 1.18 1.87 21.95 33.54 4.65 0.7456 CSX Corp. CSX Industrials 48.44 1.46 26.78 1.81 12.58 24.36 50.31 44.88 4.69 Cummins Inc. CMI Industrials 152.1 2.7 18.48 8.23 41.04 100.43 154.67 25.48 2.31 CVS Health CVS Consumer Staples 80.81 2.47 16.46 4.91 34.71 69.3 106.67 85.74 13.05 D. R. Horton DHI Consumer Discretionary 32.85 1.23 13.2 2.49 18.7 26.69 34.56 12.27 1.52 Danaher Corp. DHR Health Care 86.07 0.64 23.57 3.65 33.23 75.71 102.79 59.67 4.12 Darden Restaurants DRI Consumer Discretionary 74.51 2.98 21.82 3.41 14.93 59.5 79.43 9.25 0.9302 Deere & Co. DE Industrials 110.24 2.17 23.88 4.62 21.44 74.91 112.18 35.09 3.89 Dentsply Sirona XRAY Health Care 62.55 0.55 32.24 1.94 35.26 55 65.83 14.37 0.7795 Discover Financial Services DFS Financials 70.98 1.68 12.3 5.77 27.68 47.5 74.33 27.37 0 Dollar General DG Consumer Discretionary 71.36 1.37 16.74 4.26 19.41 66.5 96.88 19.71 2.37 Dover Corp. DOV Industrials 79.39 2.19 24.43 3.25 24.45 58.91 82.56 12.35 1.12 Dr Pepper Snapple Group DPS Consumer Staples 94.23 2.44 20.76 4.54 11.65 81.05 98.8 17.25 1.65 DTE Energy Co. DTE Utilities 101.55 3.26 21.02 4.83 50.22 84.77 102.1 18.22 2.24 Duke Energy DUK Utilities 81.69 4.18 26.18 3.12 58.62 72.34 87.75 57.15 10.03 E*Trade ETFC Financials 35.07 0 17.71 1.98 21.41 21.52 38.61 9.63 0 Eastman Chemical EMN Materials 78.92 2.54 13.73 5.75 30.94 62.7 82.1 11.56 2.11 Eaton Corporation ETN Industrials 71.54 3.34 16.99 4.21 33.15 54.3 73.86 32.17 3.19 Ecolab Inc. ECL Materials 124.72 1.18 30.13 4.14 23.65 102.38 126.17 36.38 2.87 Edison Int'l EIX Utilities 79.25 2.73 19.93 3.98 36.82 67.44 80.61 25.82 3.96 Emerson Electric Company EMR Industrials 60.22 3.18 24.43 2.46 12 48.45 64.36 38.85 3.11 Equifax Inc. EFX Industrials 131.37 1.17 32.52 4.04 22.21 105.52 136.97 15.75 1.12 Equinix EQIX Real Estate 375.24 1.93 209.05 1.79 61.14 299.29 391.07 26.88 1.5 Equity Residential EQR Real Estate 62.55 3.23 5.36 11.68 27.86 58.28 75.49 22.96 1.57 Essex Property Trust, Inc. ESS Real Estate 233.7 3.04 37.27 6.27 94.5 200.01 237.5 15.32 0.8982 Estee Lauder Cos. EL Consumer Staples 82.77 1.64 28.6 2.89 10.36 75.29 97.48 30.33 2.2 Eversource Energy ES Utilities 58.56 3.26 19.78 2.96 33.8 50.56 60.44 18.56 2.55 Exelon Corp EXC Utilities 36.13 3.61 29.61 1.22 27.96 29.82 37.7 33.48 9.13 Expedia Inc. EXPE Consumer Discretionary 122.39 0.93 67.25 1.82 27.54 96.58 133.55 18.34 1.07 Express Scripts ESRX Health Care 67.39 12.5 5.39 26.81 64.46 80.02 40.82 7.1 Extra Space Storage EXR Real Estate 78.99 3.95 27.17 2.91 17.88 68.09 94.81 9.92 0.6493 Exxon Mobil Corp XOM Energy 82.52 3.64 43.96 1.88 40.34 80.76 95.55 342.17 23.24 Fastenal Co FAST Industrials 51.37 2.47 29.71 1.73 6.68 37.7 52.64 14.86 0.8994 Federal Realty Investment Trust FRT Real Estate 133.39 2.9 38.11 3.5 27.32 132.91 171.08 9.62 0.5128 FedEx Corporation FDX Industrials 192.91 0.82 28.35 6.8 54.52 139.58 201.57 51.41 7.86 Fidelity National Information Services FIS Information Technology 82.64 1.4 47.96 1.72 29.7 59.11 83.86 27.17 2.27Fifth Third Bancorp FITB Financials 27.37 2.01 14.18 1.93 19.82 16.02 28.97 20.55 0 FLIR Systems FLIR Information Technology 36.5 1.65 30.42 1.2 12.31 28.26 37.44 4.98 0.3547 Flowserve Corporation FLS Industrials 46 1.63 41.44 1.11 12.7 39.13 52.5 6 0.4779 Fluor Corp. FLR Industrials 55.08 1.51 27.54 2 22.44 44.05 58.37 7.68 0.8882 FMC Corporation FMC Materials 59.09 1.11 37.95 1.56 14.64 36.72 62.84 7.9 0.7144 Foot Locker Inc FL Consumer Discretionary 75.72 1.62 15.42 4.91 20.33 50.9 79.43 10.09 1.16 Ford Motor F Consumer Discretionary 12.46 4.74 10.83 1.15 7.34 11.07 14.22 49.52 13.3 Fortive Corp FTV Industrials 58.2 0.48 23.19 2.51 7.77 43 59.24 20.13 1.44 Fortune Brands Home & Security FBHS Industrials 57.92 1.23 22.15 2.62 15.39 50.39 64.47 8.87 0.7747 Franklin Resources BEN Financials 42.38 1.87 14.28 2.97 21.15 30.56 44.1 23.96 2.32 Garmin Ltd. GRMN Consumer Discretionary 51.51 3.96 19.08 2.7 18.13 38.4 56.19 9.71 0.7103 General Dynamics GD Industrials 191.47 1.77 20.1 9.52 36.43 127.74 193.17 57.69 4.76 General Electric GE Industrials 29.86 3.19 33.44 0.89 8.67 28.19 33 260.52 17.14 General Growth Properties Inc. GGP Real Estate 23.92 3.61 17.85 1.34 9.5 23.7 32.1 21.14 1.86 General Mills GIS Consumer Staples 60.25 3.16 22.5 2.68 7.2 58.7 72.95 34.95 3.38 General Motors GM Consumer Discretionary 37.52 3.98 6.25 29.22 27.34 38.55 56.2 19.68 Genuine Parts GPC Consumer Discretionary 93.52 2.85 20.37 4.59 21.52 86.61 105.97 13.88 1.22 Gilead Sciences GILD Health Care 69.02 2.94 6.94 9.94 14.42 65.38 103.1 90.21 19.22 Goldman Sachs Group GS Financials 250.9 1.03 15.4 16.29 182.46 138.2 255.15 104.08 0 Goodyear Tire & Rubber GT Consumer Discretionary 35.27 0.95 7.44 4.74 17.91 NA 36.61 8.88 2.51 Grainger (W.W.) Inc. GWW Industrials 250.59 1.95 25.39 9.87 30.58 201.94 262.71 14.74 1.46 Hanesbrands Inc HB Consumer Discretionary 19.98 2.92 14.21 1.41 3.23 18.91 30.42 7.57 1.01 Harley-Davidson HOG Consumer Discretionary 57.78 2.48 15.09 3.83 11 41.63 62.35 10.09 1.28 Harris Corporation HRS Information Technology 109.73 1.92 20.77 5.28 25.4 73.32 111.67 13.66 1.58 Hartford Financial Svc. Gp. HIG Financials 48.66 1.87 21.44 2.27 45.2 38.92 50.13 18.01 1.48 Hasbro Inc. HAS Consumer Discretionary 97.2 2.33 22.4 4.34 14.96 76.14 99.33 12.08 0.9754 HCP Inc. HCP Real Estate 31.3 4.6 23.38 1.34 11.85 27.61 40.43 14.65 1.28 Hewlett Packard Enterprise HPE Information Technology 22.82 1.04 12.38 1.84 18.94 15.3 24.88 37.95 7.8 Home Depot HD Consumer Discretionary 146.02 2.41 22.64 6.45 3.59 119.2 148.26 176.1 15.4 Honeywell Int'l Inc. HON Industrials 126.26 2.11 20.36 6.2 25.46 105.25 127.41 96.11 7.71 Hormel Foods Corp HRL Consumer Staples 34.85 1.92 21.12 1.65 8.66 33.18 44.73 18.42 1.41 Host Hotels & Resorts HST Real Estate 18.18 4.35 17.82 1.02 9.48 14.3 20.21 13.44 1.42 Humana Inc. HUM Health Care 217.95 0.75 53.55 4.07 71.57 150 218.93 32.55 2.06 Huntington Bancshares HBAN Financials 14.24 2.22 20.34 0.7 8.51 8.05 14.74 15.46 0 Illinois Tool Works ITW Industrials 133.9 1.94 23.49 5.7 12.26 96.13 135.24 46.4 3.53 Ingersoll-Rand PLC IR Industrials 79.59 2 14.1 5.65 25.65 56.73 82.17 20.65 1.92 Intel Corp. INTC Information Technology 35.8 2.9 16.89 2.12 14 29.5 38.45 169.26 22.87 Intercontinental Exchange ICE Financials 58.63 NA 24.74 2.37 26.42 45.44 60.54 6.75 2.75 International Business Machines IBM Information Technology 180.38 3.11 14.57 12.38 19.29 138.09 182.79 170.14 18.55Pfizer Inc. PFE Health Care 33.99 3.71 28.98 1.17 9.81 28.74 37.39 202.3 19.81 PG&E Corp. PCG Utilities 66.26 2.97 23.83 2.78 35.39 56.39 66.93 33.65 5.16 Phillips 66 PSX Energy 77.48 3.22 26.5 2.92 43.16 73.67 90.87 40.12 2.24 Pinnacle West Capital PNW Utilities 82.54 3.16 20.9 3.95 43.15 69.8 83.77 9.19 1.42 PNC Financial Services PNC Financials 127.4 1.72 17.45 7.3 94.22 77.4 131.83 61.94 0 Polo Ralph Lauren Corp. RL Consumer Discretionary 79.14 2.51 45.25 1.75 43.92 75.62 114 6.51 1.01 PPG Industries PPG Materials 100.78 1.57 30.72 3.28 18.75 89.64 117 25.91 2.56 PPL Corp. PPL Utilities 36.79 4.31 13.19 2.79 14.56 32.08 39.92 25.04 4.05 Praxair Inc. PX Materials 118.79 2.68 22.8 5.21 17.62 105.92 125 33.86 3.44 Principal Financial Group PFG Financials 63.04 2.83 14.01 4.5 35.55 37.69 64.31 18.12 1.95 Procter & Gamble PG Consumer Staples 90.29 2.96 16.54 5.46 20.35 79.1 91.89 230.82 17.77 Progressive Corp PGR Financials 39.32 1.71 22.34 1.76 13.72 30.54 39.94 22.84 1.81 Prologis PLD Real Estate 50.55 3.44 22.28 2.27 28.21 40.88 54.87 26.76 1.81 Prudential Financial PRU Financials 111.24 2.67 11.46 9.71 106.76 66.51 114.55 47.83 7.5 Public Serv. Enterprise Inc. PEG Utilities 44.98 3.78 25.7 1.75 26.01 39.28 47.41 22.77 3.37 Public Storage PSA Real Estate 228.01 3.53 33.48 6.81 29.11 200.65 277.6 39.59 1.86 Pulte Homes Inc. PHM Consumer Discretionary 22.79 1.6 13.04 1.75 14.6 16.6 22.94 7.24 1.03 PVH Corp PVH Consumer Discretionary 89.75 0.17 12.56 7.15 60.33 82.1 115.4 7.11 1.07 QUALCOMM Inc. QCOM Information Technology 56.73 3.76 17.3 3.28 21.12 49.67 71.62 83.79 8.55 Quest Diagnostics DGX Health Care 98.17 1.83 21.77 4.51 33.78 67.36 98.75 13.5 1.41 Raytheon Co. RTN Industrials 154.48 1.91 20.76 7.44 34.38 120.24 156.4 45.24 3.69 Realty Income Corporation O Real Estate 59.84 4.19 52.96 1.13 24.49 52.72 72.29 15.57 0.9976 Regency Centers Corporation REG Real Estate 65.72 2.95 46.28 1.42 21.76 65.16 85.35 6.84 0.4043 Regions Financial Corp. RF Financials 15.25 1.69 17.45 0.87 13.05 7.53 16.03 18.38 0 Republic Services Inc RSG Industrials 62.08 2.06 34.88 1.78 22.66 45.56 62.39 21.05 2.65 Robert Half International RHI Industrials 47.53 2.02 17.8 2.67 8.5 34.34 50.98 6.07 0.6175 Rockwell Automation Inc. ROK Industrials 153.58 1.99 26.44 5.81 15.94 104.48 156.11 19.75 1.19 Rockwell Collins COL Industrials 97.47 1.36 17.42 5.59 16.85 78.54 98.12 12.75 1.22 Ross Stores ROST Consumer Discretionary 66.87 0.95 23.63 2.83 7.08 52 69.81 25.96 2.11 Royal Caribbean Cruises Ltd RCL Consumer Discretionary 94.54 2.01 15.94 5.93 42.51 64.95 97.67 20.31 2.38 S&P Global, Inc. SPGI Financials 130.69 1.27 16.46 7.94 2.52 92.03 131.26 33.77 2.47 SCANA Corp SCG Utilities 69.81 3.48 16.78 4.16 40.06 64.5 76.41 9.98 1.6 Scripps Networks Interactive Inc. SNI Consumer Discretionary 78.34 1.53 15.12 5.18 14.69 58.73 83.42 10.14 1.52 Seagate Technology STX Information Technology 48.28 5.15 28.17 1.71 5.16 18.42 49.79 14.25 1.71 Sealed Air SEE Materials 44.41 1.38 18.05 2.46 3.15 42.01 52.83 8.59 1.04 Sempra Energy SRE Utilities 110.58 3.01 20.25 5.46 51.77 92.95 114.66 27.71 2.94 Sherwin-williams SHW Materials 310.58 1.09 25.9 11.99 20.3 239.48 316.66 28.74 1.98 Signet Jewelers SIG Consumer Discretionary 63.25 1.61 9.47 6.68 32.06 62.1 125.45 4.4 0.9051 Simon Property Group Inc SPG Real Estate 177.29 3.9 30.2 5.87 13.63 173.11 229.1 55.5Skyworks Solutions SWKS Information Technology 95.05 1.18 20.11 4.73 19.81 57.11 97.57 17.58 1.37 SL Green Realty SLG Real Estate 112.12 2.76 47.98 2.34 70.63 91.03 120.63 11.28 0.9826 Snap-On Inc. SNA Consumer Discretionary 168.46 1.67 18.31 9.2 45.16 145.17 181.73 9.77 0.9267 Southern Co. SO Utilities 50.4 4.45 19.76 2.55 25 46.2 54.64 49.95 7.63 Southwest Airlines LUV Industrials 56.83 0.68 16.02 3.55 13.72 35.42 59.68 34.96 5.27 Stanley Black & Decker SWK Consumer Discretionary 127.91 1.81 19.65 6.51 41.73 97.47 130.47 19.52 1.88 Starbucks Corp. SBUX Consumer Discretionary 56.2 1.58 28.82 1.95 3.98 50.84 61.64 81.91 4.95 State Street Corp. STT Financials 79.6 1.89 16.02 4.97 47.19 50.6 83.49 30.4 Stryker Corp. SYK Health Care 129.14 1.31 29.69 4.35 25.47 102.31 131.36 48.15 3.11 Sun Trust Banks STI Financials 59.72 1.73 16.59 3.6 45.38 34.79 61.69 29.33 Symantec Corp. SYMC Information Technology 29.29 1.03 8.82 3.32 6.38 16.14 29.47 18.13 0.875 Synchrony Financial SYF Financials 35.6 1.44 13.14 2.71 17.37 23.25 38.06 28.86 0 Sysco Corp SYY Consumer Staples 52.3 2.53 28.52 1.83 4.58 44.71 57.07 28.25 W T. Rowe Price Group TROW Financials 70.9 3.2 14.93 4.75 20.46 62.97 79 17.26 1.93 Target Corp TGT Consumer Discretionary 55.14 4.18 11.74 4.7 19.69 55.05 84.14 30.67 7.27 TE Connectivity Ltd. TEL Information Technology 74.36 1.96 13.01 5.72 24.86 54.54 76.49 26.42 2.63 Texas Instruments TXN Information Technology 79.12 2.57 22.75 3.48 10.52 54.54 80.37 79.09 5.7 Textron Inc. TXT Industrials 47.85 0.17 13.57 3.53 20.62 32.55 50.93 12.92 1.59 The Bank of New York Mellon Corp. BK Financials 47.67 1.58 15.13 3.15 33.67 35.44 49.54 49.46 The Clorox Company CLX Consumer Staples 136.91 2.34 27.46 4.99 2.11 111.24 140.47 17.56 1.22 The Cooper Companies COO Health Care 193.46 0.03 31.88 6.07 57.07 141.67 201.83 9.56 0.6286 The Hershey Company HSY Consumer Staples 108.15 2.27 32.38 3.34 3.7 87.92 117.79 22.97 1.62 The Mosaic Company MOS Materials 29.18 1.99 34.33 0.85 27.37 22.77 34.36 10.22 1.2 The Travelers Companies Inc. TRV Financials 122.14 2.16 11.88 10.28 83.05 103.45 125.49 34.16 5.12 The Walt Disney Company DIS Consumer Discretionary 110.86 1.4 20.01 5.54 27.01 90.32 111.99 175.3 16.78 Thermo Fisher Scientific TMO Health Care 157.26 0.37 30.89 5.09 54.74 136.58 160.89 61.39 4.53 Tiffany & Co. TIF Consumer Discretionary 88.76 1.99 24.86 3.57 23.37 56.99 92.74 11.05 0.9348 Time Warner Inc. TWX Consumer Discretionary 98.24 1.63 19.83 4.95 31.52 67.85 99.29 76.07 8.57 TJX Companies Inc. TJX Consumer Discretionary 78.3 1.32 22.64 3.46 6.86 71.5 83.64 51.47 4.51 Torchmark Corp. TMK Financials 78.03 0.77 17.37 4.49 38.69 52.19 79.05 9.19 0.8654 Total System Services TSS Information Technology 54.26 0.73 31.31 1.73 11.45 43.67 56.54 9.95 0.8544 Tractor Supply Company TSCO Consumer Discretionary 71.43 1.33 21.84 3.27 11.11 61.5 97.25 0.8398 Twenty-First Century Fox Class A FOXA Consumer Discretionary 30.52 1.18 18.6 1.64 7.75 23.33 31.75 56.49 6.95 Twenty-First Century Fox Class B FOX Consumer Discretionary 30.11 1.2 18.35 1.64 7.75 23.88 31.3 55.73 6.95 Tyson Foods TSN Consumer Staples 61.89 1.42 12.49 4.96 26.01 55.72 77.05 22.72 3.78 U.S. Bancorp USB Financials 55.03 2.02 16.98 3.24 24.63 38.47 56.61 93.22 UDR Inc UDR Real Estate 36.23 3.29 33.55 1.08 11.4 32.79 38.61 9.69 0.6055 Union Pacific UNP Industrials 108.36 2.22 21.37 5.07 24.43 77.29 111.38 88.18 9.31 United Continental Holdings UAL Industrials 72.64 10.6 6.85 27.52 37.41 76.8 22.85 6.85United Health Group Inc. UNH Health Care 168.3 1.49 23.21 7.25 40.2 120.41 169.36 160.08 14.51 United Parcel Service UPS Industrials 105.64 3.13 27.3 3.87 0.47 98.85 120.44 91.91 7.7 United Technologies UTX Industrials 112.28 2.35 18.35 6.12 34.1 95.05 114.44 90.48 10.04 Universal Health Services, Inc. UHS Health Care 123.75 0.32 17.33 7.14 46.91 99.72 139.77 11.95 1.7 Unum Group UNM Financials 48.71 1.63 12.33 3.95 39.02 29.79 50.27 11.17 1.62 V.F. Corp. VFC Consumer Discretionary 52.62 3.19 20.66 2.55 11.93 48.05 66.91 21.79 1.93 Valero Energy VLO Energy 65.62 4.24 13.3 4.93 44.35 46.88 71.4 29.6 5.52 Varian Medical Systems VAR Health Care 86.06 0 24.5 3.51 18.45 66.86 93.97 8.04 0.6334 Ventas Inc VTR Real Estate 62.67 4.87 33.75 1.86 29.54 55.91 76.8 22.22 1.83 Verizon Communications VZ Telecommunication Services 49.44 4.61 15.4 3.21 5.53 46.01 56.95 201.55 43.39 Viacom Inc. VIAB Consumer Discretionary 42.93 1.89 12.32 3.48 11.23 33.94 46.69 17.04 2.86 Visa Inc. V Information Technology 89.06 0.74 34.52 2.58 11.2 69.58 89.3 206.98 11.01 Vornado Realty Trust VNO Real Estate 107.85 2.61 24.88 4.34 30.99 86.35 111.72 20.39 1.4 Vulcan Materials VMC Materials 118.37 0.82 38.32 3.09 34.55 101.58 138.18 15.67 0.9499 Walgreens Boots Alliance WBA Consumer Staples 85.99 1.75 22.75 3.78 27.17 75.74 88 92.82 7.89 Wal-Mart Stores WMT Consumer Staples 69.87 2.91 15.95 4.38 25.38 62.72 75.19 214.15 32.84 Waste Management Inc. WM Industrials 72.7 2.33 27.43 2.65 12.06 56.05 73.65 31.97 3.71 Wec Energy Group Inc WEC Utilities 59.29 3.51 20.03 2.96 28.29 53.66 66.1 18.71 2.44 Wells Fargo WFC Financials 58.3 2.58 14.61 3.99 35.21 43.55 59.99 291.7 0 Welltower Inc. HCN Real Estate 68.49 5 24.37 2.81 38.06 59.39 80.19 24.83 2.11 Western Union Co WU Information Technology 19.9 3.51 39.02 0.51 1.87 18.07 22.7 9.57 1.37 WestRock Company WRK Materials 50.9 2.96 94.61 0.54 38.02 31.05 56.12 12.79 2.16 Weyerhaeuser Corp. WY Real Estate 33.47 3.63 23.92 1.4 12.26 26.55 34.37 25.07 1.59 Whirlpool Corp. WHR Consumer Discretionary 175.38 2.25 15.25 11.5 64.1 145.91 194.1 13.06 2.18 Willis Towers Watson WLTW Financials 127.63 1.63 56.47 2.26 78.47 112.59 133.4 17.45 1.58 Wyndham Worldwide WYN Consumer Discretionary 82.19 2.52 14.86 5.53 6.76 62.6 86.72 8.63 1.31 Wynn Resorts Ltd WYNN Consumer Discretionary 99.46 1.98 41.79 2.38 1.55 79.77 109.5 10.11 0.9506 Xcel Energy Inc XEL Utilities 43.82 3.29 19.85 2.21 21.73 38 45.42 22.23 3.65 Xilinx Inc XLNX Information Technology 58.75 2.25 25.77 2.28 9.97 41.53 62.24 14.62 0.7671 XL Capital XL Financials 40.13 2.18 25.72 1.56 40.99 30.33 41.39 10.63 1.1 Xylem Inc. XYL Industrials 48.78 1.48 33.64 1.45 12.21 37.58 54.99 8.75 0.615 Zimmer Biomet Holdings ZBH Health Care 117.07 0.81 77.53 1.51 48.2 95.63 133.21 23.54 2.8 Zions Bancorp ZION Financials 45.28 0.71 22.75 1.99 34.1 23.02 48.33 9.17 0 Zoetis ZTS Health Care 53.07 0.79 32.16 1.65 3.02 39.35 56.5 26.11 1.7
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started