Question:
(a) Use Excel to prepare a Pareto chart of the following data. (b) Which three service providers account for approximately 80 percent of all responses? 
Transcribed Image Text:
Cell Phone Service Provider n = 158 O CellPhone Service Provider Percent Cumulative Percent Verizon 37.3 37.3 Cingular T-Mobile 29.7 67.1 13.3 80.4 Sprint Other 8.9 89.2 4.4 93.7 Nextel 3.2 96.8 Alltel Virgin 2.5 99.4 0.6 100.0
> The time required to verify and fill a common prescription at a neighborhood pharmacy is normally distributed with a mean of 10 minutes and a standard deviation of 3 minutes. Find the time for each event. Show your work. a. Highest 10 percent b. Middle
> The Rejuvo Corp. manufactures granite countertop cleaner and polish. Quarterly sales Q is a random variable with a mean of 25,000 bottles and a standard deviation of 2,000 bottles. Variable cost is $8 per unit and fixed cost is $150,000. (a) Find the mea
> A manufacturer fills one-gallon cans (3,785 ml) on an assembly line in two independent steps. First, a high-volume spigot injects most of the paint rapidly. Next, a more precise but slower spigot tops off the can. The fill amount in each step is a normal
> The weight of a Los Angeles Lakers basketball player averages 233.1 pounds with a standard deviation of 34.95 pounds. To express these measurements in terms a European would understand, we could convert from pounds to kilograms by multiplying by .4536. (
> Malaprop Ltd. sells two products. Daily sales of product A have a mean of $70 with a standard deviation of $10, while sales of product B have a mean of $200 with a standard deviation of $30. Sales of the products tend to rise and fall at the same time, h
> A certain outpatient medical procedure has five steps that must be performed in sequence. (a) Assuming that the time (in minutes) required for each step is an independent random variable, find the mean and standard deviation for the total time. (b) Why m
> A manufacturing project has five independent phases whose completion must be sequential. The time to complete each phase is a random variable. The mean and standard deviation of the time for each phase are shown below. (a) Find the expected completion ti
> On Professor Hardtack’s last cost accounting exam, the mean score was 71, the median was 77, and the mode was 81. (a) Sketch the distribution, based on these statistics. (b) What factors might cause the distribution to be like this?
> The median life span of a mouse is 118 weeks. (a) Would you expect the mean to be higher or lower than 118? (b) Would you expect the life spans of mice to be normally distributed? Explain.
> At the Eureka library, the mean time a book is checked out is 13 days, the median is 10 days, and the mode is 7 days. (a) Sketch the distribution, based on these statistics. (b) What factors might cause the distribution to be like this?
> At the Midlothian Independent Bank, a study shows that the mean ATM transaction takes 74 seconds, the median 63 seconds, and the mode 51 seconds. (a) Sketch the distribution, based on these statistics. (b) What factors might cause the distribution to be
> Last year’s freshman class at Big State University totaled 5,324 students. Of those, 1,254 received a merit scholarship to help offset tuition costs their freshman year (although the amount varied per student). The amount a student received was N($3,456,
> A company’s contractual “trigger” point for a union absenteeism penalty is a certain distance above the mean days missed by all workers. Now the company wants to switch the trigger to a certain number of days above the median days missed for all workers.
> A small suburban community agreed to purchase police services from the county sheriff’s department. The newspaper said, “In the past, the charge for police protection from the Sheriff’s Department has been based on the median cost of the salary, fringe b
> The median waiting time for a liver transplant in the United States is 321 days. Would you expect the mean to be higher or lower than 321 days? Explain. (See http://www.livermd.org/.)
> Is this sample of 25 exam scores inconsistent with the hypothesis that the true variance is 64 (i.e., σ = 8)? Use the 5 percent level of significance in a two-tailed test. Show all steps, including the hypotheses and critical values from Appen
> Hammermill Premium Inkjet 24 lb. paper has a specified brightness of 106. (a) At α = .005, does this sample of 24 randomly chosen test sheets from a day’s production run show that the mean brightness exceeds the specificat
> A coin was flipped 60 times and came up heads 38 times. (a) At the .10 level of significance, is the coin biased toward heads? Show your decision rule and calculations. (b) Calculate a p-value and interpret it.
> A U.S. dime weighs 2.268 grams when minted. A random sample of 15 circulated dimes showed a mean weight of 2.256 grams with a standard deviation of .026 gram. (a) Using α = .05, is the mean weight of all circulated dimes lower than the mint weight? State
> Faced with rising fax costs, a firm issued a guideline that transmissions of 10 pages or more should be sent by 2-day mail instead. Exceptions are allowed, but they want the average to be 10 or below. The firm examined 35 randomly chosen fax transmission
> On eight Friday quizzes, Bob received scores of 80, 85, 95, 92, 89, 84, 90, 92. He tells Prof. Hardtack that he is really a 90+ performer, but this sample just happened to fall below his true performance level. (a) State an appropriate pair of hypotheses
> At Ajax Spring Water, a half-liter bottle of soft drink is supposed to contain a mean of 520 ml. The filling process follows a normal distribution with a known process standard deviation of 4 ml. (a) which sampling distribution would you use if random sa
> The cabin of a business jet has a cabin height 5 feet 9 inches high. If a business traveler’s height is N(5’10”, 2.7”), what percentage of the business travelers will have to stoop?
> A can of peeled whole tomatoes is supposed to contain an average of 19 ounces of tomatoes (excluding the juice). The actual weight is a normally distributed random variable whose standard deviation is known to be 0.25 ounce. (a) In quality control, would
> The sodium content of a popular sports drink is listed as 220 mg in a 32-oz bottle. Analysis of 10 bottles indicates a sample mean of 228.2 mg with a sample standard deviation of 18.2 mg. (a) Write the hypotheses for a two-tailed test of the claimed sodi
> Bob said, “Why is a small p-value significant, when a large one isn’t? That seems backwards.” Try to explain it to Bob, giving an example to make your point.
> (a) A statistical study reported that a drug was effective with a p-value of .042. Explain in words what this tells you. (b) How would that compare to a drug that had a p-value of .087?
> A digital camcorder repair service has set a goal not to exceed an average of 5 working days from the time the unit is brought in to the time repairs are completed. A random sample of 12 repair records showed the following repair times (in days): 9, 2, 5
> An auditor reviewed 25 oral surgery insurance claims from a particular surgical office, determining that the mean out-of-pocket patient billing above the reimbursed amount was $275.66 with a standard deviation of $78.11. (a) At the 5 percent level of sig
> In a major football conference, a sample showed that only 267 out of 584 freshmen players graduated within 6 years. (a) At α = .05, does this sample contradict the claim that at least half graduate within 6 years? State your hypotheses and decision rule.
> The EPA is concerned about the quality of drinking water served on airline flights. A sample of 112 flights found unacceptable bacterial contamination on 14 flights. (a) At α = .05, does this sample show that more than 10 percent of all flights have cont
> Ages for the 2009 Boston Red Sox pitchers are shown below. (a) Assuming this is a random sample of major league pitchers, at the 5 percent level of significance does this sample show that the true mean age of all American League pitchers is over 30 years
> A quality control standard requires that no more than 5 percent of bags of Halloween candy be underweight. A random sample of 200 bags showed that 16 were underweight. (a) At α = .025, is the standard being violated? Use a right-tailed test and show your
> Which of the following could not be probability density functions for a continuous random variable? Explain. Hint: Find the area under the function f (x). a. f (x) = .25 for 0 < x < 1 b. f (x) = .25 for 0 < x < 4 c. f (x) = x for 0 < x < 2
> A sample of 100 mortgages approved during the current year showed that 31 were issued to a single-earner family or individual. The historical percentage is 25 percent. (a) At the .05 level of significance in a right-tailed test, has the percentage of sin
> A sample of 100 one-dollar bills from the Subway cash register revealed that 16 had something written on them besides the normal printing (e.g., “Bob Mary”). (a) At α = .05, is this sample evidence consistent with the hypothesis that 10 percent or fewer
> Beer shelf life is a problem for brewers and distributors because when beer is stored at room temperature, its flavor deteriorates. When the average furfuryl ether content reaches 6 μg per liter, a typical consumer begins to taste an unpleasant chemical
> A recent study by the Government Accountability Office found that consumers got correct answers about Medicare only 67 percent of the time when they called 1-800-MEDICARE. (a) At α = .05, would a subsequent audit of 50 randomly chosen calls with 40 corre
> The average service time at a Noodles & Company restaurant was 3.5 minutes in the previous year. Noodles implemented some time-saving measures and would like to know if they have been effective. They sample 20 service times and find the sample average is
> A web-based company has a goal of processing 95 percent of its orders on the same day they are received. If 485 out of the next 500 orders are processed on the same day, would this prove that they are exceeding their goal, using α = .025?
> Malcheon Health Clinic claims that the average waiting time for a patient is 20 minutes or less. A random sample of 15 patients shows a mean wait time of 24.77 minutes with a standard deviation of 7.26 minutes. (a) Write the hypotheses for a right-tailed
> Thetis Mfg. says that its outboard watercraft engine’s noise level at 75 percent throttle averages 100 decibels or less from the operator’s seating position. A random sample of 8 noise level measurements showed a mean of 106 decibels with a standard devi
> Sarpedon Corp. claims that its car batteries average at least 880 CCA (cold-cranking amps). Tests on a sample of 9 batteries yield a mean of 871 CCA with a standard deviation of 15.6 CCA. (a) State the hypotheses to test Sarpedon’s claim against this sam
> Suggest both a Likert scale question and a response scale to measure the following: a. A student’s rating of a particular statistics professor. b. A voter’s satisfaction with the president’s economic policy. c. An HMO patient’s perception of waiting tim
> The weight of a miniature Tootsie Roll is normally distributed with a mean of 3.30 grams and standard deviation of 0.13 gram. (a) Within what weight range will the middle 95 percent of all miniature Tootsie Rolls fall? (b) What is the probability that a
> Historically, 5 percent of a mail-order firm’s repeat charge-account customers have an incorrect current address in the firm’s computer database. (a) What is the probability that none of the next 12 repeat customers who call will have an incorrect addres
> What level of measurement (nominal, ordinal, interval, ratio) is appropriate for the movie rating system that you see in TV Guide (✰, ✰✰, ✰✰✰, ✰✰✰✰)? Explain your reasoning.
> A tabletop survey by a restaurant asked the question shown below. (a) What kind of response scale is this? (b) Suggest an alternative response scale that would be more sensitive to differences in opinion. (c) Suggest possible sources of bias in this type
> Insurance companies are rated by several rating agencies. The Fitch 20-point scale is AAA, AA+, AA, AA-, A+, A, A-, BBB+, BBB, BBB-, BB+, BB, BB-, B+, B, B-, CCC+, CCC, CCC-, DD. (a) What level of measurement does this scale use? (b) To assume that the s
> (a) Use Excel to prepare an appropriate type of chart (bar, line, pie, scatter) to display the following data. Modify the default colors, fonts, etc., as you judge appropriate to make the display effective. (b) Would more than one kind of display be acce
> (a) Use Excel to prepare an appropriate type of chart (bar, line, pie, scatter) to display the following data. Modify the default colors, fonts, etc., as you judge appropriate to make the display effective. (b) Would more than one kind of display be acce
> (a) Use Excel to prepare an appropriate type of chart (bar, line, pie, scatter) to display the following data. Modify the default colors, fonts, etc., as you judge appropriate to make the display effective. (b) Would more than one kind of display be acce
> (a) Use Excel to prepare an appropriate type of chart (bar, line, pie, scatter) to display the following data. Modify the default colors, fonts, etc., as you judge appropriate to make the display effective. (b) Would more than one kind of display be acce
> (a) Use Excel to prepare an appropriate type of chart (bar, line, pie, scatter) to display the following data. Modify the default colors, fonts, etc., as you judge appropriate to make the display effective. (b) Would more than one kind of display be acce
> (a) What kind of display is this? (b) Identify its strengths and weaknesses, using the tips and checklists shown in this chapter. (c) Can you suggest any improvements? Would a different type of display be better? Sales of Sony Blu-Ray Disc Players a
> Daily output of Marathon’s Garyville, Lousiana, refinery is normally distributed with a mean of 232,000 barrels of crude oil per day with a standard deviation of 7,000 barrels. (a) What is the probability of producing at least 232,000 barrels? (b) Betwee
> (a) What kind of display is this? (b) Identify its strengths and weaknesses, using the tips and checklists shown in this chapter. (c) Can you suggest any improvements? Would a different type of display be better? U.S. Consumer Bankruptcies 2,500,000
> (a) What kind of display is this? (b) Identify its strengths and weaknesses, using the tips and checklists shown in this chapter. (c) Can you suggest any improvements? Would a different type of display be better? Residential Fire Damage Claims, 2005
> (a) What kind of display is this? (b) Identify its strengths and weaknesses, using the tips and checklists shown in this chapter. (c) Can you suggest any improvements? Would a different type of display be better? Where Do Advertising Dollars Go? Oth
> (a) Use Excel to prepare a Pareto chart of the following data. (b) Which three service providers account for approximately 80 percent of all responses? Cell Phone Service Provider n = 158 O CellPhone Service Provider Percent Cumulative Percent Veriz
> (a) Use Excel to prepare an appropriate type of chart (bar, line, pie, scatter) to display the following data. Modify the default colors, fonts, etc., as you judge appropriate to make the display effective. (b) Would more than one kind of display be acce
> (a) Use Excel to prepare an appropriate type of chart (bar, line, pie, scatter) to display the following data. Modify the default colors, fonts, etc., as you judge appropriate to make the display effective. (b) Would more than one kind of display be acce
> (a) What kind of display is this? (b) Identify its strengths and weaknesses, using the tips and checklists shown in this chapter. (c) Can you suggest any improvements? Would a different type of display be better? U.S. Birth Rate Plummets! 26 24 22 2
> (a) Use Excel to prepare an appropriate type of chart (bar, line, pie, scatter) to display the following data. Modify the default colors, fonts, etc., as you judge appropriate to make the display effective. (b) Would more than one kind of display be acce
> (a) Use Excel to prepare an appropriate type of chart (bar, line, pie, scatter) to display the following data. Modify the default colors, fonts, etc., as you judge appropriate to make the display effective. (b) Would more than one kind of display be acce
> (a) Use Excel to prepare an appropriate type of chart (bar, line, pie, scatter) to display the following data. Modify the default colors, fonts, etc., as you judge appropriate to make the display effective. (b) Would more than one kind of display be acce
> Find the associated z-score or scores that represent the following standard normal areas. a. Middle 60 percent b. Highest 2 percent c. Middle 95 percent
> (a) What kind of display is this? (b) Identify its strengths and weaknesses, using the tips and checklists shown in this chapter. (c) Can you suggest any improvements? Would a different type of display be better? Sales of Sony Blu-Ray Disc Players a
> (a) What kind of display is this? (b) Identify its strengths and weaknesses, using the tips and checklists shown in this chapter. (c) Can you suggest any improvements? Would a different type of display be better? U.S. Consumer Bankruptcies 2,500,000
> (a) What kind of display is this? (b) Identify its strengths and weaknesses, using the tips and checklists shown in this chapter. (c) Can you suggest any improvements? Would a different type of display be better? Residential Fire Damage Claims, 2005
> (a) What kind of display is this? (b) Identify its strengths and weaknesses, using the tips and checklists shown in this chapter. (c) Can you suggest any improvements? Would a different type of display be better? Where Do Advertising Dollars Go? Oth
> (a) What kind of display is this? (b) Identify its strengths and weaknesses, using the tips and checklists shown in this chapter. (c) Can you suggest any improvements? Would a different type of display be better? U.S. Birth Rate Plummets! 26 24 22 2
> (a) What kind of display is this? (b) Identify its strengths and weaknesses, using the tips and checklists shown in this chapter. (c) Can you suggest any improvements? Would a different type of display be better? Sources of Medical Error Adverse Dru
> Download the full data set from the McGraw-Hill Connect® website (only six data values are shown). (a) Use Excel to make a scatter plot, placing GDP per Capita on the X-axis and Birth Rate on the Y-axis. Add titles and modify the default color
> (a) What kind of display is this? (b) Identify its strengths and weaknesses, using the tips and checklists shown in this chapter. (c) Can you suggest any improvements? Would a different type of display be better? Sources of Medical Error Adverse Dru
> Download the full data set of measurements of cockpit noise level for a commercial jet airliner from the McGraw-Hill Connect® website (only six data values are shown). (a) Use Excel to make a scatter plot, placing Airspeed on the X-axis and No
> Download the full data set from the McGraw-Hill Connect® website (only six data values are shown). (a) Use Excel to make a scatter plot, placing GDP per Capita on the X-axis and Birth Rate on the Y-axis. Add titles and modify the default color
> Find the associated z-score or scores that represent the following standard normal areas. a. Middle 50 percent b. Lowest 5 percent c. Middle 90 percent
> The first Rose Bowl (football) was played in 1902. The next was not played until 1916, but a Rose Bowl has been played every year since then. The margin of victory in each of the 95 Rose Bowls from 1902 through 2011 is shown below (0 indicates a tie). (a
> Download the full data set of measurements of cockpit noise level for a commercial jet airliner from the McGraw-Hill Connect® website (only six data values are shown). (a) Use Excel to make a scatter plot, placing Airspeed on the X-axis and No
> A study of 40 U.S. cardiac care centers showed the following ratios of nurses to beds. (a) Prepare a dot plot. (b) Prepare a frequency distribution and histogram (you may either specify the bins yourself or use automatic bins). (c) Describe the distribut
> (a) Which of these two displays (table or graph) is more helpful in describing the salad sales by Noodles & Company? Why? (b) Write a one-sentence summary of the data. (Source: Noodles & Company) 2005 Average Daily Salads Sold by Month, Noo
> (a) Make an Excel scatter plot of X 5 airspeed (nautical miles per hour) and Y 5 cockpit noise level (decibels) for 61 aircraft flights. (b) Use Excel’s =CORREL function to find the correlation coefficient. (c) What do the graph and correlation coefficie
> (a) Make an Excel scatter plot of X 5 1990 assault rate per 100,000 population and Y 5 2004 assault rate per 100,000 population for the 50 U.S. states. (b) Use Excel’s =CORREL function to find the correlation coefficient. (c) What do the graph and correl
> Households can sign up for a telemarketing “no-call list.” How might households who sign up differ from those who don’t? What biases might this create for telemarketers promoting (a) fi nancial planning services, (b) carpet cleaning services, and (c) vac
> A marketing research group wanted to collect information from existing and potential customers on the appeal of a new product. They sent out surveys to a random sample of 1,200 people from their database of over 25,000 current and potential customers. Wo
> A university wanted to survey alumni about their interest in lifelong learning classes. They mailed questionnaires to a random sample of 600 alumni from their database of over 30,000 recent graduates. Would you consider this population to be effectively
> To protect baby scallops and ensure the survival of the species, the U.S. Fisheries and Wildlife Service requires that an average scallop must weigh at least 1/36 pound. The harbormaster at a Massachusetts port randomly selected 18 bags of scallops from
> Find the associated z-score for each of the following standard normal areas. a. Lowest 6 percent b. Highest 40 percent c. Lowest 7 percent
> After 7 months, none of 238 angioplasty patients who received a drug-coated stent to keep their arteries open had experienced restenosis (re-blocking of the arteries). (a) Use MINITAB to construct a 95 percent binomial confidence interval for the proport
> An experimental medication is administered to 16 people who suffer from migraines. After an hour, 10 say they feel better. Is the medication effective (i.e., is the percent who feel better greater than 50 percent)? Use α = .10, explain fully, and show al
> A quality standard says that no more than 2 percent of the eggs sold in a store may be cracked (not broken, just cracked). In 3 cartons (12 eggs each carton), 2 eggs are cracked. (a) At the .10 level of significance, does this prove that the standard is
> An automaker states that its cars equipped with electronic fuel injection and computerized engine controls will start on the first try (hot or cold) 99 percent of the time. A survey of 100 new car owners revealed that 3 had not started on the first try d
> The historical on-time percentage for Amtrak’s Sunset Limited is 10 percent. In July, the train was on time 0 times in 31 runs. At the .10 level of significance, has the on-time percentage fallen? Explain clearly. Hint: Use Excel to calculate the cumulat
> On a police sergeant’s examination, the historical mean score was 80 with a standard deviation of 20. Four officers who were alleged to be cronies of the police chief scored 195, 171, 191, and 189, respectively, on the test. This led to allegations of ir
> A recent article states that there is a 2 percent chance that an asteroid 100 meters or more in diameter will strike the earth before 2100. Which type of probability (classical, empirical, subjective) do you think this is?
> The U.S. Cesarean section delivery rate in a recent year was estimated at 20.6 percent. Which type of probability (classical, empirical, subjective) do you think this is?
> In the first year after its release, 83 percent of emergency room doctors were estimated to have tried Dermabond glue (an alternative to sutures in some situations). Which type of probability (classical, empirical, subjective) do you think this is?
> Bob says he is 50 percent sure he could swim across the Thames River. Which type of probability (classical, empirical, subjective) do you think this is?
> Find the associated z-score for each of the following standard normal areas. a. Highest 10 percent b. Lowest 50 percent c. Highest 7 percent
