Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card)
6th Edition
ISBN: 9780357191484
Author: David R. Anderson; Dennis J. Sweeney; Thomas A. Williams
Publisher: Cengage Learning US
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 2.1, Problem 10E
VirtualTourist provides ratings for hotels throughout the world. Ratings provided by 649 guests at the Sheraton Anaheim Hotel, located near the Disneyland Resort in Anaheim. California, can be found in the DATAfile named HotelRatings (VirtualTourist website, February 25, 2013). Possible responses were Excellent, Very Good, Average. Poor, and Terrible.
- a. Construct a frequency distribution.
- b. Construct a percent frequency distribution.
- c. Construct a bar chart for the percent frequency distribution.
- d. Comment on how guests rate their stay at the Sheraton Anaheim Hotel.
- e. c. Results for 1679 guests who stayed at Disney's Grand Californian provided the following frequency distribution.
Compare the ratings for Disney’s Grand Californian with the results obtained for the Sheraton Anaheim Hotel.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
The college hiking club is having a fundraiser to buy new equipment for fall and winter outings. The club is selling Chinese fortune cookies at a price of $2 per cookie. Each cookie contains a piece of paper with a different number written on it. A random drawing will determine which number is the winner of a dinner for two at a local Chinese restaurant. The dinner is valued at $32. Since fortune cookies are donated to the club, we can ignore the cost of the cookies. The club sold 718 cookies before the drawing. Lisa bought 13 cookies. Lisa's expected earnings can be found by multiplying the value of the dinner by the probability that she will win. What are Lisa's expected earnings? Round your answer to the nearest cent.
The Honolulu Advertiser stated that in Honolulu there was an average of 659 burglaries per 400,000 households in a given year. In the Kohola Drive neighborhood there are 321 homes. Let r be the number of homes that will be burglarized in a year. Use the formula for Poisson distribution. What is the value of p, the probability of success, to four decimal places?
The college hiking club is having a fundraiser to buy new equipment for fall and winter outings. The club is selling Chinese fortune cookies at a price of $2 per cookie. Each cookie contains a piece of paper with a different number written on it. A random drawing will determine which number is the winner of a dinner for two at a local Chinese restaurant. The dinner is valued at $32. Since fortune cookies are donated to the club, we can ignore the cost of the cookies. The club sold 718 cookies before the drawing. Lisa bought 13 cookies. Lisa's expected earnings can be found by multiplying the value of the dinner by the probability that she will win. What are Lisa's expected earnings? Round your answer to the nearest cent.
Chapter 2 Solutions
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card)
Ch. 2.1 - Methods
1. The response to a question has three...Ch. 2.1 - 2. A partial relative frequency distribution is...Ch. 2.1 - A questionnaire provides 58 Yes, 42 No, and 20...Ch. 2.1 -
For the 2010–2011 viewing season, the top five...Ch. 2.1 -
In alphabetical order, the six most common last...Ch. 2.1 - Top Rated Television Show Networks. Nielsen Media...Ch. 2.1 - Airline Customer Satisfaction Survey. Many...Ch. 2.1 - Prob. 8ECh. 2.1 - Prob. 9ECh. 2.1 -
VirtualTourist provides ratings for hotels...
Ch. 2.2 - 11. Consider the following data.
Develop a...Ch. 2.2 - 12. Consider the following frequency...Ch. 2.2 - Construct a histogram for the data in exercise...Ch. 2.2 - Prob. 14ECh. 2.2 - Construct a stem-and-leaf display for the...Ch. 2.2 - Construct a stem-and-leaf display for the...Ch. 2.2 - Applications
17. A doctor’s office staff studied...Ch. 2.2 - NBA Total Player Ratings. CBSSports.com developed...Ch. 2.2 - Prob. 19ECh. 2.2 - CEO Time in Meetings. The London School of...Ch. 2.2 - Quantcast.com provides the number of people from...Ch. 2.2 - Top U.S. Franchises. Entrepreneur magazine ranks...Ch. 2.2 - Prob. 24ECh. 2.2 - Best Paying College Degrees. Each year America.EDU...Ch. 2.2 - Prob. 26ECh. 2.3 - The following data are for 30 observations...Ch. 2.3 - The following observations are for two...Ch. 2.3 - Daytona 500 Automobile Makes Average Speeds. The...Ch. 2.3 - Daytona 500 Average Speeds of Winners. The...Ch. 2.3 - 31. Recently, management at Oak Tree Golf Course...Ch. 2.3 - Household Income Levels. The following...Ch. 2.3 - 33. Each year Forbes ranks the world’s most...Ch. 2.3 - Prob. 34ECh. 2.3 -
The U.S. Department of Energy's Fuel Economy...Ch. 2.4 - The following 20 observations are for two...Ch. 2.4 - Prob. 37ECh. 2.4 - The following crosstabulation summarizes the data...Ch. 2.4 - Driving Speed and Fuel Efficiency. A study on...Ch. 2.4 - The DATAfile Snow contains average annual snowfall...Ch. 2.4 - Hypertension and Heart Disease. People often wait...Ch. 2.4 -
Smartphones are mobile phones with Internet,...Ch. 2.4 - Store Managers Time Study. The Northwest regional...Ch. 2 - SAT Scores. The SAT is a standardized test used by...Ch. 2 - Median Household Incomes. The file MedianHousehold...Ch. 2 - State Populations. Data showing the population by...Ch. 2 - Startup Company Funds. According to the Wall...Ch. 2 - Complaints Reported to BBB. Consumer complaints...Ch. 2 - Stock Price Volatility. The term “beta” refers to...Ch. 2 - Education Level and Household Income. The U.S....Ch. 2 - Prob. 51SECh. 2 - Best Places to Work. Fortune magazine publishes an...Ch. 2 - Prob. 53SECh. 2 - Prob. 54SECh. 2 - Prob. 55SECh. 2 - Prob. 56SECh. 2 -
Google has changed its strategy with regard to...Ch. 2 -
A zoo has categorized its visitors into three...Ch. 2 - Pelican Stores, a division of National Clothing,...Ch. 2 -
Motion Picture Industry
The motion picture...Ch. 2 - Cincinnati, Ohio, also known as the Queen City,...Ch. 2 - Jon Weideman, first shift foreman for Cut-Rate...
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
- What was the age distribution of nurses in Great Britain at the time of Florence Nightingale? Thanks to Florence Nightingale and the British census of 1851, we have the following information (based on data from the classic text Notes on Nursing, by Florence Nightingale). Note: In 1851 there were 25,466 nurses in Great Britain. Furthermore, Nightingale made a strict distinction between nurses and domestic servants. Use a histogram and graph the probability distribution. Using the graph of the probability distribution determine the probability that a British nurse selected at random in 1851 would be 40 years of age or older. Round your answer to nearest thousandth. Age range (yr) 20–29 30–39 40–49 50–59 60–69 70–79 80+ Midpoint (x) 24.5 34.5 44.5 54.5 64.5 74.5 84.5 Percent of nurses 5.7% 9.7% 19.5% 29.2% 25.0% 9.1% 1.8%arrow_forwardWhat was the age distribution of nurses in Great Britain at the time of Florence Nightingale? Thanks to Florence Nightingale and the British census of 1851, we have the following information (based on data from the classic text Notes on Nursing, by Florence Nightingale). Note: In 1851 there were 25,466 nurses in Great Britain. Furthermore, Nightingale made a strict distinction between nurses and domestic servants. Use a histogram and graph the probability distribution. Using the graph of the probability distribution determine the probability that a British nurse selected at random in 1851 would be 40 years of age or older. Round your answer to nearest thousandth. Age range (yr) 20–29 30–39 40–49 50–59 60–69 70–79 80+ Midpoint (x) 24.5 34.5 44.5 54.5 64.5 74.5 84.5 Percent of nurses 5.7% 9.7% 19.5% 29.2% 25.0% 9.1% 1.8%arrow_forwardThere are 4 radar stations and the probability of a single radar station detecting an enemy plane is 0.55. Make a histogram for the probability distribution.arrow_forward
- show all stepsarrow_forwardMost people know that the probability of getting a head when you flip a fair coin is . You want to use the relative frequency of the event to show that the probability is . How many times should you simulate flipping the coin in the experiment? Would it be better to use 300 trials or 3000 trials? Explain.arrow_forwardThe qualified applicant pool for eight management trainee positions consists of ten women and six men. How many different groups of applicants can be selected for the positionsarrow_forward
- You want to make a salad from whatever vegetable you have in the fridge. You have seven different tomatoes. There are 2 red tomatoes, 4 yellow tomatoes, and one black tomato in the fridge. You have three different bell peppers. There is 1 red pepper, 1 yellow pepper, and 1 green pepper. What is the probability of randomly choosing a vegetable and getting a red tomato, and a green pepper? Round your answer to four decimal places.arrow_forwarduppose automobile insurance companies gave annual premiums for top-rated companies in several states. The figure below shows box plots for the annual premium for urban customers in three states. Which state offers the lowest premium? Which state offers the highest premium?arrow_forwardWing Foot is a shoe franchise commonly found in shopping centers across the United States. Wing Foot knows that its stores will not show a profit unless they gross over $940,000 per year. Let A be the event that a new Wing Foot store grosses over $940,000 its first year. Let B be the event that a store grosses over $940,000 its second year. Wing Foot has an administrative policy of closing a new store if it does not show a profit in either of the first two years. Assume that the accounting office at Wing Foot provided the following information: 58% of all Wing Foot stores show a profit the first year; 72% of all Wing Foot store show a profit the second year (this includes stores that did not show a profit the first year); however, 86% of Wing Foot stores that showed a profit the first year also showed a profit the second year. Compute P(B|Ac). Round your answer to the nearest hundredth.arrow_forward
- You draw two cards from a standard deck of 52 cards, but before you draw the second card, you put the first one back and reshuffle the deck. If you get a3on the first card, find the probability of drawing a 3 for the second card.arrow_forwardDo bonds reduce the overall risk of an investment portfolio? Let x be a random variable representing annual percent return for the Vanguard Total Stock Index (all Stocks). Let y be a random variable representing annual return for the Vanguard Balanced Index (60% stock and 40% bond). For the past several years, assume the following data. Compute the coefficient of variation for each fund. Round your answers to the nearest tenth. x: 14 0 37 21 35 23 24 -14 -14 -17 y: 8 -2 29 17 22 17 17 -2 -3 -8arrow_forwardWhat percentage of the general U.S. population have bachelor's degrees? Suppose that the Statistical Abstract of the United States, 120th Edition, gives the following percentage of bachelor’s degrees by state. For convenience, the data are sorted in increasing order. 17 18 18 18 19 20 20 20 21 21 21 21 21 22 22 22 22 22 23 23 24 24 24 24 24 25 25 25 25 26 26 26 26 26 26 27 27 27 28 28 28 29 29 31 31 32 32 34 35 38 Illinois has a bachelor's degree percentage rate of about 18%. Into what quartile does this rate fall?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Which is the best chart: Selecting among 14 types of charts Part II; Author: 365 Data Science;https://www.youtube.com/watch?v=qGaIB-bRn-A;License: Standard YouTube License, CC-BY