Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
6th Edition
ISBN: 9781337115186
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
Videos
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 solution
Students have asked these similar questions
The 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.
An business reviews data on the daily amount of calls it receives. Are the data discrete or continous?
please. help me answer this question. thank you
Chapter 3 Solutions
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
Ch. 3.1 - 1. Consider a sample with data values of 10, 20,...Ch. 3.1 - 2. Consider a sample with data values of 10, 20,...Ch. 3.1 - 3. Consider the following data and corresponding...Ch. 3.1 - Prob. 4ECh. 3.1 - Prob. 5ECh. 3.1 - Prob. 6ECh. 3.1 - 7. The average number of minutes Americans commute...Ch. 3.1 - Middle-Level Manager Salaries. Suppose that an...Ch. 3.1 - 9. Which companies spend the most money on...Ch. 3.1 - Advertising Spending. Which companies spend the...
Ch. 3.1 - Prob. 11ECh. 3.1 -
The Big Bang Theory, a situation comedy...Ch. 3.1 - Automobile Fuel Efficiencies. In automobile...Ch. 3.1 -
The data contained in the DATAfile named...Ch. 3.1 - 15. Martinez Auto Supplies has retail stores...Ch. 3.1 - 16. The grade point average for college students...Ch. 3.1 - 17. The following table shows the total return and...Ch. 3.1 - 18. Based on a survey of master’s programs in...Ch. 3.1 - Annual revenue for Corning Supplies grew by 5.5%...Ch. 3.1 - Suppose that at the beginning of Year 1 you...Ch. 3.1 - Prob. 21ECh. 3.1 - Prob. 22ECh. 3.2 - 23. Consider a sample with data values of 10, 20,...Ch. 3.2 - Prob. 24ECh. 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 - Round-Trip Flight Prices. The following table...Ch. 3.2 -
The Australian Open is the first of the four...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 - 35. Consider a sample with data values of 10, 20,...Ch. 3.3 - 36. Consider a sample with a mean of 500 and a...Ch. 3.3 - 37. Consider a sample with a mean of 30 and a...Ch. 3.3 - 38. Suppose the data have a bell-shaped...Ch. 3.3 - 39. The results of a national survey showed that...Ch. 3.3 - 40. The energy information Administration reported...Ch. 3.3 - 41. The Graduate Management Admission Test (GMAT)...Ch. 3.3 - 42. Many families in California are using backyard...Ch. 3.3 -
According to a Los Angeles Times study of more...Ch. 3.3 - NCAA Basketball Game Scores. A sample of 10 NCAA...Ch. 3.3 -
The Wall Street Journal reported that Walmart...Ch. 3.4 - Consider a sample with data values of 27, 25, 20,...Ch. 3.4 - Prob. 47ECh. 3.4 - Prob. 48ECh. 3.4 - Prob. 49ECh. 3.4 - Naples Half-Marathon Times. Naples, Florida, hosts...Ch. 3.4 - Pharmaceutical Company Sales. Annual sales, in...Ch. 3.4 - Cell Phone Companies Customer Satisfaction....Ch. 3.4 - Most Admired Companies. Fortune magazine’s list of...Ch. 3.4 - Prob. 54ECh. 3.5 - Five observations taken for two variables...Ch. 3.5 - Prob. 56ECh. 3.5 - The DATAfile TwoStocks contains adjusted monthly...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 - Americans Dining Out. Americans tend to dine out...Ch. 3 - NCAA Football Coaches Salaries. A 2017 USA Today...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 - Work Commuting Methods. Public transportation and...Ch. 3 - Household Incomes. The following data represent a...Ch. 3 - Restaurant Chains’ Sales per Store. The data...Ch. 3 - Prob. 70SECh. 3 - NFL Teams Worth. In 2014, the 32 teams in the...Ch. 3 - MLB Team Winning Percentages. Does a major league...Ch. 3 - 73. The days to maturity for a sample of five...Ch. 3 - 74. Automobiles traveling on a road with a posted...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
- A study on driving speed (miles per hour) and fuel efficiency (miles per gallon) for midsize automobiles resulted in the following data: Click on the datafile logo to reference the data. DATA file 3. a. Which of the following is a scatter diagram with driving speed on the horizontal axis and fuel efficiency on the vertical axis? 1. Fuel Efficiency (MPG) Fuel Efficiency (MPG) -30- -20 -10 30 -20 10 10. 10 20 30 40 Driving Speed (MPH) 50 20 30 4,0 50 Driving Speed (MPH) 60 60 2. 4. Fuel Efficiency (MPG) 30 -20 10- Full Efficiency (MPC) 30 -10- 10 10 Driving Speed 30 50 40 55 30 25 60 25 50 55 Fuel Efficiency 28 25 25 23 30 32 21 35 26 25 20 30 40 50 60 Driving Speed (MPH) - Select your answer - V b. Comment on any apparent relationship between these two variables. For midsized cars, lower driving speeds seem to yield - Select your answer - miles per gallon. 50 20 30 40 Driving Speed (MPH) 6,0arrow_forwardThe data set Pain contains hypothetical data for a clinical trial of a drug therapy to control pain. The clinical trial investigates whether adverse responses increase with larger drug doses. Subjects receive either a placebo or one of four drug doses (1, 2, 3, or 4 units). An adverse response is recorded as Adverse = 'Yes'; otherwise, it is recorded as Adverse = 'No'. The number of subjects for each drug dose and response combination is contained in the variable Count. (a) Construct a contingency table that corresponds to the data set created above. What type of variable is Dose? (B) Compute the sample proportions of adverse responses at each dose level. Do you observe any trend in the proportion of adverse responses with respect to dose level? (C) Conduct a Cochran-Armitage trend test at the 5% significance level to address the interests of the trial.arrow_forwardThe recommendations of respected wine critics have a substantial effect on the price of wine. Vintages that earn higher ratings command higher prices and spark surges in demand. These data are a random sample of ratings of wines selected from an online Web site from the 2000 and 2001 vintages. Complete parts (a) through (d). Click the icon to view the table of wine rating, price, and vintage. Yes, all the conditions are satisfied. B. No, the 2000 data contains outliers. No, the 2001 data is too skewed. D. No, the sampling procedure was not identified and it cannot be condluded that this is a simple random survey. No, the variances are drastically different. (b) Find the 95% confidence interval for the difference in average ratings in these two vintages. Does one of the years look better than the other? The 95% confidence interval for P2000 - P2001 is ( – 1.0. 1.7). (Round to one decimal place as needed.) Does one of the years look better than the other? O A. Yes, 2000 looks better…arrow_forward
- The success of an airline depends heavily on its ability to provide a pleasant customer experience. One dimension of customer service on which airines compete is on-time arrival. The file LateFlights contains a sample of data from delayed fights showing the number of minutes each delayed fight was late for two dfferent airlines, Deita and Southwest. Click on the datafile logo to reference the data. DATA file Delta Southwest Delta Southwest Delta Southwest Delta Southwest Deita 36 30 34 38 119 120 63 37 35 67 114 53 102 55 8 87 68 100 43 50 86 74 17 66 87 35 40 34 64 41 53 30 86 33 57 61 7. 46 S2 26 70 62 75 54 80 a. Formulate the hypotheses that can be used to test for a difference between the population mean minutes late for delayed flights by these two airlines. 41= population mean minutes late for delayed Deita flights Ha = population mean minutes late for delayed Southwest flights Ho: H- 2Select your answer H.: -4a- Select your answer b. What is the sample mean number of minutes…arrow_forwardThe following table shows the length, in centimeters, of the humerus and the total wingspan, in centimeters, of several pterosaurs, which are extinct flying reptiles.arrow_forwardThe Crazy Nut Company wishes to market two special nut mixes during the holiday season. The Fancy Mix contains 0.5 pound of peanuts and 0.5 pound of cashews. The Deluxe Mix contains 0.6pound of peanuts, 0.2 pound of cashews and 0.15 pound of almonds. Fancy Mix sells for $12 per can and Deluxe Mix sells for $16 per can. The data pertinent to the raw ingredients appear in the table. The Crazy can sell all cans of either mix that it produces, but wants to keep the production quantity of Fancy Mix at least twice as many as Deluxe Mix. Formulate an LP model to determine how many of each mix to produce to maximize the total profit. Do not solve it. You can formulate as a spreadsheet model or an algebraic model. Define your decision variables (changing cells) clearly. Ingredient Amount Available (lb) Cost Per Pound (s) Peanuts 300 $1 Cashews 120 $3 Almonds 90 $4arrow_forward
- Please answer 4.12 only and show complete solution. Thank you!arrow_forwardLovely Lawns, Inc., intends to use sales of lawn fertilizer to predict lawn mower sales. The store manager estimates a probable six- week lag between fertilizer sales and mower sales. The pertinent data are: Fertilizer Number of Fertilizer Number of Sales Mowers Sold Sales Mowers Sold Period (tons) (six-week lag) Period (tons) (six-week lag) 1 1.6 10 8. 1.3 7 1.3 8 1.7 10 3 1.8 11 10 1.2 6. 4 2.0 12 1.9 11 2.2 12 12 1.4 1.6 9. 13 1.7 10 7 1.5 14 1.6 a. Determine the correlation between the two variables. Does it appear that a relationship exists between these variables will yield good predictions? (Do not round intermediate calculations and round your answer to 3 decimal places.) it appears that a positive v relationship exists between these variables. b. Obtain a linear regression line for the data. (Negative values should be indicated by a minus sign. Do not round intermediate calculations and round your answers to 3 decimal places.) Y = O Xi + c. Predict expected lawn mower sales…arrow_forwardA real estate agent wanted to find the relationship between sale price of houses and the size of the house. She collected data on two variables recorded in the following table for 15 houses in Seattle. The two variables are PRICE= Sale price of houses in thousands of dollars SIZE= Area of the entire house in square feet. PRICE 455 278 463 327 505 264 445 346 487 289 434 411 223 323 488 250 225 290 180 320 240 270 205 285 240 260 230 170 230 298 SIZE a) Using MICROSOFT EXCEL- run the above regression and copy the output into your assignment word document from which you can write down the least square regression line. Write down the least square regression line from that specific output. USE THE NAME OF VARIABLES WHEN YOU WRITE THE EQUATION. b) Interpret the slope and constant term with proper UNITS assigned. c) Comment on the explanatory power of the regression model from the required output. Copy that specific output into your assignment word document. Now to increase the explanatory…arrow_forward
- Spring is a peak time for selling houses. Suppose the data below contains the selling price, number of bathrooms, square footage, and number of bedrooms of 26 homes sold in Ft. Thomas, Kentucky, in spring 2018. Selling Price Baths Sq Ft Selling Price 160,000 170,000 178,000 182,500 195,100 212,500 245,900 250,000 255,000 258,000 267,000 268,000 275,000 1.5 1,786 2 1,768 1 1,219 1 1,578 1.5 1,125 2 1,196 2 2,128 N W 3 2 1,280 1,596 3.5 2,374 2.5 2,439 2 1,470 2 1,688 Beds 3 3 3 2 3 2 3 3 3 4 3 4 4 295,000 325,000 325,000 328,400 331,000 344,500 365,000 385,000 395,000 399,000 430,000 430,000 454,000 Baths Sq Ft 2.5 1,860 3 2,056 3.5 2,776 2 1,408 1.5 1,972 2.5 1,736 2.5 1,990 2.5 3,640 2.5 1,928 2 2,108 2 2,462 2 2,615 3.5 3,700 Beds 3 4 4 4 3 3 4 4 4 3 4 4 4 Consider the estimated regression equation we developed that can be used to predict the selling price given the number of bathrooms, square footage, and number of bedrooms in the house. (x, denotes number of bathrooms, x₂ denotes…arrow_forwardA statistics instructor at a large western university would like to examine the relationship (if any) between the number of optional homework problems students do during the semester and their final course grade. She randomly selects 12 students for study and asks them to keep track of the number of these problems completed during the course of the semester. At the end of the class each student's total marks is recorded along with their final grade. The data follow in Table 2. Table 2 Problem Course Grade 51 62 58 68 62 66 65 66 67 68 76 72 77 73 78 72 78 78 84 73 85 76 91 75 For this setting identify the response variable. i. i. For this setting, identify the predictor variable. Compute the linear correlation coefficient for this data set iv. ii. Classify the direction and strength of the correlation Test the hypothesis for a significant linear correlation, a = 0.05 What is the valid prediction range for this setting? Use the regression equation to predict a student's final course…arrow_forwardIn a study of visual acuity, participants view an image under low lighting, moderate lighting, or high lighting. the length of time each participant takes to identify the image is recorded. What is the independent variable?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Holt 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