Videa 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 O 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. Open spreadsheet 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 First quartile (to 2 decimals) Median (to 1 decimal) earch a ^ 1) as 9:19 PM 5/2/2021 X Open spreadsheet 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 First quartile (to 2 decimals) Median (to 1 decimal) Third quartile (to 2 decimals) Largest value a Largest Value c. Are there outliers for T-Mobile? d. Repeat parts (b) and (c) for the other three cell-phone services. hone verdices AT&T Sprint Verizon Smallest value First quartile (to 2 decimals) Median (to 1 decimal) DIBUI Third qu (to 2 decimals) Largest value Are there outliers for AT&T? v Are there outliers for Sprint? Are there outliers for AT&T? Are there outliers for Sprint? Are there outliers for Verizon? e. Which of the following box plots accurately displays the data set? Rating 90 90 e. Which of the following box plots accurately dische data set? Rating 90 Rating 90 85 80 802 75 #2 nu 70 Next Rating Rating 90 85 85 80 80- 2015 +4 70 AT&T Sprint T-Mobile Verizon Vertaa AT&T Sprint T-Mobile Next a 9:20 PM 5/2/2021 3 #4 70 AT&T Sprint T-Mobile Verizon Verizon AT&T Sprint T-Mobile Which service did the magazine recommend as being best in terms of overall customer satisfaction? Check My Work Reset Problem Videa 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 O 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. Open spreadsheet 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 First quartile (to 2 decimals) Median (to 1 decimal) earch a ^ 1) as 9:19 PM 5/2/2021 X Open spreadsheet 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 First quartile (to 2 decimals) Median (to 1 decimal) Third quartile (to 2 decimals) Largest value a Largest Value c. Are there outliers for T-Mobile? d. Repeat parts (b) and (c) for the other three cell-phone services. hone verdices AT&T Sprint Verizon Smallest value First quartile (to 2 decimals) Median (to 1 decimal) DIBUI Third qu (to 2 decimals) Largest value Are there outliers for AT&T? v Are there outliers for Sprint? Are there outliers for AT&T? Are there outliers for Sprint? Are there outliers for Verizon? e. Which of the following box plots accurately displays the data set? Rating 90 90 e. Which of the following box plots accurately dische data set? Rating 90 Rating 90 85 80 802 75 #2 nu 70 Next Rating Rating 90 85 85 80 80- 2015 +4 70 AT&T Sprint T-Mobile Verizon Vertaa AT&T Sprint T-Mobile Next a 9:20 PM 5/2/2021 3 #4 70 AT&T Sprint T-Mobile Verizon Verizon AT&T Sprint T-Mobile Which service did the magazine recommend as being best in terms of overall customer satisfaction? Check My Work Reset