Test bank for Statistics for managers using microsoft excel 8th edition levine solutions manual

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


Statistics for Managers Using Microsoft Excel 8th Edition Levine
nn nn nn nn nn nn nn nn




SOLUTIONS MANUAL
nn nn




Full download at:
nn nn




https://testbankreal.com/download/statistics-for-managers-using-microsoft-
excel-8th-edition-levine-solutions-manual/
nn




CHAPTER 2: ORGANIZING AND VISUALIZING nn nn nn nn




VARIABLES nn




SCENARIO 2-1 nn




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



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



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



years, with the following results.
nn nn nn nn nn



Xn nf n n



1 14
2 18
3 12
4 5
5 1

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



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

ANSWER:
d
TYPE: MC DIFFICULTY: Easy
nn n n nn



KEYWORDS: frequency distribution nn nn




2. Referring to Scenario 2-1, how many total claims are represented in the sample?
nn nn nn nn nn nn nn nn nn nn nn nn



a) 15
b) 50
c) 111
d) 250

ANSWER:
c
TYPE: MC DIFFICULTY: Moderate
nn n n nn



KEYWORDS: interpretation, frequency distribution nn nn nn




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



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




CopyrighC
t o©p2y0r1ig7hPt e©a2rs0o1n7EPdeuacrsaotinonE,dIuncca.tion,
n n n n


Inc.

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

a) contingency table. nn



b) Pareto chart. nn



c) stem-and-leaf display. nn



d) pie chart. nn




ANSWER:
b
TYPE: MC DIFFICULTY: Easy
nn n n nn



KEYWORDS: Pareto chart nn nn




CopyrighC
t o©p2y0r1ig7hPt e©a2rs0o1n7EPdeuacrsaotinonE,dIuncca.tion,
n n n n


Inc.

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




SCENARIO 2-2 nn




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



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



departments, where X is the number of employees overseen by each information systems officer.
nn nn nn nn nn nn nn nn nn nn nn nn nn nn



X f_ n n



1 7
2 5
3 11
4 8
5 9

4. Referring to Scenario 2-2, how many regional offices are represented in the survey results?
nn nn nn nn nn nn nn nn nn nn nn nn nn



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

ANSWER:
d
TYPE: MC DIFFICULTY: Easy
nn n n nn



KEYWORDS: interpretation, frequency distribution nn nn nn




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



were supervised by those surveyed?
nn nn nn nn nn



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

ANSWER:
c
TYPE: MC DIFFICULTY: Moderate
nn n n nn



KEYWORDS: interpretation, frequency distribution nn nn nn




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



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



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



c) midpoint of each class. nn nn nn



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




ANSWER:
a
TYPE: MC DIFFICULTY: Easy
nn n n nn



KEYWORDS: histogram nn




CopyrighC
t o©p2y0r1ig7hPt e©a2rs0o1n7EPdeuacrsaotinonE,dIuncca.tion,
n n n n


Inc.

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




SCENARIO 2-3 nn




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



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



each of the seniors, but students have to purchase tickets to cover the cost of lunches served to
nn nn nn nn nn nn nn nn nn nn nn nn nn nn nn nn nn nn



guests they bring with them. The following histogram represents the attendance at the senior
nn nn nn nn nn nn nn nn nn nn nn nn nn nn



luncheon, where X is the number of guests each graduating senior invited to the luncheon and f is
nn nn nn nn nn nn nn nn nn nn nn nn nn nn nn nn nn nn



the number of graduating seniors in each category.
nn nn nn nn nn nn nn nn




20 17
3

0 1 2 3 4
Guests n n p nn




7. Referring to the histogram from Scenario 2-3, how many graduating seniors attended the
nn nn nn nn nn nn nn nn nn nn nn nn



luncheon?
nn



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

ANSWER:
c
TYPE: MC DIFFICULTY: Difficult
nn n n nn



EXPLANATION: The number of graduating seniors is the sum of all the frequencies, f.
nn nn nn nn nn nn nn nn nn nn nn nn nn



KEYWORDS: interpretation, histogram
nn nn nn




8. Referring to the histogram from Scenario 2-3, if all the tickets purchased were used, how
nn nn nn nn nn nn nn nn nn nn nn nn nn nn



many guests attended the luncheon?
nn nn nn nn nn



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



d EXPLANATION: The total number of guests is nn nn nn nn nn nn




KEYWORDS: interpretation, histogram
nn nn nn




CopyrighC
t o©p2y0r1ig7hPt e©a2rs0o1n7EPdeuacrsaotinonE,dIuncca.tion,
n n n n


Inc.