Answer Happy

A 1 City 2 Atlanta 3 Boston 4 5 6 Denver 7 Detroit 8 9 10 11 Miami Chicago Dallas 15 16 Jacksonville Las Vegas Los Angeles 12 Minneapolis 13 Philadelphia 14 Phoenix San Antonio San Diego 17 San Francisco 18 Seattle St. Louis 19 20 Tampa 21 Washington 22 23 24 25 B AT&T 70 69 71 75 71 73 73 72 66 68 68 72 68 75 69 66 68 74 73 72 C Sprint 68 66 67 67 69 67 66 70 67 71 68 68 68 67 70 71 69 68 65 70 D T-Mobile 72 75 71 75 74 78 76 75 69 74 76 72 77 76 73 74 75 75 74 72 E Verizon 80 77 78 79 78 80 82 82 79 81 78 79 82 81 80 76 78 80 80 77 F

A magazine provided overall customer satisfaction scores for AT&T, Sprint, T-Mobile, and Verizon cell-phone services in major metropolitan areas throughout the United States. The rating for each service reflects the overall customer satisfaction considering a variety of factors such as cost, connectivity problems, dropped calls, static interference, and customer support. A satisfaction scale from 0 to 100 was used with 0 Indicating completely dissatisfied and 100 indicating completely satisfied. The ratings for the four cell-phone services in 20 metropolitan areas are contained in the Excel Online file below. Construct a spreadsheet to answer the following questions.

a. Consider T-Mobile first. What is the median rating (to 1 decimal)? b. Develop a five-number summary for the T-Mobile service. Smallest value 00000 First quartile (to 2 decimals) Median (to 1 decimal) Third quartile (to 2 decimals) Largest value c. Are there outliers for T-Mobile? W

d. Repeat parts (b) and (c) for the other three cell-phone services. AT&T Sprint Verizon Smallest value First quartile (to 2 decimals) Median (to 1 decimal) Third quartile (to 2 decimals) Largest value Are there outliers for AT&T? Are there outliers for Sprint? Are there outliers for Verizon? 000

e. Which of the following box plots accurately displays the data set? Rating #1 90- 85- 80- 70- 65- #2 70- Rating

# 3 8 85 80 70- 65- AT&T Sprint T-Mobile Verizon #4 70- Verizon AT&T Sprint T-Mobile

65- AT&T Sprint T-Mobile Verizon Verizon AT&T Which service did the magazine recommend as being best in terms of overall customer satisfaction? ghe Sprint