Excel 2013 for Human Resource Management Statistics: A Guide to Solving Practical Problem

265 Pages·10.827 MB·English

by  Quirk T.J., Palmer-Schuyler J.

Excel for Statistics
Thomas J. Quirk
Julie Palmer-Schuyler
Excel 2013 for
Human Resource
Management
Statistics
A Guide to Solving Practical Problems
Excel for Statistics
ExcelforStatisticsisaseriesoftextbooksthatexplainhowtouseExceltosolve
statisticsproblemsinvariousfieldsofstudy.Professors,students,andpractitioners
will findthesebooksteachhow tomakeExcel work best intheir respective field.
Applications include any discipline that uses data and can benefit from the power
andsimplicityofExcel.Bookscoverallthestepsforrunningstatisticalanalysesin
Excel 2013, Excel 2010 and Excel 2007. The approach also teaches critical
statistics skills, making the books particularly applicable for statistics courses
taughtoutsideofmathematicsorstatisticsdepartments.
Serieseditor:ThomasJ.Quirk
Thefollowingbooksareinthisseries:
T.J.Quirk,J.Palmer-Schuyler,Excel2013forHumanResourceManagementStatistics:AGuide
to Solving Practical Problems, Excel for Statistics. Springer International Publishing
Switzerland2016.
T.J. Quirk, S. Cummings, Excel 2013 for Health Services Management Statistics: A Guide to
Solving Practical Problems. Excel for Statistics. Springer International Publishing
Switzerland2016.
T.J.Quirk,M.Quirk,H.F.Horton,Excel2013forPhysicalSciencesStatistics:AGuidetoSolving
PracticalProblems.ExcelforStatistics.SpringerInternationalPublishingSwitzerland2016.
T.J. Quirk, J. Palmer-Schuyler, Excel 2010 for Human Resource Management Statistics:
A Guide to Solving Practical Problems, Excel for Statistics. Springer International Publishing
Switzerland2014.
T.J.Quirk,Excel2013forBusinessStatistics:AGuidetoSolvingPracticalProblems,Excelfor
Statistics.SpringerInternationalPublishingSwitzerland2015.
T.J.Quirk,M.Quirk,H.F.Horton,Excel2013forBiologicalandLifeSciencesStatistics:AGuide
to Solving Practical Problems, Excel for Statistics. Springer International Publishing
Switzerland2015.
T.J.Quirk,Excel2013forSocialScienceStatistics:AGuidetoSolvingPracticalProblems,Excel
forStatistics.SpringerInternationalPublishingSwitzerland2015.
T.J.Quirk.Excel2013forEngineeringStatistics:AGuidetoSolvingPracticalProblems,Excel
forStatistics.SpringerInternationalPublishingSwitzerland2015.
T.J.Quirk.Excel2013forEducationalandPsychologicalStatistics:AGuidetoSolvingPractical
Problems,ExcelforStatistics.SpringerInternationalPublishingSwitzerland2015.
T.J. Quirk, M. Quirk, H.F. Horton, Excel 2013 for Environmental Sciences Statistics: A Guide
to Solving Practical Problems, Excel for Statistics. Springer International Publishing
Switzerland2015.
T.J. Quirk, M. Quirk, H.F. Horton, Excel 2010 for Environmental Sciences Statistics: A Guide
to Solving Practical Problems, Excel for Statistics. Springer International Publishing
Switzerland2015.
AdditionalStatisticsbooksbyDr.TomQuirkthathavebeenpublishedbySpringer
T.J.Quirk.Excel2010forEngineeringStatistics:AGuidetoSolvingPracticalProblems.Springer
InternationalPublishingSwitzerland2014.
T.J. Quirk, S. Cummings, Excel 2010 for Health Services Management Statistics: A Guide to
SolvingPracticalProblems.SpringerInternationalPublishingSwitzerland2014.
T.J.Quirk,M.Quirk,H.Horton,Excel2010forPhysicalSciencesStatistics:AGuidetoSolving
PracticalProblems.SpringerInternationalPublishingSwitzerland2013.
T.J.Quirk,M.Quirk,H.F.Horton,Excel2010forBiologicalandLifeSciencesStatistics:AGuide
toSolvingPracticalProblems.SpringerScience+BusinessMediaNewYork2013.
T.J.Quirk,M.Quirk,H.F.Horton,Excel2007forBiologicalandLifeSciencesStatistics:AGuide
toSolvingPracticalProblems.SpringerScience+BusinessMediaNewYork2013.
T.J. Quirk, Excel 2010 for Social Science Statistics: A Guide to Solving Practical Problems.
SpringerScience+BusinessMediaNewYork2012.
T.J.Quirk,Excel2010forEducationalandPsychologicalStatistics:AGuidetoSolvingPractical
Problems.SpringerScience+BusinessMediaNewYork2012.
T.J.Quirk,Excel2007forBusinessStatistics:AGuidetoSolvingPracticalProblems.Springer
Science+BusinessMediaNewYork2012.
T.J. Quirk, Excel 2007 for Social Science Statistics: A Guide to Solving Practical Problems.
SpringerScience+BusinessMediaNewYork2012.
T.J.Quirk,Excel2007forEducationalandPsychologicalStatistics:AGuidetoSolvingPractical
Problems.SpringerScience+BusinessMediaNewYork2012.
T.J.Quirk,Excel2010forBusinessStatistics:AGuidetoSolvingPracticalProblems.Springer
Science+BusinessMedia2011.
Moreinformationaboutthisseriesathttp://www.springer.com/series/13491
Thomas J. Quirk • Julie Palmer-Schuyler
Excel 2013
for Human Resource
Management Statistics
A Guide to Solving Practical Problems
ThomasJ.Quirk JuliePalmer-Schuyler
WebsterUniversity WebsterUniversity
St.Louis,MO,USA St.Louis,MO,USA
ExcelforStatistics
ISBN978-3-319-28981-6 ISBN978-3-319-28982-3 (eBook)
DOI10.1007/978-3-319-28982-3
LibraryofCongressControlNumber:2016930832
©SpringerInternationalPublishingSwitzerland2016
Thisworkissubjecttocopyright.AllrightsarereservedbythePublisher,whetherthewholeorpartof
the material is concerned, specifically the rights of translation, reprinting, reuse of illustrations,
recitation, broadcasting, reproduction on microfilms or in any other physical way, and transmission
or information storage and retrieval, electronic adaptation, computer software, or by similar or
dissimilarmethodologynowknownorhereafterdeveloped.
The use of general descriptive names, registered names, trademarks, service marks, etc. in this
publicationdoesnotimply,evenintheabsenceofaspecificstatement,thatsuchnamesareexempt
fromtherelevantprotectivelawsandregulationsandthereforefreeforgeneraluse.
Thepublisher,theauthorsandtheeditorsaresafetoassumethattheadviceandinformationinthis
book are believed to be true and accurate at the date of publication. Neither the publisher nor the
authors or the editors give a warranty, express or implied, with respect to the material contained
hereinorforanyerrorsoromissionsthatmayhavebeenmade.
Printedonacid-freepaper
ThisSpringerimprintispublishedbySpringerNature
TheregisteredcompanyisSpringerInternationalPublishingAGSwitzerland
Thisbookisdedicatedtothemorethan3,000
studentsIhavetaughtatWebsterUniversity’s
campuses in St. Louis, London, and Vienna;
the students at Principia College in Elsah,
Illinois; and the students at the Cooperative
State University of Baden-Wuerttemberg in
Heidenheim, Germany. These students taught
me a great deal about the art of teaching.
Isalutethemall,andIthankthemforhelping
me to become a better teacher.
Thomas J. Quirk
I am grateful to the hundreds of students at
Webster University, Radford University, and
the University of Missouri-Columbia who
have challenged me to strive to become the
best teacher, mentor, and faculty member
possible.Iamespeciallygratefultothosewho
encouraged me to expand my horizons and
become proficient at multiple modes of
delivery.Everysemester,manystudentsleave
their footprints on my heart.
Julie Palmer-Schuyler

