Company Fortune magazine's list of the world's most admired companies for 2014 is provided in the data contained in the file AdmiredCompanies.t 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 Name Return (%) Company Name Return Rank Rank (%) 1 Apple 14.8 26 Воeing 63.2 2 Amazon.com 29.8 27 Exxon Mobil 2.5 3 Google 49.3 28 Wal-Mart Stores 5.5 4 Berkshire Hathaway 11.7 29 Target --9.6 Starbucks 27.1 30 J.P. Morgan Chase 16.3 6. Coca-Cola 1.4 31 Nestie 5.7 Walt Disney 33.8 32 UPS 19.3 FedEx 24.4 33 Caterpillar -4 Southwest Airlines 84.5 34 Goldman Sachs Group 8 10 General Electric 12.3 35 Wells Fargo 30.6 11 American Express 39.6 36 Volkswagen 6.1 12 Costto 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 5.8 42 Pepsico 11.7 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 46 Deere -7.1 22 McDonald's 1.8 47 Intel 15.3 28.3 48 Delta Air Lines 116.6 23 3M 34.2 49 Cisco Systems 7.4 24 Microsoft 25 Tovota Motor 313 50 ATST -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 S8P average return?

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
Please answer this please I can use 2 of my questions left for this
**Transcription of Educational Content on One-Year Total Return Analysis**

---

**(a)** Compute the median return for the top-ranked 50 companies (in %).

- *Median*: 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*: ________%
- *First quartile*: 11.6%
- *Median*: ________%
- *Third quartile*: ________%
- *Maximum*: ________%

**(d)** Compute the lower and upper limits (in %).

- *Lower limit*: ________%
- *Upper limit*: ________%

Are there any outliers?

Returns less than the *Select value* bound or greater than the *Select value* bound are considered outliers. Thus, there are *Select value* outliers.

**(e)** Develop a boxplot for the one-year total return.

- **Boxplot 1**: 
  - X-axis range from -20 to 120 (increments of 10).
  - Box centered around 40.
  - Whiskers extending roughly from 10 to 110.
  - Outliers present at some higher values.
  
- **Boxplot 2**: 
  - X-axis range from -20 to 120 (increments of 10).
  - Box approximately from 30 to 80.
  - Whiskers extending from near 0 to 100.
  - Single outlier indicated above 120.
  
- **Boxplot 3**: 
  - X-axis range from -20 to 120 (increments of 10).
  - Box from 0 to 60.
  - Whiskers from approximately -10 to 80.
  - Two outliers above 70.

--- 

**Note**: For sections requiring numerical values, placeholders such as "Select value" or "________%" are used to indicate missing data entries that need to be completed based on further analysis or data input.
Transcribed Image Text:**Transcription of Educational Content on One-Year Total Return Analysis** --- **(a)** Compute the median return for the top-ranked 50 companies (in %). - *Median*: 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*: ________% - *First quartile*: 11.6% - *Median*: ________% - *Third quartile*: ________% - *Maximum*: ________% **(d)** Compute the lower and upper limits (in %). - *Lower limit*: ________% - *Upper limit*: ________% Are there any outliers? Returns less than the *Select value* bound or greater than the *Select value* bound are considered outliers. Thus, there are *Select value* outliers. **(e)** Develop a boxplot for the one-year total return. - **Boxplot 1**: - X-axis range from -20 to 120 (increments of 10). - Box centered around 40. - Whiskers extending roughly from 10 to 110. - Outliers present at some higher values. - **Boxplot 2**: - X-axis range from -20 to 120 (increments of 10). - Box approximately from 30 to 80. - Whiskers extending from near 0 to 100. - Single outlier indicated above 120. - **Boxplot 3**: - X-axis range from -20 to 120 (increments of 10). - Box from 0 to 60. - Whiskers from approximately -10 to 80. - Two outliers above 70. --- **Note**: For sections requiring numerical values, placeholders such as "Select value" or "________%" are used to indicate missing data entries that need to be completed based on further analysis or data input.
### Fortune Magazine's Most Admired Companies of 2014 and Their Returns

This table presents data on the world's most admired companies for the year 2014, showcasing their one-year total return percentages. This information is extracted from Fortune magazine's prestigious list.

| Rank | Company Name           | Return (%) |
|------|------------------------|------------|
| 1    | Apple                  | 41.4       |
| 2    | Amazon.com             | 62         |
| 3    | Google                 | 41.9       |
| 4    | Berkshire Hathaway     | 11.7       |
| 5    | Starbucks              | 27.4       |
| 6    | Coca-Cola              | 4.8        |
| 7    | Walt Disney            | 33.8       |
| 8    | FedEx                  | 24.5       |
| 9    | Southwest Airlines     | 84.5       |
| 10   | General Electric       | 19.5       |
| 11   | American Express       | 35.1       |
| 12   | Costco Wholesale       | 8.1        |
| 13   | Nike                   | 10.8       |
| 14   | BMW                    | -1.7       |
| 15   | Procter & Gamble       | 4.3        |
| 16   | IBM                    | -12.4      |
| 17   | Nordstrom              | 12.2       |
| 18   | Singapore Airlines     | -13.9      |
| 19   | Johnson & Johnson      | 30.9       |
| 20   | Whole Foods Market     | -3.6       |
| 21   | Samsung Electronics    | -1.2       |
| 22   | McDonald's             | 0.4        |
| 23   | Microsoft              | 38.7       |
| 24   | Toyota Motor           | 28.6       |
| 25   | Boeing                 | 63.2       |
| 26   | Exxon Mobil            | 0.2        |
| 27   | Wal-Mart Stores        | -5.5       |
| 28   | Target                 | 9.6        |
| 29   | J.P. Morgan Chase      | 16.3
Transcribed Image Text:### Fortune Magazine's Most Admired Companies of 2014 and Their Returns This table presents data on the world's most admired companies for the year 2014, showcasing their one-year total return percentages. This information is extracted from Fortune magazine's prestigious list. | Rank | Company Name | Return (%) | |------|------------------------|------------| | 1 | Apple | 41.4 | | 2 | Amazon.com | 62 | | 3 | Google | 41.9 | | 4 | Berkshire Hathaway | 11.7 | | 5 | Starbucks | 27.4 | | 6 | Coca-Cola | 4.8 | | 7 | Walt Disney | 33.8 | | 8 | FedEx | 24.5 | | 9 | Southwest Airlines | 84.5 | | 10 | General Electric | 19.5 | | 11 | American Express | 35.1 | | 12 | Costco Wholesale | 8.1 | | 13 | Nike | 10.8 | | 14 | BMW | -1.7 | | 15 | Procter & Gamble | 4.3 | | 16 | IBM | -12.4 | | 17 | Nordstrom | 12.2 | | 18 | Singapore Airlines | -13.9 | | 19 | Johnson & Johnson | 30.9 | | 20 | Whole Foods Market | -3.6 | | 21 | Samsung Electronics | -1.2 | | 22 | McDonald's | 0.4 | | 23 | Microsoft | 38.7 | | 24 | Toyota Motor | 28.6 | | 25 | Boeing | 63.2 | | 26 | Exxon Mobil | 0.2 | | 27 | Wal-Mart Stores | -5.5 | | 28 | Target | 9.6 | | 29 | J.P. Morgan Chase | 16.3
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman