Consumers reports 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 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 is 20 metropolitan areas are as shown. Show steps in Excel please. Only Do D and E a Consider T-Mobile first. What is the median rating? b. Develop a five-number summary for T-Mobile service. c Are there outliers for T-Mobile? Explain d Repeat parts b and c for the other three cell phone services. e Show the box plots for the four cell phone services on one graph. Discuss what a comparison of the box plats tells about the four services. Which service did Consumer Reports recommend as being best in terms of overall customer satisfaction? City AT&T Sprint T-Mobile Verizon Atlanta 70 66 71 79 Boston 69 64 74 76 Chicago 71 65 70 77 Dallas 75 65 74 78 Denver 71 67 73 77 Detroit 73 65 77 79 Jacksonville 73 64 75 81 Las Vegas 72 68 74 81 Los Angeles 66 65 68 78 Miami 68 69 73 80 Minneapolis 68 66 75 77 Philadelphia 72 66 71 78 Phoenix 68 66 76 81 San Antonio 75 65 75 80 San Diego 69 68 72 79 San Francisco 66 69 73 75 Seattle 68 67 74 77 St. Louis 74 66 74 79 Tampa 73 63 73 79 Washington 72 68 71 76

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018

18th Edition

ISBN:9780079039897

Author:Carter

Publisher:Carter

Chapter1: Expressions And Functions

Section1.5: Descriptive Modeling And Accuracy

Problem 11PPS

See similar textbooks

Related questions

Question

Consumers reports 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 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 is 20 metropolitan areas are as shown. Show steps in Excel please. Only Do D and E

a	Consider T-Mobile first. What is the median rating?

b.	Develop a five-number summary for T-Mobile service.

c	Are there outliers for T-Mobile? Explain

d	Repeat parts b and c for the other three cell phone services.

e	Show the box plots for the four cell phone services on one graph. Discuss what a comparison of the box plats tells about the four services. Which service did Consumer Reports recommend as being best in terms of overall customer satisfaction?

City	AT&T	Sprint	T-Mobile	Verizon
Atlanta	70	66	71	79
Boston	69	64	74	76
Chicago	71	65	70	77
Dallas	75	65	74	78
Denver	71	67	73	77
Detroit	73	65	77	79
Jacksonville	73	64	75	81
Las Vegas	72	68	74	81
Los Angeles	66	65	68	78
Miami	68	69	73	80
Minneapolis	68	66	75	77
Philadelphia	72	66	71	78
Phoenix	68	66	76	81
San Antonio	75	65	75	80
San Diego	69	68	72	79
San Francisco	66	69	73	75
Seattle	68	67	74	77
St. Louis	74	66	74	79
Tampa	73	63	73	79
Washington	72	68	71	76