Excel 2016 for Human Resource Management Statistics: A Guide to Solving Practical Problems PDF
Preview Excel 2016 for Human Resource Management Statistics: A Guide to Solving Practical Problems
Excel for Statistics Thomas J. Quirk Julie Palmer-Schuyler Excel 2016 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 2016, Excel 2013, Excel 2010 and Excel 2007. The approach also teaches critical statistics skills, making the books particularly applicable for statistics coursestaughtoutsideofmathematicsorstatisticsdepartments. Serieseditor:ThomasJ.Quirk Thefollowingbooksareinthisseries: T.J.Quirk,Excel2016forEngineeringStatistics:AGuidetoSolvingPracticalProblems,Excel forStatistics.SpringerInternationalPublishingSwitzerland2016. T.J.Quirk,Excel2016forBusinessStatistics:AGuidetoSolvingPracticalProblems,Excelfor Statistics.SpringerInternationalPublishingSwitzerland2016. T.J.Quirk,M.Quirk,H.F.Horton,Excel2016forBiologicalandLifeSciencesStatistics:AGuideto SolvingPracticalProblems,ExcelforStatistics.SpringerInternationalPublishing2016. T.J.Quirk,M.Quirk,H.F.Horton,Excel2016forPhysicalSciencesStatistics:AGuidetoSolving PracticalProblems,ExcelforStatistics.SpringerInternationalPublishing2016. T.J.Quirk,E.Rhiney,Excel2016forMarketingStatistics:AGuidetoSolvingPracticalProblems, ExcelforStatistics.SpringerInternationalPublishingSwitzerland2016. T.J.Quirk.Excel2016forEducationalandPsychologicalStatistics:AGuidetoSolvingPractical Problems,ExcelforStatistics.SpringerInternationalPublishingSwitzerland2016. T.J. Quirk, Excel 2016 for Social Science Statistics: A Guide to Solving Practical Problems, ExcelforStatistics.SpringerInternationalPublishingSwitzerland2016. T.J.Quirk,S.Cummings,Excel2016forHealthServicesManagementStatistics:AGuidetoSolving PracticalProblems.ExcelforStatistics.SpringerInternationalPublishingSwitzerland2016. T.J.Quirk,J.Palmer-Schuyler,Excel2016forHumanResourceManagementStatistics:AGuideto SolvingPracticalProblems,ExcelforStatistics.SpringerInternationalPublishingSwitzerland2016. T.J.Quirk,M.Quirk,H.F.Horton.Excel2016forEnvironmentalSciencesStatistics:AGuideto SolvingPracticalProblems,ExcelforStatistics.SpringerInternationalPublishingSwitzerland2016. T.J.Quirk,J.Palmer-Schuyler,Excel2013forHumanResourceManagementStatistics:AGuideto SolvingPracticalProblems,ExcelforStatistics.SpringerInternationalPublishingSwitzerland2016. T.J. Quirk, S. Cummings, Excel 2013 for Health Services Management Statistics: A Guide to Solving Practical Problems. Excel for Statistics. Springer International Publishing Switzerland 2016. T.J.Quirk,M.Quirk,H.F.Horton,Excel2013forPhysicalSciencesStatistics:AGuidetoSolving PracticalProblems.ExcelforStatistics.SpringerInternationalPublishingSwitzerland2016. T.J.Quirk.Excel2013forEducationalandPsychologicalStatistics:AGuidetoSolvingPractical Problems,ExcelforStatistics.SpringerInternationalPublishingSwitzerland2015. T.J.Quirk,M.Quirk,H.F.Horton,Excel2013forBiologicalandLifeSciencesStatistics:AGuideto SolvingPracticalProblems,ExcelforStatistics.SpringerInternationalPublishing2015. T.J.Quirk,Excel2013forSocialScienceStatistics:AGuidetoSolvingPracticalProblems,Excel forStatistics.SpringerInternationalPublishingSwitzerland2015. 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 2016 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-40062-4 ISBN978-3-319-40063-1 (eBook) DOI10.1007/978-3-319-40063-1 LibraryofCongressControlNumber:2016941690 ©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. I salute them all, and I thank them for helping 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 2016 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 andpractical,butalsoeasytocomprehendandapply. Uniquefeaturesofthisbook: • Youwillbetoldeachstepoftheway,notonlyhowtouseExcel,butalsowhy youaredoingeachstepsothatyoucanunderstandwhatyouaredoingandnot merelylearnhowtousestatisticaltestsbyrote. • Includes specific objectives embedded in the text for each concept, so you can knowthepurposeoftheExcelsteps. • Includes 162 color screenshots so that you can be sure you are performing the 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. Prof.TomQuirk,acurrentProfessorofMarketingattheGeorgeHerbertWalker School of Business and Technology at Webster University in St. Louis, Missouri (USA), teaches Marketing Statistics, Marketing Research, and Pricing Strategies. At the beginning of his academic career, Prof. Quirk spent 6 years in educational researchattheAmericanInstitutesforResearchandEducationalTestingService. He has published articles in the Journal of Educational Psychology, Journal of Educational Research, Review of Educational Research, Journal of Educational Measurement, Educational Technology, The Elementary School Journal, Journal ofSecondaryEducation,EducationalHorizons,andPhiDeltaKappan.Inaddition, Professor Quirk has published more than 20 articles in professional journals and presentedmorethan20papersatprofessionalmeetings,includingannualmeetings of the American Educational Research Association, the American Psychological Association, and the National Council on Measurement in Education. He holds a B.S.inMathematicsfromJohnCarrollUniversity,bothanM.A.inEducationanda Ph.D.inEducationalPsychologyfromStanfordUniversity,andanM.B.A.fromthe UniversityofMissouri-St.Louis. Prof. “J.P.” Palmer-Schuyler is currently an Associate Professor of Human Resource Management at the Walker School of Business and Technology at Webster University in St. Louis, Missouri, USA, where she teaches Human Resource Management as well as Organizational Behavior at the master’s and doctoral level. She received her M.B.A. from the University of Nebraska-Lincoln and her Ph.D. from the University of Missouri-Columbia in Management. Her teaching awards include the Donald K. Anderson Graduate Student Teaching AwardattheUniversityofMissouriandtheWilliamT.KemperAwardatWebster Preface ix University.SheisalsoagraduateoftheProgramforExcellenceinTeachingatthe University of Missouri. Her pedagogical research over the past 12 years includes articlesinAcademyofBusinessDisciplinesJournalandRegionalBusinessReview, andshehasmadeconferencepresentationsattheOrganizationalBehaviorTeach- ing Conference, Academy of Management, Society for Industrial and Organiza- tional Psychology, Southwest Academy of Management, Western Academy of Management,andSocietyforAdvancementofManagement. St.Louis,MO,USA ThomasJ.Quirk St.Louis,MO,USA JuliePalmer-Schuyler
The list of books you might like
