Essentials of Modern Business Statistics with Microsoft Office Excel (Book Only)
7th Edition
ISBN: 9781337298353
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 1, Problem 14SE
The following data show the number of rental cars in service for three rental car companies: Hertz, Avis, and Dollar, over a four-year period.
a. Construct a time series graph for the years 1 to 4 showing the number of rental cars in service for each company. Show the time series for all three companies on the same graph.
b. Comment on who appears to be the market share leader and how the market shares are changing over time.
c. Construct a bar chart showing rental cars in service for Year 4. Is this chart based on cross-sectional or time series data?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Import Illinois.xls as a table. Using logical indexing to select the years with more than 2800 cases of
Diabetes. Then plot all of the data on the same axis.
F1
fx
Homicide
B
C
E
Year
Accidents
Cancer
Diabetes Heart Disease Homicide|
Suicide
1999
4125
25024
3004
33387
1023
1020
3
2000
4041
25365
2995
31844
991
1003
4.
2001
4077
24778
3092
30990
1087
1139
2002
4222
24737
3011
30821
1016
1145
2003
3942
24464
3044
29816
966
1011
7.
2004
4133
24289
3069
28284
871
1028
8.
2005
4182
24250
3034
28226
866
1086
9.
2006
4451
24084
2795
27007
865
1010
10
2007
4367
24115
2851
25813
863
1108
11
2008
4218
24300
2846
26078
872
1198
12
2009
3961
24185
2741
24931
881
1177
13
2010
3997
24070
2507
24959
783
1178
14
2011
4166
24007
2693
24987
812
1226
15
2012
4488
24562
2706
24667
832
1292
16
2013
4511
24491
2798
17
24839
792
1321
2014
4644
24501
2712
18
25024
792
1398
2015
4850
24713
2817
25652
19
863
1363
20
21
Here are the numbers of robberies in New York City, according to the New York Police Department (NYPD), for 2000 through 2017. Display these data in a graph.
Year:
2000
2001
2002
2003
2004
Count:
32,562
28,202
27,229
25,989
24,373
Year:
2005
2006
2007
2008
2009
Count:
24,722
23,739
21,809
22,401
18,601
Year:
2010
2011
2012
2013
Count:
19,486
19,717
20,144
19,128
Year:
2014
2015
2016
2017
Count:
16,539
16,931
15,500
13,956
Click to download the data in your preferred format.
CSV Excel JMP Mac-Text Minitab PC-Text R SPSS TI CrunchIt!
What are the most important facts that the data show?
The crime rate appears to be leveling off.
The largest percentage decrease in the crime rate was between 2000 and 2001.
In another 17 years, the crime rate will be close to zero.
There were less than half as many robberies in 2017 than there were in 2000.
Robberies decreased overall from 2000 to 2017, with occasional…
A. Movie Theatre Admissions. The following bar graph shows the number of U.S. and Canada
movie theatre admissions for the years from 2007 to 2014.
1.50
1.45
1.40
1.35
1.30
1.25
1.20
0.00
2011
2014
Total U.S. and Canada movie theatre admissions
SOURCE: National Association of Theatre Owners
Question:
1. Estimate the number of admissions for the year 2009. Round to the nearest tenth of a billion.
Answer:
2. Which year had the least number of admissions?
Answer:
3. Which year had the greatest number of admissions?
Answer:
|
B. Determine whether the argument is an example of inductive reasoning or deductive reasoning.
1. Emma enjoyed reading the novel Finders Keepers by Stephen King, so she will enjoy reading his
next novel.
Answer:
2. Every English setter likes to hunt. Duke is an English setter, so Duke likes to hunt.
Answer:
3. All home improvements cost more than the estimate. The contractor estimated that my home
improvement will cost $35,000. Thus my home improvement will cost more…
Chapter 1 Solutions
Essentials of Modern Business Statistics with Microsoft Office Excel (Book Only)
Ch. 1 - Discuss the differences between statistics as...Ch. 1 - Tablet PC Comparison provides a wide variety of...Ch. 1 - Refer to Table 1. 6. a. What is the average cost...Ch. 1 - Table 1. 7 shows data for eight cordless...Ch. 1 - Refer to the data set in Table 1. 7. a. What is...Ch. 1 - J D. Power and Associates surveys new automobile...Ch. 1 - The Kroger Company is one of the largest grocery...Ch. 1 - The Tennessean, an online newspaper located in...Ch. 1 - The Commerce Department reported receiving the...Ch. 1 - The Bureau of Transportation Statistics Omnibus...
Ch. 1 - In a Gallup telephone survey conducted on April...Ch. 1 - The Hawaii Visitors Bureau collects data on...Ch. 1 - Figure 1. 10 provides a bar chart showing the...Ch. 1 - The following data show the number of rental cars...Ch. 1 - The U. S. Census Bureau tracks sales per month for...Ch. 1 - The Energy Information Administration of the U. S....Ch. 1 - A manager of a large corporation recommends a...Ch. 1 - A random telephone survey of 1021 adults (aged 18...Ch. 1 - A Bloomberg Businessweek North American subscriber...Ch. 1 - A survey of 131 investment managers in Barron 's...Ch. 1 - A seven-year medical research study reported that...Ch. 1 - A survey conducted by Better Homes and Gardens...Ch. 1 - Pew Research Center is a nonpartisan polling...Ch. 1 - A sample of midterm grades for five students...Ch. 1 - Table 1. 8 shows a data set containing information...
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
- Pyramid Lake, Nevada, is described as the pride of the Paiute Indian Nation. It is a beautiful desert lake famous for very large trout. The elevation of the lake surface (feet above sea level) varies according to the annual flow of the Truckee River from Lake Tahoe. Assume that the U.S. Geological Survey provided the following data: Year 1986 1987 1988 1989 1990 1991 1992 1993 Elevation 3817 3815 3810 3812 3808 3803 3798 3797 Year 1994 1995 1996 1997 1998 1999 2000 Elevation 3795 3797 3802 3807 3811 3816 3817 Make a time series graph.arrow_forwardThe owner of Backstone Inc. opened 3 stores in different arts of the city and would like to compare the number of sales transactions made after 2months of operation. The number of sales transactions at the 3 stores are displayed in the chart below:arrow_forwardB. Present the following data in Tabular Form. Stat Mountain Bike Shop has sold 50 bicycles the month of January. Similarly, in the month of February 60 bicycles were sold. While in March the sales go down to 45 and 30 in May.arrow_forward
- John Kittle, an independent insurance agent, uses a five-year moving average to forecast the number of claims made in a single year for one of the large insurance companies he sells for. He has just discovered that a clerk in his employ incorrectly entered the number of claims made four years ago as 1,400 when it should have been 1,200.a. What adjustment should Mr. Kittle make in next year’s forecast to take into account the corrected value of the number of claims four years ago?b. Suppose that Mr. Kittle used simple exponential smoothing with a = .2instead of moving averages to determine his forecast. What adjustment is now required in next year’s forecast? (Note that you do not need to know the value of the forecast for next year in order to solve this problem.)arrow_forwardThe creator of a new online multiplayer survival game has been tracking the monthly downloads of the game. The following table shows the monthly downloads (in thousands) for each month of the current and previous year. Click on the datafile logo to reference the data. Month Downloads Month Downloads (previous year) (thousands) (current year) (thousands) February 33.0 January 37.0 March 34.0 February 35.0 April 34.0 March 37.0 May 32.0 April 38.0 June 32.0 May 35.0 July 35.0 June 36.0 August 35.0 July 35.0 September 37.0 August 35.0 October 37.0 September 34.0 November 36.0 October 31.0 December 34.0 Compute the mean, median, and mode for number of downloads in the previous year. Mean (to 3 decimals) thousand Median (to 2 decimal) thousand Mode (to 2 decimal) thousand…arrow_forwardAypee kept track of the number of hours he studied each day for a 3-hour week period. The following observations (in hours) were recorded:Week 1: 1.5, 1.0, 0, 1.4, 0, 2.5, 0.8Week 2: 0.5, 2.0, 0.6, 0, 2.5, 1.8, 3.8Week 3: 0, 1.4, 2.2, 1.4, 0, 3.2, 0 Required: What is the modal number of hours studied per day? What is the median number of hours studied per day? What is the mean number of hours studied per dayarrow_forward
- The side-by-side bar graph available below shows the approximate average grade point average for the years 1991-1992, 1996-1997, 2001-2002, and 2006-2007 for colleges and universities. Complete parts (a) through (c) below. Click the icon to view the side-by-side bar graph. (a) Does the graph suggest that grade inflation is a problem in colleges? A. Yes, because the GPAS increased over time for all schools. B. No, because nothing can be concluded about individual GPAS from the averages. C. No, because the GPAS are different for each time period. D. Yes, because the GPAS are greater for private schools for every time period. (b) In public schools, the average GPA was 2.86 in 1991-1992 and 3.02 in 2006-2007. In private schools, the average GPA was 3.09 in 1991-1992 and 3.30 in 2006-2007. Determine the percentage increase in GPAs for public schools from 1991 to 2006. Determine the percentage increase in GPAs for private schools from 1991 to 2006. Which type of institution appears to have…arrow_forwardThe table below shows the share of income going to each quintile of the income distribution for Neverland in 1980 and 1990. Complete the table below finding the the cumulative share of income for 1980 and 1990 and answer the following: Share of income in Cumulative share of Share of income in Cumulative share of Quintiles 1980 income in 1980 1990 income in 1990 1st 7% 6.6.% 2nd 11.5% 11.5% 3rd 17% 16.3% 4th 24.8% 22.7% 5th 39.7% 42.9% a) Sketch the Perfect Equality line and the Lorenz curve for 1980 and for 1990. Don't forget to label your graph and your curves! b) According to the Lorenz curves that you draw in (a), which year had worse income inequality, 1980 or 1990? JUSTIFY your answer! NOTE: This is a file upload question. Work your answer in a piece of paper, take a picture and upload your file.arrow_forwardThe following graph shows the annual number of car accidents in California. Which of the following statements about the annual number of car accidents is an accurate conclusion? Yearly Car Accidents 180,000 160,000 140,000 120,000 100,000 80,000 60,000 40,000 20,000 2000 2005 Year 1985 1990 1995 2010 2015 2020 e 2018 Glynlyon, Inc. O There is a greater decrease in the annual number of car accidents from 1994 to 1995 than from 1997 to 1998. O There is a smaller decrease in the annual number of car accidents from 1999 to 2000 than from 1997 to 1998. O There is a smaller increase in the annualnumber of car accidents from 1995 to 1996 than from 1998 to 1999. O There is a greater increase in the annual number of car accidents from 1993 to 1994 than from 1996 to 1997. Car Accidentsarrow_forward
- JOYFUL Fashion Company is reviewing the monthly sales in year 2021. each month were as below:The monthly sales (in millions) of Jan: $2.2 Feb: $2.5 Mar: $2.0 Apr: $2.8 May: $1.9 Jun: $0.9Jul: $3.4 Aug: $3.7 Sep: $2.1 Oct: $2.5 Nov: $2.3 Dec: $4.6(a) Find the mean, mode, standard deviation, and range of the above data.(b) Comment on the skewness of the above data. Explain your answer with the comparison of quartiles.The JOYFUL Fashion Company will issue a Gold Membership to customers with accumulated spending in January 2022 over 1% of 2021’s average monthly sales and a Platinum Membership to customers with accumulated spending in January 2022 over 1% of the 80th percentile of 2021’s monthly sales.(c) Mrs. Robinson has spent $27,450 in January 2022. Will she be qualified for the Gold Membership? Will she be qualified for the Platinum Membership? Explain your answers.(d) It is known that the average monthly sales from Jul 2020 to Dec 2020 were $1.9 millions. Find the average monthly…arrow_forwardPark City, Utah was settled as a mining community in 1870 and experienced growth until the late 1950s when the price of silver dropped. In the past 40 years, Park City has experienced new growth as a thriving ski resort. The population data for selected years between 1900 and 2009 are given below. Park City, Utah Year 1900 1930 1940 1950 1970 1980 1990 2000 2009 Population 3759 4281 3739 2254 1193 2823 4468 7341 11983 (a) What behavior of a scatter plot of the data indicates that a cubic model is appropriate? O a change in concavity and neither a relative maximum nor a relative minimum O a change in concavity and both a relative maximum and a relative minimum O no change in concavity and an absolute minimum O no change in concavity and an absolute maximum (b) Align the input so that t = 0 in 1900. Find a cubic model for the data. (Round all numerical values to three decimal places.) p(t) = (c) Numerically estimate the derivative of the model in 2007 to the nearest hundred. p'(107) =…arrow_forwardThe following tables list the ages of female and male actors when they starred in their award-winning Best Actor performances. (A graphing calculator is recommended.) Ages of Best Female Actor Award Recipients 57 76 28 43 54 33 36 42 66 67 60 26 37 62 43 55 73 58 35 44 68 61 27 69 59 34 75 32 74 56 67 33 55 21 Ages of Best Male Actor Award Recipients 45 54 45 61 60 35 43 34 31 68 65 47 30 66 61 33 42 35 51 60 34 42 33 58 72 74 46 36 39 37 48 61 40 76 (a) Find the mean and the sample standard deviation of the ages of the female recipients. Round each result to the nearest tenth. mean sample standard deviation(b) Find the mean and the sample standard deviation of the ages of the male recipients. Round each result to the nearest tenth. mean sample deviation(c) Which of the two data sets has the larger mean? female actors or male actors Which of the two data sets has the larger…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
Time Series Analysis Theory & Uni-variate Forecasting Techniques; Author: Analytics University;https://www.youtube.com/watch?v=_X5q9FYLGxM;License: Standard YouTube License, CC-BY
Operations management 101: Time-series, forecasting introduction; Author: Brandoz Foltz;https://www.youtube.com/watch?v=EaqZP36ool8;License: Standard YouTube License, CC-BY