Solution Manual For Statistics for Managers Using Microsoft Excel, 9th edition by David M. Levine, David F. Stephan, Kathryn A. Szabat

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\ULJKW‹3HDUVRQ(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\ULJKW‹3HDUVRQ(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\ULJKW‹3HDUVRQ(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\ULJKW‹3HDUVRQ(GXFDWLRQ,QF


,7HDFKLQJ7LSV


VWDWLVWLFVDQGRSHUDWLRQVUHVHDUFKDQGKHUH[SHULHQFHVLQWHUDFWLQJZLWKSURIHVVLRQDOVLQSUDFWLFHKDYH
JXLGHGKHUDVGHSDUWPHQWDOFKDLULQGHYHORSLQJDQHZLQWHUGLVFLSOLQDU\DFDGHPLFGHSDUWPHQW%XVLQHVV
6\VWHPVDQG$QDO\WLFVLQUHVSRQVHWRWKHWHFKQRORJ\DQGGDWDGULYHQFKDQJHVLQEXVLQHVVWRGD\
 $OOWKUHHRIXVEHQHILWIURPRXUPDQ\\HDUVWHDFKLQJXQGHUJUDGXDWHEXVLQHVVVXEMHFWVDQGWKH
GLYHUVLW\RILQWHUHVWVDQGHIIRUWVRIRXUSDVWFRDXWKRUV0DUN%HUHQVRQDQG7LPRWK\.UHKELHO7ZRRIXV
6WHSKDQDQG6]DEDW DOVREHQHILWIURPIRUPDOWUDLQLQJDQGEDFNJURXQGLQHGXFDWLRQDOPHWKRGVDQG
LQVWUXFWLRQDOGHVLJQ





&RS\ULJKW‹3HDUVRQ(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\ULJKW‹3HDUVRQ(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\ULJKW‹3HDUVRQ(GXFDWLRQ,QF