Modern Business Statistics with Microsoft Office Excel 6th Edition by David R. Anderson Solution man

Chapter 1
1 - 4
c.  Questions 1 and 4 provide quantitative data indicating the number of visits and the number of days
in Hawaii. Questions 2 and 3 provide categorical data indicating the categories of reason for the trip
and where the visitor plans to stay.
13. a.  Google revenue in billions of dollars
b. Quantitative
c.  Time series
d. Google revenue is increasing over time.
14. a.  The graph of the time series follows:
b. In Year 1 and Year 2 Hertz was the clear market share leader. In Year 3 and Year 4 Hertz and Avis
have approximately the same market share. The market share for Dollar appears to be declining.
0
50
100
150
200
250
300
350
Year 1 Year 2 Year 3 Year 4
Cars in Service (1000s)
Hertz Dollar Avis
© 2018 Cengage. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
Data and Statistics
1 - 5
c.  The bar chart for Year 4 is shown below.
This chart is based on cross-sectional data.
15. a.  Quantitative
b. Time series
c.  August
d. January
e.  August and January are likely the highest book sales months because of the start of the fall and
spring semesters at colleges and universities.
16.  The answer to this exercise depends on updating the time series of the average price per gallon of
conventional regular gasoline as shown in Figure 1.1. Contact the website www.eia.doe.gov to
obtain the most recent time series data. The answer should focus on the most recent changes or
trend in the average price per gallon.
17. Internal data on salaries of other employees can be obtained from the personnel department.
External data might be obtained from the Department of Labor or industry associations.
18. a.  684/1021; or approximately 67%
b. (.6)*(1021) = 612.6 Therefore, 612 or 613 used an accountant or professional tax preparer.
c.  Categorical
19. a.  All subscribers of Business Week in North America at the time the survey was conducted.
b. Quantitative
c.  Categorical (yes or no)
d. Cross-sectional - all the data relate to the same time.
0
50
100
150
200
250
300
350
Hertz Dollar Avis
Cars in Service (1000s)
Company
© 2018 Cengage. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
Chapter 1
1 - 6
e.  Using the sample results, we could infer or estimate 59% of the population of subscribers have an
annual income of $75,000 or more and 50% of the population of subscribers have an American
Express credit card.
20. a.  43% of managers were bullish or very bullish.
21% of managers expected health care to be the leading industry over the next 12 months.
b. We estimate the average 12-month return estimate for the population of investment managers to be
11.2%.
c.  We estimate the average over the population of investment managers to be 2.5 years.
21. a.  The two populations are the population of women whose mothers took the drug DES during
pregnancy and the population of women whose mothers did not take the drug DES during
pregnancy.
b. It was a survey.
c.  63/3980 = .0158 or 15.8 women out of each 1000 developed tissue abnormalities.
d. The article reported “twice” as many abnormalities in the women whose mothers had taken DES
during pregnancy. Thus, a rough estimate would be 15.8/2 = 7.9 abnormalities per 1000 women
whose mothers had not taken DES during pregnancy.
e.  In many situations, disease occurrences are rare and affect only a small portion of the population.
Large samples are needed to collect data on a reasonable number of cases where the disease exists.
22. a.  The population consists of all clients that currently have a home listed for sale with the agency or
have hired the agency to help them locate a new home.
b. Some of the ways that could be used to collect the data are as follows:
•  A survey could be mailed to each of the agency’s clients.
•  Each client could be sent an email with a survey attached.
•  The next time one of the firm’s agents meets with a client they could conduct a personal
interview to obtain the data.
23. a.  The population is American teens aged 13-17 who own a smartphone.
b. The population is American teens aged 13-17 who do not own a smartphone.
c.  Pew Research conducted a sample survey. It would not be practical to conduct a census as it would
take too much time and money to do so.
24. a.  This is a statistically correct descriptive statistic for the sample.