OrganizingkandkVisualizingkVariables 2-1
Test Bank for Statistics for Managers Using Mi
k k k k k k k
crosoft Excel, 8th Edition, David M. Levine
k k k k k k
,2-2 OrganizingkandkVisualizingkVariables
CHAPTER 2: ORGANIZING AND VISUALIZING
k k k k k
VARIABLES
SCENARIOk2-1
Ankinsurancekcompanykevaluateskmanyknumericalkvariableskaboutkakpersonkbeforekdecidingkonkankappr
opriatekratekforkautomobilekinsurance.kAkrepresentativekfromkaklocalkinsurancekagencykselectedkakrando
mksamplekofkinsuredkdriverskandkrecorded,kX,ktheknumberkofkclaimskeachkmadekinktheklastk3kyears,kwithk
thekfollowingkresults.
kk X fk
1 14
2 18
3 12
4 5
5 1
1. ReferringktokScenariok2-1,khowkmanykdriverskarekrepresentedkinktheksample?
a) 5
b) 15
c) 18
d) 50
ANSWER:
d
TYPE:kMCk DIFFICULTY:kEasy
KEYWORDS:kfrequencykdistribution
2. ReferringktokScenariok2-1,khowkmanyktotalkclaimskarekrepresentedkinktheksample?
a) 15
b) 50
c)kkk 111
d)kkk 250
ANSWER:
c
TYPE:kMCk DIFFICULTY:kModerate
KEYWORDS:kinterpretation,kfrequencykdistribution
3. Aktypekofkverticalkbarkchartkinkwhichkthekcategorieskarekplottedkinkthekdescendingkrankkorderkofkthek
magnitudekofktheirkfrequencieskiskcalledka
a) contingencyktable.
b) Paretokchart.
c) stem-and-leafkdisplay.
d) piekchart.
ANSWER:
b
TYPE:kMCk DIFFICULTY:kEasy
KEYWORDS:kParetokchart
, OrganizingkandkVisualizingkVariables 2-3
SCENARIOk2-2
Atkakmeetingkofkinformationksystemskofficerskforkregionalkofficeskofkaknationalkcompany,kaksurveykwaskt
akenktokdeterminektheknumberkofkemployeeskthekofficersksupervisekinkthekoperationkofktheirkdepartment
s,kwherekXkisktheknumberkofkemployeeskoverseenkbykeachkinformationksystemskofficer.
kkX f_
1 7
2 5
3 11
4 8
5 9
4. ReferringktokScenariok2-
2,khowkmanykregionalkofficeskarekrepresentedkinktheksurveykresults?ka)5
b) 11
c) 15
d) 40
ANSWER:
d
TYPE:kMCk DIFFICULTY:kEasy
KEYWORDS:kinterpretation,kfrequencykdistribution
5. ReferringktokScenariok2-
2,kacrosskallkofkthekregionalkoffices,khowkmanyktotalkemployeeskwereksupervisedkbykthoseksurv
eyed?
a) 15
b) 40
c) 127
d) 200
ANSWER:
c
TYPE:kMCk DIFFICULTY:kModerate
KEYWORDS:kinterpretation,kfrequencykdistribution
6. Thekwidthkofkeachkbarkinkakhistogramkcorrespondsktokthe
a) differenceskbetweenkthekboundarieskofkthekclass.
b) numberkofkobservationskinkeachkclass.
c) midpointkofkeachkclass.
d) percentagekofkobservationskinkeachkclass.
ANSWER:
a
TYPE:kMCk DIFFICULTY:kEasy
KEYWORDS:khistogram
, 2-4 OrganizingkandkVisualizingkVariables
SCENARIOk2-3
Everykspringksemester,kthekSchoolkofkBusinesskcoordinateskakluncheonkwithklocalkbusinesskleaderskforkg
raduatingkseniors,ktheirkfamilies,kandkfriends.kCorporateksponsorshipkpayskforkthekluncheskofkeachkofkthe
kseniors,kbutkstudentskhavektokpurchasekticketsktokcoverkthekcostkofkluncheskservedktokguestsktheykbringkw
ithkthem.kThekfollowingkhistogramkrepresentskthekattendancekatkthekseniorkluncheon,kwherekXkisktheknum
berkofkguestskeachkgraduatingkseniorkinvitedktokthekluncheonkandkfkisktheknumberkofkgraduatingkseniorski
nkeachkcategory.
160 152
140
120
100
85
80
60
40
17 18
20
3 0
0
0 1 2k 3 4 5
Guestsk pker Studen
t
7. ReferringktokthekhistogramkfromkScenariok2-
3,khowkmanykgraduatingkseniorskattendedkthekluncheon?
a) 4
b)kkk 152
c)kkk 275
d)kkk 388
ANSWER:
c
TYPE:kMCk DIFFICULTY:kDifficult
EXPLANATION:kTheknumberkofkgraduatingkseniorskisktheksumkofkallkthekfrequencies,kf.kKEYWO
RDS:kinterpretation,khistogram
8. ReferringktokthekhistogramkfromkScenariok2-
3,kifkallkthekticketskpurchasedkwerekused,khowkmanykguestskattendedkthekluncheon?
a) 4
b)kkk 152
c)kkk 275
d)kkk 388
ANSWER:
d
TYPE:kMCk DIFFICULTY:kDifficult
EXPLANATION:kThektotalknumberkofkguestskis Xk f
6
i1 ik i
KEYWORDS:kinterpretation,khistogram
Test Bank for Statistics for Managers Using Mi
k k k k k k k
crosoft Excel, 8th Edition, David M. Levine
k k k k k k
,2-2 OrganizingkandkVisualizingkVariables
CHAPTER 2: ORGANIZING AND VISUALIZING
k k k k k
VARIABLES
SCENARIOk2-1
Ankinsurancekcompanykevaluateskmanyknumericalkvariableskaboutkakpersonkbeforekdecidingkonkankappr
opriatekratekforkautomobilekinsurance.kAkrepresentativekfromkaklocalkinsurancekagencykselectedkakrando
mksamplekofkinsuredkdriverskandkrecorded,kX,ktheknumberkofkclaimskeachkmadekinktheklastk3kyears,kwithk
thekfollowingkresults.
kk X fk
1 14
2 18
3 12
4 5
5 1
1. ReferringktokScenariok2-1,khowkmanykdriverskarekrepresentedkinktheksample?
a) 5
b) 15
c) 18
d) 50
ANSWER:
d
TYPE:kMCk DIFFICULTY:kEasy
KEYWORDS:kfrequencykdistribution
2. ReferringktokScenariok2-1,khowkmanyktotalkclaimskarekrepresentedkinktheksample?
a) 15
b) 50
c)kkk 111
d)kkk 250
ANSWER:
c
TYPE:kMCk DIFFICULTY:kModerate
KEYWORDS:kinterpretation,kfrequencykdistribution
3. Aktypekofkverticalkbarkchartkinkwhichkthekcategorieskarekplottedkinkthekdescendingkrankkorderkofkthek
magnitudekofktheirkfrequencieskiskcalledka
a) contingencyktable.
b) Paretokchart.
c) stem-and-leafkdisplay.
d) piekchart.
ANSWER:
b
TYPE:kMCk DIFFICULTY:kEasy
KEYWORDS:kParetokchart
, OrganizingkandkVisualizingkVariables 2-3
SCENARIOk2-2
Atkakmeetingkofkinformationksystemskofficerskforkregionalkofficeskofkaknationalkcompany,kaksurveykwaskt
akenktokdeterminektheknumberkofkemployeeskthekofficersksupervisekinkthekoperationkofktheirkdepartment
s,kwherekXkisktheknumberkofkemployeeskoverseenkbykeachkinformationksystemskofficer.
kkX f_
1 7
2 5
3 11
4 8
5 9
4. ReferringktokScenariok2-
2,khowkmanykregionalkofficeskarekrepresentedkinktheksurveykresults?ka)5
b) 11
c) 15
d) 40
ANSWER:
d
TYPE:kMCk DIFFICULTY:kEasy
KEYWORDS:kinterpretation,kfrequencykdistribution
5. ReferringktokScenariok2-
2,kacrosskallkofkthekregionalkoffices,khowkmanyktotalkemployeeskwereksupervisedkbykthoseksurv
eyed?
a) 15
b) 40
c) 127
d) 200
ANSWER:
c
TYPE:kMCk DIFFICULTY:kModerate
KEYWORDS:kinterpretation,kfrequencykdistribution
6. Thekwidthkofkeachkbarkinkakhistogramkcorrespondsktokthe
a) differenceskbetweenkthekboundarieskofkthekclass.
b) numberkofkobservationskinkeachkclass.
c) midpointkofkeachkclass.
d) percentagekofkobservationskinkeachkclass.
ANSWER:
a
TYPE:kMCk DIFFICULTY:kEasy
KEYWORDS:khistogram
, 2-4 OrganizingkandkVisualizingkVariables
SCENARIOk2-3
Everykspringksemester,kthekSchoolkofkBusinesskcoordinateskakluncheonkwithklocalkbusinesskleaderskforkg
raduatingkseniors,ktheirkfamilies,kandkfriends.kCorporateksponsorshipkpayskforkthekluncheskofkeachkofkthe
kseniors,kbutkstudentskhavektokpurchasekticketsktokcoverkthekcostkofkluncheskservedktokguestsktheykbringkw
ithkthem.kThekfollowingkhistogramkrepresentskthekattendancekatkthekseniorkluncheon,kwherekXkisktheknum
berkofkguestskeachkgraduatingkseniorkinvitedktokthekluncheonkandkfkisktheknumberkofkgraduatingkseniorski
nkeachkcategory.
160 152
140
120
100
85
80
60
40
17 18
20
3 0
0
0 1 2k 3 4 5
Guestsk pker Studen
t
7. ReferringktokthekhistogramkfromkScenariok2-
3,khowkmanykgraduatingkseniorskattendedkthekluncheon?
a) 4
b)kkk 152
c)kkk 275
d)kkk 388
ANSWER:
c
TYPE:kMCk DIFFICULTY:kDifficult
EXPLANATION:kTheknumberkofkgraduatingkseniorskisktheksumkofkallkthekfrequencies,kf.kKEYWO
RDS:kinterpretation,khistogram
8. ReferringktokthekhistogramkfromkScenariok2-
3,kifkallkthekticketskpurchasedkwerekused,khowkmanykguestskattendedkthekluncheon?
a) 4
b)kkk 152
c)kkk 275
d)kkk 388
ANSWER:
d
TYPE:kMCk DIFFICULTY:kDifficult
EXPLANATION:kThektotalknumberkofkguestskis Xk f
6
i1 ik i
KEYWORDS:kinterpretation,khistogram