Test Bank for Statistics for Managers Using Mi
P P P P P P P
crosoft Excel, 8th Edition, David M. Levine
P P P P P P
,2-2 OrganizingPandPVisualizingPVariables
CHAPTER 2: ORGANIZING AND VISUALIZING
P P P P P
VARIABLES
SCENARIOP2-1
AnPinsurancePcompanyPevaluatesPmanyPnumericalPvariablesPaboutPaPpersonPbeforePdecidingPonPanPapp
ropriatePratePforPautomobilePinsurance.PAPrepresentativePfromPaPlocalPinsurancePagencyPselectedPaPrand
omPsamplePofPinsuredPdriversPandPrecorded,PX,PthePnumberPofPclaimsPeachPmadePinPthePlastP3Pyears,Pwi
thPthePfollowingPresults.
PP X fP
1 14
2 18
3 12
4 5
5 1
1. ReferringPtoPScenarioP2-1,PhowPmanyPdriversParePrepresentedPinPthePsample?
a) 5
b) 15
c) 18
d) 50
ANSWER:
d
TYPE:PMCP DIFFICULTY:PEasy
KEYWORDS:PfrequencyPdistribution
2. ReferringPtoPScenarioP2-1,PhowPmanyPtotalPclaimsParePrepresentedPinPthePsample?
a) 15
b) 50
c)PPP 111
d)PPP 250
ANSWER:
c
TYPE:PMCP DIFFICULTY:PModerate
KEYWORDS:Pinterpretation,PfrequencyPdistribution
3. APtypePofPverticalPbarPchartPinPwhichPthePcategoriesParePplottedPinPthePdescendingPrankPorderPofPtheP
magnitudePofPtheirPfrequenciesPisPcalledPa
a) contingencyPtable.
b) ParetoPchart.
c) stem-and-leafPdisplay.
d) piePchart.
ANSWER:
b
TYPE:PMCP DIFFICULTY:PEasy
KEYWORDS:PParetoPchart
, OrganizingPandPVisualizingPVariables 2-3
SCENARIOP2-2
AtPaPmeetingPofPinformationPsystemsPofficersPforPregionalPofficesPofPaPnationalPcompany,PaPsurveyPwasP
takenPtoPdeterminePthePnumberPofPemployeesPthePofficersPsupervisePinPthePoperationPofPtheirPdepartme
nts,PwherePXPisPthePnumberPofPemployeesPoverseenPbyPeachPinformationPsystemsPofficer.
PPX f_
1 7
2 5
3 11
4 8
5 9
4. ReferringPtoPScenarioP2-
2,PhowPmanyPregionalPofficesParePrepresentedPinPthePsurveyPresults?Pa)5
b) 11
c) 15
d) 40
ANSWER:
d
TYPE:PMCP DIFFICULTY:PEasy
KEYWORDS:Pinterpretation,PfrequencyPdistribution
5. ReferringPtoPScenarioP2-
2,PacrossPallPofPthePregionalPoffices,PhowPmanyPtotalPemployeesPwerePsupervisedPbyPthosePsur
veyed?
a) 15
b) 40
c) 127
d) 200
ANSWER:
c
TYPE:PMCP DIFFICULTY:PModerate
KEYWORDS:Pinterpretation,PfrequencyPdistribution
6. ThePwidthPofPeachPbarPinPaPhistogramPcorrespondsPtoPthe
a) differencesPbetweenPthePboundariesPofPthePclass.
b) numberPofPobservationsPinPeachPclass.
c) midpointPofPeachPclass.
d) percentagePofPobservationsPinPeachPclass.
ANSWER:
a
TYPE:PMCP DIFFICULTY:PEasy
KEYWORDS:Phistogram
, 2-4 OrganizingPandPVisualizingPVariables
SCENARIOP2-3
EveryPspringPsemester,PthePSchoolPofPBusinessPcoordinatesPaPluncheonPwithPlocalPbusinessPleadersPforP
graduatingPseniors,PtheirPfamilies,PandPfriends.PCorporatePsponsorshipPpaysPforPthePlunchesPofPeachPofPt
hePseniors,PbutPstudentsPhavePtoPpurchasePticketsPtoPcoverPthePcostPofPlunchesPservedPtoPguestsPtheyPbrin
gPwithPthem.PThePfollowingPhistogramPrepresentsPthePattendancePatPthePseniorPluncheon,PwherePXPisPtheP
numberPofPguestsPeachPgraduatingPseniorPinvitedPtoPthePluncheonPandPfPisPthePnumberPofPgraduatingPsen
iorsPinPeachPcategory.
160 152
140
120
100
85
80
60
40
17 18
20
3 0
0
0 1 2P 3 4 5
GuestsP per
P Studen
t
7. ReferringPtoPthePhistogramPfromPScenarioP2-
3,PhowPmanyPgraduatingPseniorsPattendedPthePluncheon?
a) 4
b)PPP 152
c)PPP 275
d)PPP 388
ANSWER:
c
TYPE:PMCP DIFFICULTY:PDifficult
EXPLANATION:PThePnumberPofPgraduatingPseniorsPisPthePsumPofPallPthePfrequencies,Pf.PKEYW
ORDS:Pinterpretation,Phistogram
8. ReferringPtoPthePhistogramPfromPScenarioP2-
3,PifPallPthePticketsPpurchasedPwerePused,PhowPmanyPguestsPattendedPthePluncheon?
a) 4
b)PPP 152
c)PPP 275
d)PPP 388
ANSWER:
d
TYPE:PMCP DIFFICULTY:PDifficult
EXPLANATION:PThePtotalPnumberPofPguestsPis XP f
6
i1 iP i
KEYWORDS:Pinterpretation,Phistogram