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)

2-1 Organizing and Visualizing Variables
nn ss ss Organizing and Visualizing Variables ss ss nn 2-1


Statistics forManagers Using Microsoft Excel 8th Edition Levine
ss s ss ss ss ss ss ss




SOLUTIONS MANUAL
ss ss




CHAPTER2:ORGANIZINGANDVISUALIZING s s




VARIABLES
SCENARIO 2-1 ss




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



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



random sample of insured drivers and recorded, X, the number of claims each made in the last 3
ss ss ss ss ss ss ss ss ss ss ss ss ss ss ss ss ss ss



years, with the following results.
ss ss ss ss ss



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

1. Referringto Scenario 2-1, how many drivers are representedin the sample?
s ss ss ss ss ss ss ss s 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 descendingrank order of
ss ss ss ss ss ss ss ss ss s ss ss ss ss s ss ss



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




o©p2y0r1ig7hPt
n s s ns s


e©a2rs0o1n7EPdeuacrsaotinonE,dIuncca.tion,

,2-2 Organizing and Visualizing Variables
nn ss ss Organizing and Visualizing Variables
ss ss nn 2-2

a) contingency table. ss



b) Pareto chart.
ss



c) stem-and-leaf display. s s



d) pie chart.
ss




ANSWER:
b
TYPE: MC DIFFICULTY: Easy
ss ss



KEYWORDS: Pareto chart ss ss




o©p2y0r1ig7hPt
n s s ns s


e©a2rs0o1n7EPdeuacrsaotinonE,dIuncca.tion,

,2-3 Organizing and Visualizing Variables nn ss ss Organizing and Visualizing Variablesss ss nn 2-3




SCENARIO 2-2 ss




At a meeting of informationsystems officers for regional offices of a national company, a survey was
ss ss ss ss s ss ss ss ss ss ss ss ss ss ss ss



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



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



officer.
s s



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 s 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 employees
ss ss ss ss ss ss ss ss ss ss ss ss ss



were supervised by those surveyed?
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 s s s s ss ss s s



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



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



c) midpoint of each class. ss ss ss



d) percentage of observationsin each class. nn ss s ss ss




ANSWER:
a
TYPE: MC DIFFICULTY: Easy
ss ss



KEYWORDS: histogram ss




o©p2y0r1ig7hPt
n s s ns s


e©a2rs0o1n7EPdeuacrsaotinonE,dIuncca.tion,

, 2-4 Organizing and Visualizing Variables
nn ss ss Organizing and Visualizing Variables ss ss nn 2-4




SCENARIO 2-3 ss




Every spring semester, the School of Business coordinates a luncheon with local business leaders
ss ss ss ss ss ss ss ss ss ss ss ss ss



for graduating seniors, their families, and friends. Corporate sponsorship pays for the lunches of
ss ss ss ss ss ss ss ss ss ss ss ss ss ss



each of the seniors, but students have to purchase tickets to cover the cost of lunches
ss ss ss ss s s s s ss ss ss ss s s ss ss s s ss s s



served to guests they bring with them. The following histogram represents the attendance at the
s s s s ss s s s s ss ss ss ss s nn ss ss ss ss



senior luncheon, where X is the number of guests each graduating senior invited to the luncheon
ss ss s ss ss ss ss ss ss ss ss ss ss ss ss ss



and f is the number of graduating seniors in each category.
ss ss ss ss ss ss ss ss ss ss ss




20 17
3

0 1 2 3 4
Guests
p



7. Referring to the histogramfrom Scenario 2-3, how many graduatingseniors attended the
ss ss ss s ss ss ss ss ss s ss ss



luncheon? ss



a) 4
b) 152
c) 275
d) 388

ANSWER:
c
TYPE: MC DIFFICULTY: Difficult
ss ss



EXPLANATION:The number of graduatingseniors is the sum of all the frequencies, f. s ss ss ss s ss ss ss ss ss ss ss s



KEYWORDS: interpretation, histogram
ss ss ss




8. Referring to the histogramfrom Scenario 2-3, if all the tickets purchased were used, how
ss ss ss s ss ss ss ss ss ss ss ss ss ss



many guests attended the luncheon?
ss ss ss ss ss



a) 4
b) 152
c) 275
d) 388
ANSWER
ss TYPE: MC DIFFICULTY: Difficult ss ss



: EXPLANATION:Thetotal number of guests is s s ss ss ss s

d
KEYWORDS: interpretation, histogram ss ss ss




o©p2y0r1ig7hPt
n s s ns s


e©a2rs0o1n7EPdeuacrsaotinonE,dIuncca.tion,