Preface
Excel 2013 for Human Resource Management Statistics: A Guide to Solving
PracticalProblems is intendedfor anyone looking tolearn the basics ofapplying
Excel’s powerful statistical tools to their human resource management courses or
work activities. If understanding statistics isn’t your strongest suit, you are not
especiallymathematicallyinclined,orifyouarewaryofcomputers,thenthisisthe
rightbookforyou.
Here you’ll learn how to use key statistical tests using Excel without being
overpowered by the underlying statistical theory. This book clearly and methodi-
cally shows and explains how to create and use these statistical tests to solve
practicalproblemsinhumanresourcemanagement.
Excel is an easily available computer program for students, instructors, and
managers.Itisalsoaneffectiveteachingandlearningtoolforquantitativeanalyses
in human resource management courses. The powerful numerical computational
abilityandthegraphicalfunctionsavailableinExcelmakelearningstatisticsmuch
easierthaninyearspast.However,thisisthefirstbooktoshowExcel’scapabilities
to more effectively teach human resource management statistics; it also focuses
exclusivelyonthistopicinanefforttorenderthesubjectmatternotonlyapplicable
andpracticalbutalsoeasytocomprehendandapply.
Uniquefeaturesofthisbook:
• Youwillbetoldeachstepoftheway,notonlyhowtouseExcel,butalsowhy
youaredoingeachstepsothatyoucanunderstandwhatyouaredoing,andnot
merelylearnhowtousestatisticaltestsbyrote.
• Includes specific objectives embedded in the text for each concept, so you can
knowthepurposeoftheExcelsteps.
• Includes162colorscreenshotssothatyoucanbesureyouareperformingthe
Excelstepscorrectly.
• This book is a tool that can be used either by itself or along with any good
statisticsbook.
• Practicalexamplesandproblemsaretakenfromhumanresourcemanagement.
vii
viii Preface
• Statisticaltheoryandformulasareexplainedinclearlanguagewithoutbogging
youdowninmathematicalfinepoints.
• YouwilllearnbothhowtowritestatisticalformulasusingExcelandhowtouse
Excel’sdrop-downmenusthatwillcreatetheformulasforyou.
• ThisbookdoesnotcomewithaCDofExcelfileswhichyoucanuploadtoyour
computer.Instead,you’llbeshownhowtocreateeachExcelfileyourself.Ina
work situation, your colleagues will not give you an Excel file; you will be
expected to create your own. This book will give you ample practice in devel-
opingthisimportantskill.
• Each chapter presents the steps needed to solve a practical human resource
managementproblemusingExcel.Inaddition,therearethreepracticeproblems
attheendofeachchaptersoyoucantestyournewknowledgeofstatistics.The
answerstotheseproblemsappearinAppendixA.
• A“PracticeTest”isgiveninAppendixBtotestyourknowledgeattheendofthe
book. The answers to these practical human resource management problems
appearinAppendixC.
This book is appropriate for use in any course in human resource management
statistics(atbothundergraduateandgraduatelevels)aswellasformanagerswho
wanttoimprovetheusefulnessoftheirExcelskills.
St.Louis,MO ThomasJ.Quirk
JuliePalmer-Schuyler
Acknowledgments
Excel 2013 for Human Resource Management Statistics: A Guide to Solving
Practical Problems is the result of inspiration from three important people: my
two daughters and my wife. Jennifer Quirk McLaughlin invited me to visit her
MBA classes several times at the University of Witwatersrand in Johannesburg,
South Africa. These visits to a first-rate MBAprogram convinced me there was a
need for a book to teach students how to solve practical problems using Excel.
Meghan Quirk-Horton’s dogged dedication to learning the many statistical tech-
niquesneededtocompleteherPhDdissertationillustratedtheneedforastatistics
bookthatwouldmakethisdauntingtaskmoreuser-friendly.AndLynneBuckley-
Quirkwasthenumber-onecheerleaderforthisprojectfromthebeginning,always
encouragingmeandhelpingmeremaindedicatedtocompletingit.
Marc Strauss, our editor at Springer, caught the spirit of this idea in our first
phone conversation and shepherded this book through the idea stages until it
reached its final form. His encouragement and support were vital to this book
seeing the light of day. We thank him for being such an outstanding product
champion throughout this process. We also thank Christine Crigler at Springer
who did her usual first-rate job in coordinating the editing and production of this
book;sheisalwaysapleasuretoworkwith.
ThomasJ.Quirk
Excel 2013 for Human Resource Management Statistics: A Guide to Solving
Practical Problems began as an inquiry by my colleague, Prof. Tom Quirk, who
challengedmetofindagoodtextbookwhichwasaimedathelpingHRstudentsto
understand statistics. After much investigation, we both concluded that the field
was in need of a practical guide to help prepare our undergraduate and graduate
ix