RankCompany Name1 Apple2 Amazon.com3 Google4 Berkshire Hathaway5 Starbucks6 Coca-Cola7 Walt Disney8 FedEx9 Southwest Airlines10 General Electric11 American Express12 Costco Wholesale13 Nike14 BMW15 Procter & Gamble16 IBM17 Nordstrom18 Singapore Airlines19 Johnson & Johnson20 Whole Foods Market21 Samsung Electronics22 McDonald's23 3M24 Microsoft25 Toyota Motor26 Boeing27 Exxon Mobil28 Wal-Mart Stores29 Target30 J.P. Morgan Chase31 Nestlé32 UPS33 Caterpillar33 Goldman Sachs Group35 Wells Fargo36 Volkswagen37 Unilever38 Facebook39 Marriott International40 Home Depot41 BlackRock42 PepsiCo43 DuPont44 eBay45 Accenture46 Deere47 Intel48 Delta Air Lines49 Cisco Systems50 AT&TReturn14.829.849.311.727.11.433.824.484.512.339.68.132.815.14.1-12.45.8-13.920.513-12.91.828.334.231.363.22.55.5-9.616.35.719.3-4+0830.66.1-7.3117.121.715.724.211.734.3-5.18.3-7.115.3116.67.4-4.5 Fortune magazine's list of the world's most admired companies for 2014 is provided in the data contained in the file Admired Companies (Fortune magazinewebsite). 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&Paverage return was 18.4%.Click on the datafile logo to reference the data.DATA filea. Compute the median return for the top-ranked 50 companies (to 1 decimal).%b. What percentage of the top-ranked 50 companies had a one-year return greater than the S&P average return (to the nearest percent)?%c. Develop the five-number summary for the data. If required, round your answers to two decimals places. If required, enter negative values as negativenumbers.MinimumFirst QuartileMedianThird QuartileMaximumReturn

Answered: -Cola Walt Disney FedEx Southwest…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

Rank
Company Name
1 Apple
2 Amazon.com
3 Google
4 Berkshire Hathaway
5 Starbucks
6 Coca-Cola
7 Walt Disney
8 FedEx
9 Southwest Airlines
10 General Electric
11 American Express
12 Costco Wholesale
13 Nike
14 BMW
15 Procter & Gamble
16 IBM
17 Nordstrom
18 Singapore Airlines
19 Johnson & Johnson
20 Whole Foods Market
21 Samsung Electronics
22 McDonald's
23 3M
24 Microsoft
25 Toyota Motor
26 Boeing
27 Exxon Mobil
28 Wal-Mart Stores
29 Target
30 J.P. Morgan Chase
31 Nestlé
32 UPS
33 Caterpillar
33 Goldman Sachs Group
35 Wells Fargo
36 Volkswagen
37 Unilever
38 Facebook
39 Marriott International
40 Home Depot
41 BlackRock
42 PepsiCo
43 DuPont
44 eBay
45 Accenture
46 Deere
47 Intel
48 Delta Air Lines
49 Cisco Systems
50 AT&T
Return
14.8
29.8
49.3
11.7
27.1
1.4
33.8
24.4
84.5
12.3
39.6
8.1
32.8
15.1
4.1
-12.4
5.8
-13.9
20.5
13
-12.9
1.8
28.3
34.2
31.3
63.2
2.5
5.5
-9.6
16.3
5.7
19.3
-4
+0
8
30.6
6.1
-7.3
117.1
21.7
15.7
24.2
11.7
34.3
-5.1
8.3
-7.1
15.3
116.6
7.4
-4.5

Transcribed Image Text:Fortune magazine's list of the world's most admired companies for 2014 is provided in the data contained in the file Admired Companies (Fortune magazine website). 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%. Click on the datafile logo to reference the data. DATA file a. Compute the median return for the top-ranked 50 companies (to 1 decimal). % b. What percentage of the top-ranked 50 companies had a one-year return greater than the S&P average return (to the nearest percent)? % c. Develop the five-number summary for the data. If required, round your answers to two decimals places. If required, enter negative values as negative numbers. Minimum First Quartile Median Third Quartile Maximum Return

Expert Solution

Step 1: the median return for the top ranked 50 companies is 

The objective of this part is to find the median return for the top ranked 50 companies.

Arrange the one-year total return in the increasing order from smallest to largest and assign the position numbers.

Since there are 50 observations which is even, the median is the average of the 2 middle values, which is the average of the value in position 25^th and 26^th position. The values in the 25^th and 26^th position are 13 and 14.8 respectively. So, the median is calculated as follows: