Solutions Manual for Statistics for Managers Using Microsoft Excel 8th Edition By David Levine, David Stephan, Kathryn Szabat (All Chapters, 100% Original Verified, A+ Grade)

STATISTICS FOR MANAGERS USING MICROSOFT ss ss ss ss




EXCEL 8TH EDITION LEVINE SOLUTIONS
ss ss ss ss ss




MANUAL ss




CHAPTER2:ORGANIZINGANDVISUALIZING s s




VARIABLES
SCENARIO 2-1 ss




An insurance company evaluates many numerical variables about a person before deciding on
ss ss ss ss ss ss ss ss ss ss ss ss


an appropriate rate for automobile insurance. A representative from a local insurance agency
ss ss ss ss ss ss ss ss ss nn ss ss ss


selected a random sample of insured drivers and recorded, X, the number of claims each made
ss ss ss ss ss ss ss ss ss ss ss ss ss ss ss ss


in the last 3 years, with the following results.
ss ss ss ss ss ss ss ss ss


X f
1 14
2 18
3 12
4 5
5 1

1. Referring to Scenario 2-1, how many drivers are represented in the sample?
s ss ss ss ss ss ss ss ss ss ss


a) 5
b) 15
c) 18
d) 50

ANSWER:
d
TYPE: MC DIFFICULTY: Easy
ss ss


KEYWORDS: frequency distribution ss ss




2. Referringto Scenario 2-1, how many total claims are represented in the sample?
s ss ss ss ss ss ss ss ss ss ss ss


a) 15
b) 50

, c) 111
d) 250

ANSWER:
c
TYPE: MC DIFFICULTY: Moderate
ss ss


KEYWORDS: interpretation, frequency distribution
ss ss ss




3. A type of vertical bar chart in which the categories are plotted in the descending rank
ss ss ss ss ss ss ss ss ss ss ss ss ss ss ss


order of the magnitude of their frequencies is called a
ss ss ss ss ss ss ss ss ss ss

, a) contingency table. ss


b) Pareto chart.
ss


c) stem-and-leaf display. ss


d) pie chart.
ss




ANSWER:
b
TYPE: MC DIFFICULTY: Easy
ss ss


KEYWORDS: Pareto chart
ss ss

, SCENARIO 2-2 ss




At a meeting of information systems officers for regional offices of a national company, a survey
ss ss ss ss ss ss ss ss ss ss ss ss ss ss ss


was taken to determine the number of employees the officers supervise in the operation of their
ss ss ss ss ss ss ss ss ss ss ss ss ss ss ss ss


departments, where X is the number of employees overseen by each information
s s ss ss ss ss ss ss ss ss ss ss ss


systems officer.
ss ss


X f_
1 7
2 5
3 11
4 8
5 9

4. Referringto Scenario 2-2, how many regional offices are represented in the survey results?
s ss ss ss ss ss ss ss ss ss ss ss ss


a) 5
b) 11
c) 15
d) 40

ANSWER:
d
TYPE: MC DIFFICULTY: Easy
ss ss


KEYWORDS: interpretation, frequency distribution ss ss ss




5. Referring to Scenario 2-2, across all of the regional offices, how many total
ss ss ss ss ss ss ss ss ss ss ss ss


employees were supervised by those surveyed?
ss ss ss ss ss ss


a) 15
b) 40
c) 127
d) 200

ANSWER:
c
TYPE: MC DIFFICULTY: Moderate
ss ss


KEYWORDS: interpretation, frequency distribution ss ss ss




6. The width of each bar in a histogram corresponds to the
ss ss ss ss ss ss ss ss ss ss


a) differences between the boundaries of the class. ss ss ss ss ss ss


b) number of observations in each class. ss ss ss ss ss


c) midpoint of each class. ss ss ss


d) percentage of observations in each class. nn ss ss ss ss




ANSWER:
a
TYPE: MC DIFFICULTY: Easy
ss ss


KEYWORDS: histogram ss