Essentials of Statistics for Business and Economics (with XLSTAT Printed Access Card)
8th Edition
ISBN: 9781337114172
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 3.4, Problem 52E
Cell Phone Companies Customer Satisfaction. Consumer Reports provides 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 is used with 0 indicating completely dissatisfied and 100 indicating completely satisfied. Suppose that the ratings for the four cell-phone services in 20 metropolitan areas are as shown below.
- a. Consider T-Mobile first. What is the median rating?
- b. Develop a five-number summary for the 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 boxplots for the four cell-phone services on one graph. Discuss what a comparison of the boxplots tells about the four services. Which service does Consumer Reports recommend as being best in terms of overall customer satisfaction?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
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…
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…
No, the data do not contain outliers. V
d. Repeat parts (b) and (c) for the other three cell phone services.
Smallest value
First quartile (to 2 decimals)
Median (to 1 decimal)
Third quartile (to 2 decimals)
AT&T
Largest value
Are there outliers for AT&T? Explain.
Limits for AT&T(to 1 decimal)
No, the data do not contain outliers.
Are there outliers for Sprint? Explain.
Limits for Sprint(to 2 decimals)
No, the data do not contain outliers. V
Are there outliers for Verizon? Explain.
Limits for Verizon (to 2 decimals)
>
* *
and
Sprint
and
and
-------
X
No, the data do not contain outliers. V
e. Which of the following boxplots accurately displays the data set?
#2
Verizon
x
xx
Chapter 3 Solutions
Essentials of Statistics for Business and Economics (with XLSTAT Printed Access Card)
Ch. 3.1 - Consider a sample with data values of 10, 20, 12,...Ch. 3.1 - Consider a sample with data values of 10, 20, 21,...Ch. 3.1 - Consider the following data and corresponding...Ch. 3.1 - Consider the following data.
What is the mean...Ch. 3.1 - Consider a sample with data values of 27, 25, 20,...Ch. 3.1 - Consider a sample with data values of 53, 55, 70,...Ch. 3.1 - The average number of minutes Americans commute to...Ch. 3.1 - Prob. 8ECh. 3.1 - Advertising Spending. Which companies spend the...Ch. 3.1 - Over a nine-month period, OutdoorGearLab tested...
Ch. 3.1 - According to the National Education Association...Ch. 3.1 - The Big Bang Theory, a situation comedy featuring...Ch. 3.1 - Automobile Fuel Efficiencies. In automobile...Ch. 3.1 - The data contained in the file named StateUnemp...Ch. 3.1 - Motor Oil Prices. Martinez Auto Supplies has...Ch. 3.1 - Calculating Grade Point Averages. The grade point...Ch. 3.1 - The following table shows the total return and the...Ch. 3.1 - Business School Ranking. Based on a survey of...Ch. 3.1 - Annual revenue for Corning Supplies grew by 5.5%...Ch. 3.1 - Prob. 20ECh. 3.1 - If an asset declines in value from $5000 to $3500...Ch. 3.1 - The current value of a company is 25 million. If...Ch. 3.2 - Consider a sample with data values of 10, 20, 12,...Ch. 3.2 - Consider a sample with data values of 10, 20, 12,...Ch. 3.2 - Consider a sample with data values of 27, 25, 20,...Ch. 3.2 - Price of Unleaded Gasoline. Data collected by the...Ch. 3.2 - The results of a search to find the least...Ch. 3.2 - The Australian Open is the first of the four Grand...Ch. 3.2 - Air Quality Index. The Los Angeles Times regularly...Ch. 3.2 - Prob. 30ECh. 3.2 - The results of Accounting Principals’ latest...Ch. 3.2 - Advertising Spend by Companies. Advertising Age...Ch. 3.2 - Scores turned in by an amateur golfer at the...Ch. 3.2 - Consistency of Running Times. The following times...Ch. 3.3 - Consider a sample with data values of 10, 20, 12,...Ch. 3.3 - Prob. 36ECh. 3.3 - Consider a sample with a mean of 30 and a standard...Ch. 3.3 - Suppose the data have a bell-shaped distribution...Ch. 3.3 - The results of a national survey showed that on...Ch. 3.3 - The Energy Information Administration reported...Ch. 3.3 - GMAT Exam Scores. The Graduate Management...Ch. 3.3 - Many families in California are using backyard...Ch. 3.3 - Prob. 43ECh. 3.3 - NCAA Basketball Game Scores. A sample of 10 NCAA...Ch. 3.3 - Prob. 45ECh. 3.4 - Consider a sample with data values of 27, 25, 20,...Ch. 3.4 - Show the boxplot for the data in exercise 46. 46....Ch. 3.4 - Prob. 48ECh. 3.4 - Prob. 49ECh. 3.4 - Naples Half-Marathon Times. Naples, Florida, hosts...Ch. 3.4 - Annual sales, in millions of dollars, for 21...Ch. 3.4 - Cell Phone Companies Customer Satisfaction....Ch. 3.4 - Most Admired Companies. Fortune magazines list of...Ch. 3.4 - U.S. Border Crossings. The Bureau of...Ch. 3.5 - Five observations taken for two variables follow....Ch. 3.5 - Five observations taken for two variables follow....Ch. 3.5 - Ten major college football bowl games were played...Ch. 3.5 - Driving Speed and Fuel Efficiency. A department of...Ch. 3.5 - Smoke Detector Use and Death Rates. Over the past...Ch. 3.5 - Stock Market Indexes Comparison. The Russell 1000...Ch. 3.5 - Best Private Colleges. A random sample of 30...Ch. 3 - Prob. 62SECh. 3 - USA Today reports that NCAA colleges and...Ch. 3 - Physician Office Waiting Times. The average...Ch. 3 - Worker Productivity and Insomnia. U.S. companies...Ch. 3 - A study of smartphone users shows that 68% of...Ch. 3 - Prob. 67SECh. 3 - Prob. 68SECh. 3 - Prob. 69SECh. 3 - Best Hotels. Travel + Leisure magazine provides an...Ch. 3 - Prob. 71SECh. 3 - MLB Team Winning Percentages. Does a major league...Ch. 3 - Money Market Funds Days to Maturity. The days to...Ch. 3 - Automobile Speeds. Automobiles traveling on a road...Ch. 3 - Annual Returns for Panama Railroad Company Stock....Ch. 3 - Pelican Stores, a division of National Clothing,...Ch. 3 - The motion picture industry is a competitive...Ch. 3 - The pursuit of a higher education degree in...Ch. 3 - Although millions of elephants once roamed across...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- In 2011 home prices and mortgage rates dropped so low that in a number of cities the monthly cost of owning a home was less expensive than renting. The following data show the average asking rent for 10 markets and the monthly mortgage on the median priced home (including taxes and insurance) for 10 cities where the average monthly mortgage payment was less than the average asking rent (The Wall Street Journal, November 26–27, 2011).Click on the datafile logo to reference the data.   Enter negative values as negative numbers. a.  Develop the estimated regression equation that can be used to predict the monthly mortgage given the average asking rent (to 2 decimals).The regression equation is:Mortgage ($) =  +  Rent ($)arrow_forwardThe r code for side by side boxplot of vitamind v newage and vitamin d v country. Scatterplot code for relationship between vitamin d level and age.arrow_forward
Recommended textbooks for you
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillBig Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin HarcourtHolt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
- Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
Chi Square test; Author: Vectors Academy;https://www.youtube.com/watch?v=f53nXHoMXx4;License: Standard YouTube License, CC-BY