Using excel the median is 16.70 but when I calculate it manually it comes to 13.9. Why is excel wrong? A magazine's list of the world's most admired companies for 2014 is provided in the data below. 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%. Rank Company Name Return (%) 1 Company A 13.8 2 Company B 28.8 3 Company C 48.3 4 Company D 10.7 5 Company E 27.1 6 Company F 2.4 7 Company G 33.8 8 Company H 23.4 9 Company I 83.5 10 Company J 12.3 11 Company K 40.6 12 Company L 7.1 13 Company M 31.8 14 Company N 15.1 15 Company O 4.1 16 Company P −12.4 17 Company Q 4.8 18 Company R −14.9 19 Company S 19.5 20 Company T 14 21 Company U −11.9 22 Company V 1.8 23 Company W 27.3 24 Company X 35.2 25 Company Y 30.3 Rank Company Name Return (%) 26 Company Z 63.2 27 Company AA 2.5 28 Company BB 6.5 29 Company CC −10.6 30 Company DD 16.3 31 Company EE 4.7 32 Company FF 20.3 33 Company GG −5 34 Company HH 7 35 Company II 31.6 36 Company JJ 6.1 37 Company KK −6.3 38 Company LL 116.1 39 Company MM 22.7 40 Company NN 16.7 41 Company OO 25.2 42 Company PP 11.7 43 Company QQ 35.3 44 Company RR −5.1 45 Company SS 9.3 46 Company TT −6.1 47 Company UU 14.3 48 Company VV 117.6 49 Company WW 7.4 50 Company XX −3.5 (a) Compute the median return (in %) for the top-ranked 50 companies. %

Name: Using excel the median is 16.70 but when I calculate it manually it co
Uploaded: 2024-03-20T07:07:12.000Z
Channel: Bartleby
Description: Using excel the median is 16.70 but when I calculate it manually it comes to 13.9. Why is excel wrong? A magazine's list of the world's most admired companies for 2014 is provided in the data below. The data in the column labeled "Return" shows the

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

Topic Video

Question

100%

Using excel the median is 16.70 but when I calculate it manually it comes to 13.9. Why is excel wrong?

A magazine's list of the world's most admired companies for 2014 is provided in the data below. 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%.

Rank	Company Name	Return (%)
1	Company A	13.8
2	Company B	28.8
3	Company C	48.3
4	Company D	10.7
5	Company E	27.1
6	Company F	2.4
7	Company G	33.8
8	Company H	23.4
9	Company I	83.5
10	Company J	12.3
11	Company K	40.6
12	Company L	7.1
13	Company M	31.8
14	Company N	15.1
15	Company O	4.1
16	Company P	−12.4
17	Company Q	4.8
18	Company R	−14.9
19	Company S	19.5
20	Company T	14
21	Company U	−11.9
22	Company V	1.8
23	Company W	27.3
24	Company X	35.2
25	Company Y	30.3

Rank	Company Name	Return (%)
26	Company Z	63.2
27	Company AA	2.5
28	Company BB	6.5
29	Company CC	−10.6
30	Company DD	16.3
31	Company EE	4.7
32	Company FF	20.3
33	Company GG	−5
34	Company HH	7
35	Company II	31.6
36	Company JJ	6.1
37	Company KK	−6.3
38	Company LL	116.1
39	Company MM	22.7
40	Company NN	16.7
41	Company OO	25.2
42	Company PP	11.7
43	Company QQ	35.3
44	Company RR	−5.1
45	Company SS	9.3
46	Company TT	−6.1
47	Company UU	14.3
48	Company VV	117.6
49	Company WW	7.4
50	Company XX	−3.5

(a)

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

Definition Definition Middle value of a data set. The median divides a data set into two halves, and it also called the 50th percentile. The median is much less affected by outliers and skewed data than the mean. If the number of elements in a dataset is odd, then the middlemost element of the data arranged in ascending or descending order is the median. If the number of elements in the dataset is even, the average of the two central elements of the arranged data is the median of the set. For example, if a dataset has five items—12, 13, 21, 27, 31—the median is the third item in ascending order, or 21. If a dataset has six items—12, 13, 21, 27, 31, 33—the median is the average of the third (21) and fourth (27) items. It is calculated as follows: (21 + 27) / 2 = 24.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Hypothesis Tests and Confidence Intervals for Means$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.

Similar questions