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
Concept explainers
Videos
Textbook Question
Chapter 2.4, Problem 43E
Store Managers Time Study. The Northwest regional manager of an outdoor equipment retailer conducted a study to determine how managers at three store locations are using their time. A summary of the results are shown in the following table.
- a. Create a stacked bar chart with store location on the horizontal axis and percentage of time spent on each task on the vertical axis.
- b. Create a side-by-side bar chart with store location on the horizontal axis and side-by-side bars of the percentage of time spent on each task.
- c. Which type of bar chart (stacked or side-by-side) do you prefer for these data? Why?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
badly needed right now, please
The average monthly residential gas bill for Black Hills Energy customers in Cheyenne, Wyoming is (Wyoming Public Service Commission website). How is the average monthly gas bill for a Cheyenne residence related to the square footage, number of rooms, and age of the residence? The following data show the average monthly gas bill for last year, square footage, number of rooms, and age for typical Cheyenne residences.
Average Monthly Gas
Number of
Bill for Last Year
Age
Square Footage
Rooms
$70.20
16
2537
6
$81.33
2
3437
8
$45.86
27
976
6
$59.21
11
1713
7
$117.88
16
3979
11
$57.78
2
1328
7
$47.01
27
1251
6
$52.89
4
827
5
$32.90
12
645
4
$67.04
29
2849
5
$76.76
1
2392
7
$60.40
26
900
5
$44.07
14
1386
5
$26.68
20
1299
4
$62.70
17
1441
6
$45.37
13
562
4
$38.09
10
2140
4
$45.31
22
908
6
$52.45
24
1568
5
$96.11
27
1140
10…
If an administrator at a regional hospital wanted to organize the following data, which chart/graph would they select, and why:
a. Inpatient mortality rate (data on how many inpatients have died while in the hospital's care prior to being discharged). Sorted by first-listed diagnosis.
b. Average revenue generated per physician. Sorted by physician.
c. Percent of admitted patients with overnight stays compared to industry average.
Chapter 2 Solutions
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
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
- The data in the table represent the number of licensed drivers in various age groups and the number of fatal accidents within the age group by gender. Complete parts (a) through (c) below. Click the icon to view the data table. ..... (c) Was the number of fatal accidents for 16 to 20 year old males above or below average? Was the number of fatal accidents for 21 to 24 year old males above or below average? Was the number of fatal accidents for males greater than 74 years old above or below average? How might an insurance company use this information? Does the same relationship hold for females? The number of fatal accidents for 16 to 20 year old males was The number of fatal accidents for 21 to 24 year old males was The number of fatal accidents for males greater than 74 years old was An insurance company could use it to argue for higher rates for drivers and lower rates for drivers. Does the same relationship hold for females? Yes Noarrow_forwardSouthwest Airlines had 81.1 million domestic boardings in a recent year, followed by Delta Airlines with 79.4 million, American Airlines with 72.6 million, United Airlines with 56.3 million, Northwest Airlines with 43.3 million, US Airways with 37.8 million, and Continental Airlines with 31.5 million, according to T-100 Domestic Market. Construct a pie chart to depict this information. List down the variable of the above data. Describe whether each variable are qualitative or quantitative data? Explain your answer. Describe the level of measurement for the variables. Explain your answer.arrow_forwardFor each of the hypothetical data sets, determine whether a bar graph or a pie chart would be an appropriate way to display the data. The percent of individuals with each of the following natural hair colors: black, brown, blond, red, and other. The population density of each of the 50 states in the united states The number of college students who play the guitar, the piano, or the trombone. The proportion of traditional public schools in a region compared to the proportion of charter and private k-12 schools in that region.arrow_forward
- Monte recorded the gas mileage, in miles per hour, of ten different cars he is considering buying: 34, 27, 30, 24, 28, 31, 42, 30, 29, and 19. Put the data in a stem-and-leaf plot.arrow_forwardDuPont Automotive releases a Color Popularity Report which provides the percentages of car colors in North America. The most recent report is shown in the following table.arrow_forwardIn a survey, 2400 zoo attendees are asked to choose their favorite. The results are shown in the following table. (a) Find the percentage for each type of animal. Number of zoo attendees Type of animal Percentage % Кoala 216 Jaguar 384 % Anteater 1104 Gorilla 696 (b) Construct a percent bar graph for the data. 25% 25% 25% 25% Drag to adjust 0% 25% 50% 75% 100% Кoala Jaquar Anteater Gorillaarrow_forward
- 3. Make a pie chart using the data below Science Club = 30% Math Club = 40% English Club = 20% History Club = 10%arrow_forwardEach year Money magazine publishes a list of "Best Places to Live in the United States." These listings are based on affordability, educational performance, convenience, safety, and livability. The below table shows the median household income of Money magazine’s top city in each U.S. state for (Money magazine website). Click on the datafile logo to reference the data. City Median Household Income ($) City Median Household Income ($) Pelham, AL 66,772 Bozeman, MT 49,303 Juneau, AK 84,101 Papillion, NE 79,131 Paradise Valley, AZ 138,192 Sparks, NV 54,230 Fayetteville, AR 40,835 Nashua, NH 66,872 Monterey Park, CA 57,419 North Arlington, NJ 73,885 Lone Tree, CO 116,761 Rio Rancho, NM 58,982 Manchester, CT 64,828 Valley Stream, NY 88,693 Hockessin, DE 115,124 Concord, NC 54,579 St. Augustine, FL 47,748 Dickinson, ND 71,866 Vinings, GA 73,103 Wooster, OH 43,054 Kapaa, HI 62,546 Mustang, OK 66,714…arrow_forwardFill out 2 blanksarrow_forward
- Make a Box plot for each data interpreter answer. A. Data a: 2,3,6,4,6,7,8,10arrow_forwardjl. Histogram Access tech supplements, videos, and data sets at www.TriolaStats.com Excel It is extremely difficult to generate histograms in Excel; the XLSTAT add-in should be used: 1. Select the XLSTAT tab in the Ribbon. 2. Click the Visualizing Data button. 3. Select Histograms from the dropdown menu. Tip: To customize, enter the desired class boundaries in a column, select the Options tab, click User Defined, and enter the range of cells containing the boundaries in the box. 2-2 Basic Skills and Concepts Statistical Literacy and Critical Thinking 190108.tt 1. Heights Heights of adult males are normally distributed. If a large sample of heights of adult males is randomly selected and the heights are illustrated in a histogram, what is the shape of that histogram? 2. More Heights The population of heights of adult males is normally distributed. If we obtain a voluntary response sample of 5000 of those heights, will a histogram of the sample heights be bell-shaped? 3. Blood Platelet…arrow_forwardData were gathered from two groups and displayed in the line plots. Data Set A Data Set Barrow_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
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
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
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
The Shape of Data: Distributions: Crash Course Statistics #7; Author: CrashCourse;https://www.youtube.com/watch?v=bPFNxD3Yg6U;License: Standard YouTube License, CC-BY
Shape, Center, and Spread - Module 20.2 (Part 1); Author: Mrmathblog;https://www.youtube.com/watch?v=COaid7O_Gag;License: Standard YouTube License, CC-BY
Shape, Center and Spread; Author: Emily Murdock;https://www.youtube.com/watch?v=_YyW0DSCzpM;License: Standard Youtube License