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 pleaseaConsider T-Mobile first. What is the median rating? b.Develop a five-number summary for T-Mobile service. cAre there outliers for T-Mobile? Explain dRepeat parts b and c for the other three cell phone services. eShow 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?CityAT&TSprintT-MobileVerizonAtlanta70667179Boston69647476Chicago71657077Dallas75657478Denver71677377Detroit73657779Jacksonville73647581Las Vegas72687481Los Angeles66656878Miami68697380Minneapolis68667577Philadelphia72667178Phoenix68667681San Antonio75657580San Diego69687279San Francisco66697375Seattle68677477St. Louis74667479Tampa73637379Washington72687176

Given data: City AT&T Sprint T-Mobile Verizon Atlanta 70 66 71 79 Boston 69 64 74 76…

Answered: onsumers reports provided overall…

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

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

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