Questions 11 – 13 : Use the attached data set bbdata15s.xls to answer these ques
ID: 3181125 • Letter: Q
Question
Questions 11 – 13: Use the attached data set bbdata15s.xls to answer these questions. Give your answers with at least 2 decimal places. (Be careful to follow the rules of rounding.)
Questions 11 – 15: For the variable Average Ticket Price (Average Ticket$), use Excel to find the following:
11. median
12. mean
13. sample standard deviation
Team League Wins Average Ticket$ Regular season game receipts ($millions) Local TV, radio and cable ($millions) Player compensation and benefits A 0 75 11.79 30.2 10.9 52.2 B 0 63 18.23 53.2 21.0 79.8 C 0 82 39.68 89.7 33.4 118.5 D 0 83 18.73 30.9 30.1 66.7 E 0 91 22.33 69.5 21.1 102.5 F 0 66 20.44 42.3 19.1 57.2 G 0 65 12.30 19.5 6.5 42.7 H 0 85 7.62 17.6 7.3 30.5 I 0 95 24.26 98.0 56.8 117.9 J 0 102 14.94 25.0 9.5 43.8 K 0 116 24.60 76.6 37.9 83.9 L 0 62 15.83 18.2 15.5 57.0 M 0 73 18.03 50.7 25.3 92.8 N 0 80 16.54 25.4 14.5 83.8 O 1 92 13.80 46.5 14.2 99.4 P 1 88 20.59 62.1 20.0 99.7 Q 1 88 24.75 51.2 23.6 78.1 R 1 66 16.66 32.1 7.9 45.4 S 1 73 15.21 54.0 18.2 70.0 T 1 76 12.72 16.8 15.4 42.1 U 1 93 18.87 49.2 13.7 71.6 V 1 86 16.38 50.8 27.3 116.1 W 1 68 17.63 46.0 5.9 51.2 X 1 68 9.00 6.4 0.5 37.7 Y 1 82 22.53 74.0 46.3 99.1 Z 1 86 15.26 30.4 18.9 49.4 AA 1 62 20.52 48.6 9.1 53.2 BB 1 93 21.43 67.1 11.9 80.1 CC 1 79 15.20 34.9 12.4 46.1 DD 1 90 20.84 67.2 17.2 72.2Explanation / Answer
Make an excel sheet containing these values.
In a blank cell, use the following formula to calculate the results. The Average Ticket Price column is in column D.
Median = ROUND(MEDIAN(D2:D31),2) = 17.83
Mean = ROUND(AVERAGE(D2:D31),2)= 18.22
Sample Standard Deviation= ROUND(STDEV.S(D2:D31),2) = 5.95
The ROUND function is used to round-up the answer to n number of digits. n=2 as per the question.
STDEV.S is used to find the sample standard deviation. The .S in the function name denotes sample.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.