Essentials Of Modern Business Statistics With Microsoft Excel, Loose-leaf Version
7th Edition
ISBN: 9781337298308
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 2, Problem 2.3.1CP
Case Problem 3 Queen City
Cincinnati, Ohio, also known as the Queen City, has a population of approximately 298,000 and is the third largest city in the state of Ohio. The Cincinnati metropolitan area has a population of about 2.2 million. The city is governed by a mayor and a nine-member city council. The city manager, who is responsible for the day-to-day operation of the city, reports to the mayor and city council. The city manager recently created the Office of Performance and Data Analytics with the goal of improving the efficiency of city operations. One of the first tasks of this new office is to review the previous year's expenditures. The file QueenCity contains data on the previous year's expenditures, including the following:
Department The number of the department incurring the expenditure
Department Description The name of the department incurring the description
Category The category of the expenditure
Fund The fund to which the expenditure was charged
Expenditure The dollar amount of the expense
DATA file QueenCity Table 2.21 shows the first four entries of the 5427 expenditures for the year. The city manager would like to use this data to better understand how the city's budget is being spent.
Managerial Report
Use tabular and graphical methods of
l. Tables and/or graphical displays that show the amount of expenditures by category and percentage of total expenditures by category.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Example 4 (Part 2) We can use Statkey to take 50 different random samples of size 20 each, find the mean of
each sample, and compute a confidence interval for each one. The graph of the sampling distribution of the means
is on the left below, and that of the 50 confidence intervals is on the right.
1. What does each dot on the left hand dotplot represent?
StatKey Sampling Distribution for a Mean
Percent with Internet Access (Countries) ▾
Show Data Table Edit Data
Choose samples of size n =
20
Upload File
Change Column(s)
Generate 1 Sample
Generate 10 Samples
Generate 100 Samples
Generate 1000 Samples
Reset Plot
Sampling Dotplot of Mean
Left Tail Two-Tail Right Tail
60
50
40
40
30
20
20
10
samples = 50
mean = 41.626
std. error = 5.089
:
.:
:
::
0
25
30
35
40
45
50
55
60
41.626
Data Plots
Confidence Intervals
95%->
Confidence Intervals
Coverage
48/50 = 96%
20
40
60
80
2. Circle the confidence intervals that failed to capture the true mean.
3. Circle the sample means that produced those…
Example 4 (Part 1) One of the datasets in the Lock book
contains information about 215 countries of the world. One
of the variables is the percentage of people in the country
who have access to the internet. We have data for 203 of
those countries. The plot on the right shows a dotplot of
the data.
1. What are the cases?
Population
n = 203, mean = 43.024
median = 43.5, stdev = 29.259
20
2. What does each dot on the dotplot represent?
15
10
5
20
40
43.024
60
80
3. What type of data is do we collect from the cases, quantitative or categorical?
Let x be a random variable that represents the percentage of successful free throws a professional basketball player makes in a season. Let y be a random variable that represents the percentage of successful field goals a professional basketball player makes in a season. A random sample of n =6 professional basketball players gave the following information.
x
63
79
70
80
84
87
y
46
49
45
55
57
58
Find Se. Round your answer to three decimal places.
Chapter 2 Solutions
Essentials Of Modern Business Statistics With Microsoft Excel, Loose-leaf Version
Ch. 2.1 - The response to a question has three alternatives:...Ch. 2.1 - A partial relative frequency distribution is...Ch. 2.1 - A questionnaire provides 58 Yes, 42 No, and 20...Ch. 2.1 - Prob. 4ECh. 2.1 - In alphabetical order, the six most common last...Ch. 2.1 - Nielsen Media Research provided the list of the 25...Ch. 2.1 - The Canmark Research Center Airport Customer...Ch. 2.1 - Prob. 8ECh. 2.1 - Nearly 1.8 million bachelor's degrees and over...Ch. 2.1 - VirtualTourist provides ratings for hotels...
Ch. 2.2 - Consider the following data. a. Develop a...Ch. 2.2 - Consider the following frequency distribution...Ch. 2.2 - Prob. 13ECh. 2.2 - Prob. 14ECh. 2.2 - Prob. 15ECh. 2.2 - Construct a stem-and-leaf display for the...Ch. 2.2 - A doctor's office staff studied the waiting times...Ch. 2.2 - CBSSports.com developed the Total Player Ratings...Ch. 2.2 - Based on the tons handled in a year, the ports...Ch. 2.2 - The London School of Economics and the Harvard...Ch. 2.2 - Quantcast.com provides the number of people from...Ch. 2.2 - Entrepreneur magazine ranks franchises using...Ch. 2.2 - The following data show the year-to-date percent...Ch. 2.2 - Prob. 24ECh. 2.2 - Prob. 25ECh. 2.2 - The Flying Pig Half-Marathon (13.1 miles) had...Ch. 2.3 - The following data are for 30 observations...Ch. 2.3 - The following observations are for two...Ch. 2.3 - The Daytona 500 is a 500-mile automobile race held...Ch. 2.3 - The following crosstabulation shows the average...Ch. 2.3 - Prob. 31ECh. 2.3 - The following crosstabulation shows the number of...Ch. 2.4 - Prob. 36ECh. 2.4 - Consider the following data on two categorical...Ch. 2.4 - Prob. 38ECh. 2.4 - Prob. 39ECh. 2.4 - Prob. 40ECh. 2.4 - Prob. 41ECh. 2.4 - Prob. 42ECh. 2.4 - The Northwest regional manager of an outdoor...Ch. 2 - Approximately 1.5 million high school students...Ch. 2 - Data showing the population by state in millions...Ch. 2 - A startup company's ability to gain funding is a...Ch. 2 - Prob. 49SECh. 2 - Prob. 50SECh. 2 - Western University has only one women's softball...Ch. 2 - Prob. 53SECh. 2 - Prob. 57SECh. 2 - A zoo has categorized its visitors into three...Ch. 2 - Pelican Stores, a division of National Clothing,...Ch. 2 - Prob. 2.1.2CPCh. 2 - Pelican Stores, a division of National Clothing,...Ch. 2 - Pelican Stores, a division of National Clothing,...Ch. 2 - Case Problem 2Motion Picture Industry The motion...Ch. 2 - Prob. 2.2.2CPCh. 2 - Case Problem 2 Motion Picture Industry The motion...Ch. 2 - Case Problem 2 Motion Picture Industry The motion...Ch. 2 - Case Problem 3Queen City Cincinnati, Ohio, also...Ch. 2 - Case Problem 3Queen City Cincinnati, Ohio, also...Ch. 2 - Case Problem 3Queen City Cincinnati, Ohio, also...Ch. 2 - Case Problem 4Cut-Rate Machining, Inc. Jon...Ch. 2 - Case Problem 4Cut-Rate Machining, Inc. Jon...Ch. 2 - Case Problem 4Cut-Rate Machining, Inc. Jon...
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
- 1. Define probability: 2. Define statistics:arrow_forwardResults of tossing a coin four times: H, H, H, H How many times is the Coin expected to come up heads? How did you determine this number? Calculate the % deviation. Can these results be used to conclude that a coin is not fair? Why or why not?arrow_forwardCycles to failure Position in ascending order 0.5 f(x)) (x;) Problem 44 Marsha, a renowned cake scientist, is trying to determine how long different cakes can survive intense fork attacks before collapsing into crumbs. To simulate real-world cake consumption, she designs a test where cakes are subjected to repeated fork stabs and bites, mimicking the brutal reality of birthday parties. After rigorous testing, Marsha records 10 observations of how many stabs each cake endured before structural failure. Construct P-P plots for (a.) a normal distribution, (b.) a lognormal distribution, and (c.) a Weibull distribution (using the information included in the table below). Which distribution seems to be the best model for the cycles to failure for this material? Explain your answer in detail. Observation Empirical cumulative Probability distribution Cumulative distribution Inverse of cumulative distribution F-1 (-0.5) F(x)) (S) n 4 3 1 0.05 9 5 2 0.15 7 7 3 0.25 1 10 4 0.35 3 12 5 0.45 Normal…arrow_forward
- Problem 3 In their lab, engineer Daniel and Paulina are desperately trying to perfect time travel. But the problem is that their machine still struggles with power inconsistencies-sometimes generating too little energy, other times too much, causing unstable time jumps. To prevent catastrophic misjumps into the Jurassic era or the far future, they must calibrate the machine's power output. After extensive testing, they found that the time machine's power output follows a normal distribution, with an average energy level of 8.7 gigawatts and a standard deviation of 1.2 gigawatts. The Time Travel Safety Board has set strict guidelines: For a successful time jump, the machine's power must be between 8.5 and 9.5 gigawatts. What is the probability that a randomly selected time jump meets this precision requirement? Daniel suggests that adjusting the mean power output could improve time-travel accuracy. Can adjusting the mean reduce the number of dangerous misjumps? If yes, what should the…arrow_forwardProblem 5 ( Marybeth is also interested in the experiment from Problem 2 (associated with the enhancements for Captain America's shield), so she decides to start a detailed literature review on the subject. Among others, she found a paper where they used a 2"(4-1) fractional factorial design in the factors: (A) shield material, (B) throwing mechanism, (C) edge modification, and (D) handle adjustment. The experimental design used in the paper is shown in the table below. a. Run A B с D 1 (1) -1 -1 -1 1 2 a 1 -1 -1 1 3 bd -1 1 -1 1 4 abd 1 1 -1 1 5 cd -1 -1 1 -1 6 acd 1 -1 1 -1 7 bc -1 1 1 -1 abc 1 1 1 -1 paper? s) What was the generator used in the 2"(4-1) fractional factorial design described in the b. Based on the resolution of this design, what do you think about the generator used in the paper? Do you think it was a good choice, or would you have selected a different one? Explain your answer in detail.arrow_forwardSuppose we wish to test the hypothesis that women with a sister’s history of breast cancer are at higher risk of developing breast cancer themselves. Suppose we assume that the prevalence rate of breast cancer is 3% among 60- to 64-year-old U.S. women, whereas it is 5% among women with a sister history. We propose to interview 400 women 40 to 64 years of age with a sister history of the disease. What is the power of such a study assuming that the level of significance is 10%? I only need help writing the null and alternative hypotheses.arrow_forward
- 4.96 The breaking strengths for 1-foot-square samples of a particular synthetic fabric are approximately normally distributed with a mean of 2,250 pounds per square inch (psi) and a standard deviation of 10.2 psi. Find the probability of selecting a 1-foot-square sample of material at random that on testing would have a breaking strength in excess of 2,265 psi.4.97 Refer to Exercise 4.96. Suppose that a new synthetic fabric has been developed that may have a different mean breaking strength. A random sample of 15 1-foot sections is obtained, and each section is tested for breaking strength. If we assume that the population standard deviation for the new fabric is identical to that for the old fabric, describe the sampling distribution forybased on random samples of 15 1-foot sections of new fabricarrow_forwardUne Entreprise œuvrant dans le domaine du multividéo donne l'opportunité à ses programmeurs-analystes d'évaluer la performance des cadres supérieurs. Voici les résultats obtenues (sur une échelle de 10 à 50) où 50 représentent une excellente performance. 10 programmeurs furent sélectionnés au hazard pour évaluer deux cadres. Un rapport Excel est également fourni. Programmeurs Cadre A Cadre B 1 34 36 2 32 34 3 18 19 33 38 19 21 21 23 7 35 34 8 20 20 9 34 34 10 36 34 Test d'égalité des espérances: observations pairéesarrow_forwardA television news channel samples 25 gas stations from its local area and uses the results to estimate the average gas price for the state. What’s wrong with its margin of error?arrow_forward
- You’re fed up with keeping Fido locked inside, so you conduct a mail survey to find out people’s opinions on the new dog barking ordinance in a certain city. Of the 10,000 people who receive surveys, 1,000 respond, and only 80 are in favor of it. You calculate the margin of error to be 1.2 percent. Explain why this reported margin of error is misleading.arrow_forwardYou find out that the dietary scale you use each day is off by a factor of 2 ounces (over — at least that’s what you say!). The margin of error for your scale was plus or minus 0.5 ounces before you found this out. What’s the margin of error now?arrow_forwardSuppose that Sue and Bill each make a confidence interval out of the same data set, but Sue wants a confidence level of 80 percent compared to Bill’s 90 percent. How do their margins of error compare?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons Inc
Probability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage Learning
Statistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSON
The Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. Freeman
Introduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman
Solve ANY Optimization Problem in 5 Steps w/ Examples. What are they and How do you solve them?; Author: Ace Tutors;https://www.youtube.com/watch?v=BfOSKc_sncg;License: Standard YouTube License, CC-BY
Types of solution in LPP|Basic|Multiple solution|Unbounded|Infeasible|GTU|Special case of LP problem; Author: Mechanical Engineering Management;https://www.youtube.com/watch?v=F-D2WICq8Sk;License: Standard YouTube License, CC-BY
Optimization Problems in Calculus; Author: Professor Dave Explains;https://www.youtube.com/watch?v=q1U6AmIa_uQ;License: Standard YouTube License, CC-BY
Introduction to Optimization; Author: Math with Dr. Claire;https://www.youtube.com/watch?v=YLzgYm2tN8E;License: Standard YouTube License, CC-BY