INSTRUCTOR’S
SOLUTIONS MANUAL
GAIL ILLICH PAUL ILLICH
McLennan Community College Southeast Community College
STATISTICS FOR MANAGERS
USING MICROSOFT® EXCEL®
NINTH EDITION
David Levine
Baruch College, City University of New York
David Stephan
Two Bridges Instructional Technology
Kathryn Szabat
La Salle University
,
The author and publisher of this book have used their best efforts in preparing this book. These efforts include the
development, research, and testing of the theories and programs to determine their effectiveness. The author and publisher
make no warranty of any kind, expressed or implied, with regard to these programs or the documentation contained in this
book. The author and publisher shall not be liable in any event for incidental or consequential damages in connection with, or
arising out of, the furnishing, performance, or use of these programs.
Reproduced by Pearson from electronic files supplied by the author.
Copyright © 2021, 2017, 2014 by Pearson Education, Inc. 221 River Street, Hoboken, NJ 07030. All rights reserved.
All rights reserved. No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in any form or
by any means, electronic, mechanical, photocopying, recording, or otherwise, without the prior written permission of the
publisher. Printed in the United States of America.
ISBN-13: 978-0-13-597019-5
ISBN-10: 0-13-597019-9
, 7DEOHRI&RQWHQWV
7HDFKLQJ7LSV
&KDSWHU 'HILQLQJDQG&ROOHFWLQJ'DWD
&KDSWHU 2UJDQL]LQJDQG9LVXDOL]LQJ9DULDEOHV
&KDSWHU 1XPHULFDO'HVFULSWLYH0HDVXUHV
&KDSWHU %DVLF3UREDELOLW\
&KDSWHU 'LVFUHWH3UREDELOLW\'LVWULEXWLRQV
&KDSWHU 7KH1RUPDO'LVWULEXWLRQDQG2WKHU&RQWLQXRXV'LVWULEXWLRQV
&KDSWHU 6DPSOLQJ'LVWULEXWLRQV
&KDSWHU &RQILGHQFH,QWHUYDO(VWLPDWLRQ
&KDSWHU
)XQGDPHQWDOVRI+\SRWKHVLV7HVWLQJ
2QH6DPSOH7HVWV
&KDSWHU 7ZR6DPSOH7HVWV
&KDSWHU $QDO\VLVRI9DULDQFH
&KDSWHU &KL6TXDUHDQG1RQSDUDPHWULF7HVWV
&KDSWHU 6LPSOH/LQHDU5HJUHVVLRQ
&KDSWHU ,QWURGXFWLRQWR0XOWLSOH5HJUHVVLRQ
&KDSWHU 0XOWLSOH5HJUHVVLRQ0RGHO%XLOGLQJ
&KDSWHU 7LPH6HULHV)RUHFDVWLQJ
&KDSWHU %XVLQHVV$QDO\WLFV
&KDSWHU *HWWLQJ5HDG\WR$QDO\]H'DWDLQWKH)XWXUH
&KDSWHU
6WDWLVWLFDO$SSOLFDWLRQVLQ4XDOLW\0DQDJHPHQW 21/,1(
&KDSWHU 'HFLVLRQ0DNLQJ 21/,1(
2QOLQH6HFWLRQV
,QVWUXFWLRQDO7LSVDQG6ROXWLRQVIRU'LJLWDO&DVHV
7KHBrynne Packaging&DVH
&RS\ULJKW3HDUVRQ(GXFDWLRQ,QF
LLL
,7KHCardioGood Fitness &DVH
7KHChoice Is Yours/More Descriptive Choices Follow-up &DVH
7KHClear Mountain State Student Surveys &DVH
7KHCraybill Instrumentation Company&DVH
7KHManaging Ashland MultiComm Services&DVH
7KHMountain States Potato Company&DVH
7KHSure Value Convenience Stores&DVH
&RS\ULJKW3HDUVRQ(GXFDWLRQ,QF
LY
, 3UHIDFH
7KHILUVWSDUWRIWKHInstructor’s Solutions ManualFRQWDLQVRXUHGXFDWLRQDOSKLORVRSK\DQGWHDFKLQJWLSV
IRUHDFKFKDSWHURIWKHWH[W6ROXWLRQVWR(QGRI6HFWLRQ3UREOHPVDQG&KDSWHU5HYLHZ3UREOHPVLQHDFK
FKDSWHUIROORZ,QVWUXFWLRQDOWLSVDQGVROXWLRQVIRUWKHGLJLWDOFDVHVDUHLQFOXGHGQH[W$QVZHUVWRWKH
Brynne Packaging&DVHWKHCardioGood Fitness &DVHWKHChoice Is Yours/More Descriptive Choices
Follow-up CaseWKHClear Mountain State Student Surveys Case, WKHCraybill Instrumentation Company
&DVHWKHManaging Ashland MultiComm Services&DVHWKHMountain States Potato Company Case DQG
WKHSure Value Convenience Stores&DVHDUHLQFOXGHGODVW
7KHSXUSRVHRIWKLVInstructor’s Solutions ManualLVWRIDFLOLWDWHJUDGLQJRIDVVLJQPHQWVRUH[DPVE\
LQVWUXFWRUVDQGRUWHDFKLQJDVVLVWDQWV6FUHHQVKRWVXVLQJRXWSXWIURP3+6WDWDUHLQWHJUDWHGWKURXJKRXW
0RVWRIWKHSUREOHPVDUHVROYHGXVLQJ3+6WDW7RSUHVHQWWKHVWHSVLQYROYHGLQVROYLQJDSUREOHPVRPH
LQWHUPHGLDWHQXPHULFDOUHVXOWVDUHSUHVHQWHGDFFXUDWHWRRQO\DUHDVRQDEOHQXPEHURIVLJQLILFDQWGLJLWV
+HQFHLQVWUXFWRUVDUHUHPLQGHGWKDWWKHILQDOUHVXOWVSUHVHQWHGLQWKLVPDQXDOWKDWDUHREWDLQHGXVLQJ
3+6WDWFDQVRPHWLPHVEHGLIIHUHQWIURPWKRVHREWDLQHGZLWKDKDQGFDOFXODWRUFRPSXWHGXVLQJWKH
LQWHUPHGLDWHYDOXHVGXHWRURXQGLQJ
&RS\ULJKW3HDUVRQ(GXFDWLRQ,QF
Y
,
, 7HDFKLQJ7LSVIRU
6WDWLVWLFVIRU0DQDJHUVXVLQJ0LFURVRIW([FHO
WK(G
2XU6WDUWLQJ3RLQW
2YHUDJHQHUDWLRQDJRDGYDQFHVLQ³GDWDSURFHVVLQJ´OHGWRQHZEXVLQHVVRSSRUWXQLWLHVDVILUVWFHQWUDOL]HG
DQGWKHQGHVNWRSFRPSXWLQJSUROLIHUDWHG7KH,QIRUPDWLRQ$JHZDVERUQ&RPSXWHUVFLHQFHEHFDPH
PXFKPRUHWKDQMXVWDQDGMXQFWWRDPDWKHPDWLFVFXUULFXOXPDQGZKROHQHZILHOGVRIVWXGLHVVXFKDV
FRPSXWHULQIRUPDWLRQV\VWHPVHPHUJHG
0RUHUHFHQWO\IXUWKHUDGYDQFHVLQLQIRUPDWLRQWHFKQRORJLHVKDYHFRPELQHGZLWKGDWDDQDO\VLV
WHFKQLTXHVWRFUHDWHQHZRSSRUWXQLWLHVLQZKDWLVPRUHGDWDscienceWKDQGDWDprocessingRUcomputer
VFLHQFH7KHZRUOGRIEXVLQHVVVWDWLVWLFVKDVJURZQODUJHUEXPSLQJLQWRRWKHUGLVFLSOLQHV$QGLQD
UHSULVHRIVRPHWKLQJWKDWRFFXUUHGDJHQHUDWLRQDJRQHZILHOGVRIVWXG\WKLVWLPHZLWKQDPHVVXFKDV
LQIRUPDWLFVGDWDDQDO\WLFVDQGGHFLVLRQVFLHQFHKDYHHPHUJHG
7KLVWLPHRIFKDQJHPDNHVZKDWLVWDXJKWLQEXVLQHVVVWDWLVWLFVDQGKRZLWLVWDXJKWDOOWKHPRUH
FULWLFDO7KHVHQHZILHOGVRIVWXG\DOOVKDUHVWDWLVWLFVDVDIRXQGDWLRQIRUIXUWKHUOHDUQLQJ:HDUH
DFFXVWRPHGWRWKLQNLQJDERXWFKDQJHDVVHHNLQJZD\VWRFRQWLQXRXVO\LPSURYHWKHWHDFKLQJRIEXVLQHVV
VWDWLVWLFVKDYHDOZD\VJXLGHGRXUHIIRUWV:HDFWLYHO\SDUWLFLSDWHLQ'HFLVLRQ6FLHQFHV,QVWLWXWH '6,
$PHULFDQ6WDWLVWLFDO$VVRFLDWLRQ $6$ DQG0DNLQJ6WDWLVWLFV0RUH(IIHFWLYHLQ6FKRROVDQG%XVLQHVV
060(6% FRQIHUHQFHV:HXVHWKH$6$¶V*XLGHOLQHVIRU$VVHVVPHQWDQG,QVWUXFWLRQ *$,6( UHSRUWV
DQGFRPELQHWKHPZLWKRXUH[SHULHQFHVWHDFKLQJEXVLQHVVVWDWLVWLFVWRDGLYHUVHVWXGHQWERG\DWVHYHUDO
ODUJHXQLYHUVLWLHV
:KDWWRWHDFKDQGKRZWRWHDFKLWDUHSDUWLFXODUO\VLJQLILFDQWTXHVWLRQVWRDVNGXULQJDWLPHRI
FKDQJH$VDQDXWKRUWHDPZHEULQJDXQLTXHFROOHFWLRQRIH[SHULHQFHVWKDWZHEHOLHYHKHOSVXVILQGWKH
SURSHUSHUVSHFWLYHLQEDODQFLQJWKHROGDQGWKHQHZ2XUOHDGDXWKRU'DYLG0/HYLQHZDVWKHILUVW
HGXFDWRUDORQJZLWK0DUN/%HUHQVRQWRFUHDWHDEXVLQHVVVWDWLVWLFVWH[WERRNWKDWGLVFXVVHGXVLQJ
VWDWLVWLFDOVRIWZDUHDQGLQFRUSRUDWHG³FRPSXWHURXWSXW´DVLOOXVWUDWLRQV²MXVWWKHILUVWRIPDQ\WHDFKLQJ
DQGFXUULFXODULQQRYDWLRQVLQKLVPDQ\\HDUVRIWHDFKLQJEXVLQHVVVWDWLVWLFV2XUVHFRQGDXWKRU'DYLG)
6WHSKDQGHYHORSHGFRXUVHVDQGWHDFKLQJPHWKRGVLQFRPSXWHULQIRUPDWLRQV\VWHPVDQGGLJLWDOPHGLD
GXULQJWKHLQIRUPDWLRQUHYROXWLRQFUHDWLQJDQGWKHQWHDFKLQJLQRQHRIWKHILUVWSHUVRQDOFRPSXWHU
classroomsLQDODUJHVFKRRORIEXVLQHVVDORQJWKHZD\(DUO\LQKLVFDUHHUKHLQWURGXFHGVSUHDGVKHHW
DSSOLFDWLRQVWRDEXVLQHVVVWDWLVWLFVIDFXOW\DXGLHQFHWKDWLQFOXGHG'DYLG/HYLQHDQLQWURGXFWLRQWKDW
ZRXOGHYHQWXDOO\OHGWRWKHILUVWHGLWLRQRIWKLVWH[WERRN2XUQHZHVWFRDXWKRU.DWKU\Q$6]DEDWKDV
SURYLGHGVWDWLVWLFDODGYLFHWRYDULRXVEXVLQHVVDQGQRQEXVLQHVVFRPPXQLWLHV+HUEDFNJURXQGLQ
&RS\ULJKW3HDUVRQ(GXFDWLRQ,QF
,7HDFKLQJ7LSV
VWDWLVWLFVDQGRSHUDWLRQVUHVHDUFKDQGKHUH[SHULHQFHVLQWHUDFWLQJZLWKSURIHVVLRQDOVLQSUDFWLFHKDYH
JXLGHGKHUDVGHSDUWPHQWDOFKDLULQGHYHORSLQJDQHZLQWHUGLVFLSOLQDU\DFDGHPLFGHSDUWPHQW%XVLQHVV
6\VWHPVDQG$QDO\WLFVLQUHVSRQVHWRWKHWHFKQRORJ\DQGGDWDGULYHQFKDQJHVLQEXVLQHVVWRGD\
$OOWKUHHRIXVEHQHILWIURPRXUPDQ\\HDUVWHDFKLQJXQGHUJUDGXDWHEXVLQHVVVXEMHFWVDQGWKH
GLYHUVLW\RILQWHUHVWVDQGHIIRUWVRIRXUSDVWFRDXWKRUV0DUN%HUHQVRQDQG7LPRWK\.UHKELHO7ZRRIXV
6WHSKDQDQG6]DEDW DOVREHQHILWIURPIRUPDOWUDLQLQJDQGEDFNJURXQGLQHGXFDWLRQDOPHWKRGVDQG
LQVWUXFWLRQDOGHVLJQ
&RS\ULJKW3HDUVRQ(GXFDWLRQ,QF
, 7HDFKLQJ7LSV
(GXFDWLRQDO3KLORVRSK\
$VLQSULRUHGLWLRQVRIStatistics for Managers Using Microsoft ExcelZHDUHJXLGHGE\WKHVHNH\
OHDUQLQJSULQFLSOHV
+HOSVWXGHQWVVHHWKHUHOHYDQFHRIVWDWLVWLFVWRWKHLURZQFDUHHUVE\SURYLGLQJH[DPSOHVGUDZQ
IURPWKHIXQFWLRQDODUHDVLQZKLFKWKH\PD\EHVSHFLDOL]LQJ6WXGHQWVQHHGDIUDPHRIUHIHUHQFH
ZKHQOHDUQLQJVWDWLVWLFVHVSHFLDOO\ZKHQVWDWLVWLFVLVQRWWKHLUPDMRU7KDWIUDPHRIUHIHUHQFHIRU
EXVLQHVVVWXGHQWVVKRXOGEHWKHIXQFWLRQDODUHDVRIEXVLQHVVVXFKDVDFFRXQWLQJILQDQFHLQIRUPDWLRQ
V\VWHPVPDQDJHPHQWDQGPDUNHWLQJ(DFKVWDWLVWLFVWRSLFQHHGVWREHSUHVHQWHGLQDQDSSOLHGFRQWH[W
UHODWHGWRDWOHDVWRQHRIWKHVHIXQFWLRQDODUHDV7KHIRFXVLQWHDFKLQJHDFKWRSLFVKRXOGEHRQLWV
DSSOLFDWLRQLQEXVLQHVVWKHLQWHUSUHWDWLRQRIUHVXOWVWKHHYDOXDWLRQRIWKHDVVXPSWLRQVDQGWKH
GLVFXVVLRQRIZKDWVKRXOGEHGRQHLIWKHDVVXPSWLRQVDUHYLRODWHG
(PSKDVL]HLQWHUSUHWDWLRQRIVWDWLVWLFDOUHVXOWVRYHUPDWKHPDWLFDOFRPSXWDWLRQ,QWURGXFWRU\
EXVLQHVVVWDWLVWLFVFRXUVHVVKRXOGUHFRJQL]HWKHJURZLQJQHHGWRinterpret VWDWLVWLFDOUHVXOWVWKDW
FRPSXWHUL]HGSURFHVVHVFUHDWH7KLVPDNHVWKHLQWHUSUHWDWLRQRIUHVXOWVPRUHLPSRUWDQWWKDQNQRZLQJ
KRZWRH[HFXWHWKHWHGLRXVKDQGFDOFXODWLRQVUHTXLUHGWRSURGXFHWKHP
*LYHVWXGHQWVDPSOHSUDFWLFHLQXQGHUVWDQGLQJKRZWRDSSO\VWDWLVWLFVWREXVLQHVV%RWK
FODVVURRPH[DPSOHVDQGKRPHZRUNH[HUFLVHVVKRXOGLQYROYHDFWXDORUUHDOLVWLFGDWDDVPXFKDV
SRVVLEOH6WXGHQWVVKRXOGZRUNZLWKGDWDVHWVERWKVPDOODQGODUJHDQGEHHQFRXUDJHGWRORRN
EH\RQGWKHVWDWLVWLFDODQDO\VLVRIGDWDWRWKHLQWHUSUHWDWLRQRIUHVXOWVLQDPDQDJHULDOFRQWH[W
)DPLOLDUL]HVWXGHQWVZLWKKRZWRXVHVWDWLVWLFDOVRIWZDUHWRDVVLVWEXVLQHVVGHFLVLRQPDNLQJ
,QWURGXFWRU\EXVLQHVVVWDWLVWLFVFRXUVHVVKRXOGUHFRJQL]HWKDWSURJUDPVZLWKVWDWLVWLFDOIXQFWLRQVDUH
FRPPRQO\IRXQGRQDEXVLQHVVGHFLVLRQPDNHU¶VGHVNWRSFRPSXWHU,QWHJUDWLQJVWDWLVWLFDOVRIWZDUH
LQWRDOODVSHFWVRIDQLQWURGXFWRU\VWDWLVWLFVFRXUVHDOORZVWKHFRXUVHWRIRFXVRQLQWHUSUHWDWLRQRI
UHVXOWVLQVWHDGRIFRPSXWDWLRQV VHHSRLQW
3URYLGHFOHDULQVWUXFWLRQVWRVWXGHQWVIRUXVLQJVWDWLVWLFDODSSOLFDWLRQV%RRNVVKRXOGH[SODLQ
FOHDUO\KRZWRXVHSURJUDPVVXFKDV0LFURVRIW([FHOZLWKWKHVWXG\RIVWDWLVWLFVZLWKRXWKDYLQJWKRVH
LQVWUXFWLRQVGRPLQDWHWKHERRNRUGLVWUDFWIURPWKHOHDUQLQJRIVWDWLVWLFDOFRQFHSWV
&RS\ULJKW3HDUVRQ(GXFDWLRQ,QF
, 7HDFKLQJ7LSV
)LUVW7KLQJV)LUVW
,QDWLPHRIFKDQJH\RXFDQQHYHUNQRZH[DFWO\ZKDWNQRZOHGJHDQGEDFNJURXQGVWXGHQWVEULQJLQWRDQ
LQWURGXFWRU\EXVLQHVVVWDWLVWLFVFODVVURRP$GGWKDWWRWKHQHHGWRFXUEWKHIHDUIDFWRUDERXWOHDUQLQJ
VWDWLVWLFVWKDWVRPDQ\VWXGHQWVEHJLQZLWKDQGWKHUH¶VDORWWRFRYHUHYHQEHIRUH\RXWHDFK\RXUILUVW
VWDWLVWLFDOFRQFHSW
:HFUHDWHG³)LUVW7KLQJV)LUVW´WRPHHWWKLVFKDOOHQJH7KLVXQLWVHWVWKHFRQWH[WIRUH[SODLQLQJ
ZKDWVWDWLVWLFVLV QRWZKDWVWXGHQWVPD\WKLQN ZKLOHHQVXULQJWKDWDOOVWXGHQWVVKDUHDQXQGHUVWDQGLQJRI
WKHIRUFHVWKDWPDNHOHDUQLQJEXVLQHVVVWDWLVWLFVFULWLFDOO\LPSRUWDQWWRGD\(VSHFLDOO\GHVLJQHGIRU
LQVWUXFWRUVWHDFKLQJZLWKFRXUVHPDQDJHPHQWWRROVLQFOXGLQJWKRVHWHDFKLQJK\EULGRURQOLQHFRXUVHV
³)LUVW7KLQJV)LUVW´KDVEHHQGHYHORSHGWREHSRVWHGRQOLQHRURWKHUZLVHGLVWULEXWHGEHIRUHWKHILUVWFODVV
VHFWLRQEHJLQVDQGLVDYDLODEOHIURPWKHGRZQORDGSDJHIRUWKLVERRNWKDWLVGLVFXVVHGLQ$SSHQGL[
6HFWLRQ&
:HZRXOGDUJXHWKDWWKHPRVWLPSRUWDQWFODVVLVWKHILUVWFODVV)LUVWLPSUHVVLRQVDUHFULWLFDOO\
LPSRUWDQW<RXKDYHWKHRSSRUWXQLW\WRVHWWKHWRQHWRFUHDWHDQHZLPSUHVVLRQWKDWWKHFRXUVHZLOOEH
LPSRUWDQWWRWKHLUEXVLQHVVHGXFDWLRQ0DNHWKHIROORZLQJSRLQWV
7KLVFRXUVHLVQRWDPDWKFRXUVH
6WDWHWKDW\RXZLOOEHOHDUQLQJDQDO\WLFDOVNLOOVIRUPDNLQJEXVLQHVVGHFLVLRQV
([SODLQWKDWWKHIRFXVZLOOEHRQKRZVWDWLVWLFVFDQEHXVHGLQWKHIXQFWLRQDODUHDVRIEXVLQHVV
7KLVERRNXVHVDV\VWHPDWLFDSSURDFKIRUPHHWLQJDEXVLQHVVREMHFWLYHRUVROYLQJDEXVLQHVVSUREOHP
7KLVDSSURDFKJRHVDFURVVDOOWKHWRSLFVLQWKHERRNDQGPRVWLPSRUWDQWO\FDQEHXVHGDVDIUDPHZRUNLQ
UHDOZRUOGVLWXDWLRQVZKHQVWXGHQWVJUDGXDWH7KHDSSURDFKKDVWKHDFURQ\P'&29$ZKLFKVWDQGVIRU
'HILQH&ROOHFW2UJDQL]H9LVXDOL]HDQG$QDO\]H
x 'HILQHWKHEXVLQHVVREMHFWLYHRUSUREOHPWREHVROYHGDQGWKHQGHILQHWKHYDULDEOHVWREHVWXGLHG
x &ROOHFWWKHGDWDIURPDSSURSULDWHVRXUFHV
x 2UJDQL]HWKHGDWD
x 9LVXDOL]HWKHGDWDE\GHYHORSLQJFKDUWV
x $QDO\]HWKHGDWDE\XVLQJVWDWLVWLFDOPHWKRGVWRUHDFKFRQFOXVLRQV
7RWKLV\RXFDQDGG&IRU&RPPXQLFDWHZKLFKLVFULWLFDOO\LPSRUWDQW
<RXFDQEHJLQE\HPSKDVL]LQJWKHLPSRUWDQFHRIGHILQLQJ\RXUREMHFWLYHRUSUREOHP7KHQ
GLVFXVVWKHLPSRUWDQFHRIRSHUDWLRQDOGHILQLWLRQVRIYDULDEOHVWREHFRQVLGHUHGDQGGHILQHYDULDEOHGDWD
DQGVWDWLVWLFV
-XVWDVFRPSXWHUVDUHXVHGQRWMXVWLQWKHFRPSXWHUFRXUVHVWXGHQWVQHHGWRNQRZWKDWVWDWLVWLFVLV
XVHGQRWMXVWLQWKHVWDWLVWLFVFRXUVH7KLVOHDGV\RXWRDGLVFXVVLRQRIEXVLQHVVDQDO\WLFVLQZKLFKGDWDLV
&RS\ULJKW3HDUVRQ(GXFDWLRQ,QF
