Answered step by step
Verified Expert Solution
Question
1 Approved Answer
11. [-/18 Points] DETAILS MY NOTES ASWSBE14 3.E.053.ALT. 0/3 Submissions Used DATAfile: Admired Companies Fortune magazine's list of the world's most admired companies for
11. [-/18 Points] DETAILS MY NOTES ASWSBE14 3.E.053.ALT. 0/3 Submissions Used DATAfile: Admired Companies Fortune magazine's list of the world's most admired companies for 2014 is provided in the data contained in the file Admired Companies.+ The data in the column labeled "Return" shows the one-year total return (%) for the top ranked 50 companies. For the same time period, the S&P average return was 18.4%. Company Return Rank Name (%) Rank Company Name Return (%) 1 Apple 14.8 Boeing 63.2 2 Amazon.com 29.8 27 Exxon Mobil 2.5 3 Google 49.3 28 Wal-Mart Stores 4 Berkshire Hathaway 11.7 29 Target -9.6 5 Starbucks 27.1 30 J.P. Morgan Chase 16.3 6 Coca-Cola 1.4 31 Nestle 5.7 7 Walt Disney 33.8 UPS 19.3 8 FedEx 24.4 Caterpillar 9 Southwest Airlines 84.5 34 Goldman Sachs Group 10 General Electric 12.3 35 Wells Fargo 30.6 11 American Express 39.6 36 Volkswagen 6.1 12 Costco Wholesale 8.1 37 Unilever -7.3 13 Nike 32.8 38 Facebook 117.1 14 BMW 15.1 39 Marriott International 21.7 15 Procter & Gamble 4.1 40 Home Depot 15.7 16 IBM -12.4 41 BlackRock 24.2 17 Nordstrom PepsiCo 18 Singapore Airlines -13.9 43 DuPont 34.3 19 Johnson & Johnson 20.5 44 eBay -5.1 20 Whole Foods Market 13 45 Accenture 8.3 21 Samsung Electronics -12.9 Deere -7.1 22 McDonald's 1.8 47 Intel 15.3 23 3M 28.3 48 Delta Air Lines 116.6 24 Microsoft 34.2 49 Cisco Systems 25 Toyota Motor 31.3 50 AT&T -4.5 (a) Compute the median return for the top-ranked 50 companies (in %). 13.9 (b) What percentage of the top-ranked 50 companies had a one-year return greater than the S&P average return? (c) Develop the five-number summary (in %) for the data. minimum -13.9 first quartile 3.3 median 13.9 % third quartile 29.5 % maximum 117.1 % (d) Compute the lower and upper limits (in %). lower limit upper limit Are there any outliers? % Returns less than the -Select- V bound greater than the -Select- bound are considered outliers. Thus, there are ---Select-- outliers. (e) Develop a boxplot for the one-year total return. -20-10 0 10 20 30 40 50 60 70 80 90 100 110 120 QO -20-10 0 10 20 30 40 50 60 70 80 90 100 110 120 DO -20-10 0 10 20 30 40 50 60 70 80 90 100 110 120 DO Need Help? Read It Viewing Saved Work Revert to Last Response Submit Answer
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