Test Bank for Statistics for Managers Using Microsoft Excel 14th Edition Levine Stephan Szabat All Chapters 1 - 20 Complete ISBN 9780135970249 Newest Version 2024

OrganizingdanddVisualizingdVariables 2-1



Test Bank for Statistics for Managers Using Micros
d d d d d d d




oft Excel, 8th Edition, David M. Levine
d d d d d d

,2-2 OrganizingdanddVisualizingdVariables


CHAPTER 2: ORGANIZING AND VISUALIZING VARIAB
d d d d d



LES
SCENARIOd2-1

Andinsurancedcompanydevaluatesdmanydnumericaldvariablesdaboutdadpersondbeforeddecidingdondandapp
ropriatedratedfordautomobiledinsurance.dAdrepresentativedfromdadlocaldinsurancedagencydselecteddadrand
omdsampledofdinsuredddriversdanddrecorded,dX,dthednumberdofdclaimsdeachdmadedindthedlastd3dyears,dwit
hdthedfollowingdresults.
d X fd
1 14
2 18
3 12
4 5
5 1

1. ReferringdtodScenariod2-1,dhowdmanyddriversdaredrepresenteddindthedsample?
a) 5
b) 15
c) 18
d) 50

ANSWER:
d
TYPE:dMCd DIFFICULTY:dEasy
KEYWORDS:dfrequencyddistribution

2. ReferringdtodScenariod2-1,dhowdmanydtotaldclaimsdaredrepresenteddindthedsample?
a) 15
b) 50
c) 111
d) 250

ANSWER:
c
TYPE:dMCd DIFFICULTY:dModerate
KEYWORDS:dinterpretation,dfrequencyddistribution

3. Adtypedofdverticaldbardchartdindwhichdthedcategoriesdaredplotteddindtheddescendingdrankdorderdofdthed
magnitudedofdtheirdfrequenciesdisdcalledda
a) contingencydtable.
b) Paretodchart.
c) stem-and-leafddisplay.
d) piedchart.

ANSWER:
b
TYPE:dMCd DIFFICULTY:dEasy
KEYWORDS:dParetodchart

, OrganizingdanddVisualizingdVariables 2-3


SCENARIOd2-2

Atdadmeetingdofdinformationdsystemsdofficersdfordregionaldofficesdofdadnationaldcompany,dadsurveydwasdt
akendtoddeterminedthednumberdofdemployeesdthedofficersdsupervisedindthedoperationdofdtheirddepartment
s,dwheredXdisdthednumberdofdemployeesdoverseendbydeachdinformationdsystemsdofficer.
d X f_
1 7
2 5
3 11
4 8
5 9

4. ReferringdtodScenariod2-
2,dhowdmanydregionaldofficesdaredrepresenteddindthedsurveydresults?da)5
b) 11
c) 15
d) 40

ANSWER:
d
TYPE:dMCd DIFFICULTY:dEasy
KEYWORDS:dinterpretation,dfrequencyddistribution

5. ReferringdtodScenariod2-
2,dacrossdalldofdthedregionaldoffices,dhowdmanydtotaldemployeesdweredsuperviseddbydthosedsurv
eyed?
a) 15
b) 40
c) 127
d) 200

ANSWER:
c
TYPE:dMCd DIFFICULTY:dModerate
KEYWORDS:dinterpretation,dfrequencyddistribution

6. Thedwidthdofdeachdbardindadhistogramdcorrespondsdtodthe
a) differencesdbetweendthedboundariesdofdthedclass.
b) numberdofdobservationsdindeachdclass.
c) midpointdofdeachdclass.
d) percentagedofdobservationsdindeachdclass.

ANSWER:
a
TYPE:dMCd DIFFICULTY:dEasy
KEYWORDS:dhistogram

, 2-4 OrganizingdanddVisualizingdVariables


SCENARIOd2-3

Everydspringdsemester,dthedSchooldofdBusinessdcoordinatesdadluncheondwithdlocaldbusinessdleadersdfordgr
aduatingdseniors,dtheirdfamilies,danddfriends.dCorporatedsponsorshipdpaysdfordthedlunchesdofdeachdofdtheds
eniors,dbutdstudentsdhavedtodpurchasedticketsdtodcoverdthedcostdofdlunchesdserveddtodguestsdtheydbringdwit
hdthem.dThedfollowingdhistogramdrepresentsdthedattendancedatdthedseniordluncheon,dwheredXdisdthednumb
erdofdguestsdeachdgraduatingdseniordinviteddtodthedluncheondanddfdisdthednumberdofdgraduatingdseniorsdind
eachdcategory.




7. ReferringdtodthedhistogramdfromdScenariod2-
3,dhowdmanydgraduatingdseniorsdattendeddthedluncheon?
a) 4
b) 152
c) 275
d) 388

ANSWER:
c
TYPE:dMCd DIFFICULTY:dDifficult
EXPLANATION:dThednumberdofdgraduatingdseniorsdisdthedsumdofdalldthedfrequencies,df.dKEYWORD
S:dinterpretation,dhistogram

8. ReferringdtodthedhistogramdfromdScenariod2-
3,difdalldthedticketsdpurchaseddweredused,dhowdmanydguestsdattendeddthedluncheon?
a) 4
b) 152
c) 275
d) 388

ANSWER:
d
TYPE:dMCd DIFFICULTY:dDifficult
EXPLANATION:dThedtotaldnumberdofdguestsdis Xd f
 6
i=1 id d i

KEYWORDS:dinterpretation,dhistogram