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.   %

DuPont Automotive releases a Color Popularity Report which provides the percentages of car colors in North America. The most recent report is shown in the following table.

find 38th percentile   105,108,120,115,112,116,115,118,119,120,111,125,135,114

Here are some of the Final Exam scores from last semester's class: 81, 77, 90, 93, 99, 88, 85, 70, 79, 91, 94, 87. Find the mean. Round your answer to 3 decimal places.

Does the mean represent the center of the data?

find 27th percentile of data   41,42,45,46,48,49,50,52,53,55,58

A parent comes to you and asks the difference between percent correct and the national percentile rank on an achievement test. What do you tell the parent?

The price per share of stock for a sample of  companies was recorded at the beginning of the first financial quarter and then again at the end of the first financial quarter. How stocks perform during the first quarter is an indicator of what is ahead for the stock market and the economy. Use the sample data in the file StockQuarter to answer the following. Click on the datafile logo to reference the data.                               Beginning of 1st                                                           end of 1stCompany                                 Quarter                                                       QuarterBank of New York Mellon    53.82                        54.19     Kraft Foods                                   77.02        55.70    E.I. du Pont de Nemours and Company    109.00        102.57    Consolidated Edison    83.58                      79.95    Johnson & Johnson    139.23                                                 126.01    Union Pacific…

Approximately 1.4% is not correct

Describe the concept of Regression toward the Mean.