Excel 2016 for Human Resource Management Statistics: A Guide to Solving Practical Problems

272 Pages·2016·12.27 MB·English

by  Thomas J. Quirk

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
Excel for Statistics is a series of textbooks that explain how to use Excel to solve
statistics problems in various fields of study. Professors, students, and practitioners
will find these books teach how to make Excel work best in their respective field.
Applications include any discipline that uses data and can benefit from the power
and simplicity of Excel. Books cover all the steps for running statistical analyses in
Excel 2016, Excel 2013, Excel 2010 and Excel 2007. The approach also teaches
critical statistics skills, making the books particularly applicable for statistics
courses taught outside of mathematics or statistics departments.
Series editor: Thomas J. Quirk
The following books are in this series:
T.J. Quirk, Excel 2016 for Engineering Statistics: A Guide to Solving Practical Problems, Excel
for Statistics. Springer International Publishing Switzerland 2016.
T.J. Quirk, Excel 2016 for Business Statistics: A Guide to Solving Practical Problems, Excel for
Statistics. Springer International Publishing Switzerland 2016.
T.J. Quirk, M. Quirk, H.F. Horton, Excel 2016 for Biological and Life Sciences Statistics: A Guide to
Solving Practical Problems, Excel for Statistics. Springer International Publishing 2016.
T.J. Quirk, M. Quirk, H.F. Horton, Excel 2016 for Physical Sciences Statistics: A Guide to Solving
Practical Problems, Excel for Statistics. Springer International Publishing 2016.
T.J. Quirk, E. Rhiney, Excel 2016 for Marketing Statistics: A Guide to Solving Practical Problems,
Excel for Statistics. Springer International Publishing Switzerland 2016.
T.J. Quirk. Excel 2016 for Educational and Psychological Statistics: A Guide to Solving Practical
Problems, Excel for Statistics. Springer International Publishing Switzerland 2016.
T.J. Quirk, Excel 2016 for Social Science Statistics: A Guide to Solving Practical Problems,
Excel for Statistics. Springer International Publishing Switzerland 2016.
T.J. Quirk, S. Cummings, Excel 2016 for Health Services Management Statistics: A Guide to Solving
Practical Problems. Excel for Statistics. Springer International Publishing Switzerland 2016.
T.J. Quirk, J. Palmer-Schuyler, Excel 2016 for Human Resource Management Statistics: A Guide to
Solving Practical Problems, Excel for Statistics. Springer International Publishing Switzerland 2016.
T.J. Quirk, M. Quirk, H.F. Horton. Excel 2016 for Environmental Sciences Statistics: A Guide to
Solving Practical Problems, Excel for Statistics. Springer International Publishing Switzerland 2016.
T.J. Quirk, J. Palmer-Schuyler, Excel 2013 for Human Resource Management Statistics: A Guide to
Solving Practical Problems, Excel for Statistics. Springer International Publishing Switzerland 2016.
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, Excel 2013 for Physical Sciences Statistics: A Guide to Solving
Practical Problems. Excel for Statistics. Springer International Publishing Switzerland 2016.
T.J. Quirk. Excel 2013 for Educational and Psychological Statistics: A Guide to Solving Practical
Problems, Excel for Statistics. Springer International Publishing Switzerland 2015.
T.J. Quirk, M. Quirk, H.F. Horton, Excel 2013 for Biological and Life Sciences Statistics: A Guide to
Solving Practical Problems, Excel for Statistics. Springer International Publishing 2015.
T.J. Quirk, Excel 2013 for Social Science Statistics: A Guide to Solving Practical Problems, Excel
for Statistics. Springer International Publishing Switzerland 2015.
Additional Statistics books by Dr. Tom Quirk that have been published by Springer
T.J. Quirk, Excel 2010 for Engineering Statistics: A Guide to Solving Practical Problems, Springer
International Publishing Switzerland 2014.
T.J. Quirk, S. Cummings, Excel 2010 for Health Services Management Statistics: A Guide to
Solving Practical Problems, Springer International Publishing Switzerland 2014.
T.J. Quirk, M. Quirk, H. Horton, Excel 2010 for Physical Sciences Statistics: A Guide to Solving
Practical Problems, Springer International Publishing Switzerland 2013.
T.J. Quirk, M. Quirk, H.F. Horton, Excel 2010 for Biological and Life Sciences Statistics: A Guide
to Solving Practical Problems, Springer Science+Business Media New York 2013.
T.J. Quirk, M. Quirk, H.F. Horton, Excel 2007 for Biological and Life Sciences Statistics: A Guide
to Solving Practical Problems, Springer Science+Business Media New York 2013.
T.J. Quirk, Excel 2010 for Social Science Statistics: A Guide to Solving Practical Problems,
Springer Science+Business Media New York 2012.
T.J. Quirk, Excel 2010 for Educational and Psychological Statistics: A Guide to Solving Practical
Problems, Springer Science+Business Media New York 2012.
T.J. Quirk, Excel 2007 for Business Statistics: A Guide to Solving Practical Problems, Springer
Science+Business Media New York 2012.
T.J. Quirk, Excel 2007 for Social Science Statistics: A Guide to Solving Practical Problems,
Springer Science+Business Media New York 2012.
T.J. Quirk, Excel 2007 for Educational and Psychological Statistics: A Guide to Solving Practical
Problems, Springer Science+Business Media New York 2012.
T.J. Quirk, Excel 2010 for Business Statistics: A Guide to Solving Practical Problems, Springer
Science+Business Media 2011.
More information about this series at http://www.springer.com/series/13491
Thomas J. Quirk • Julie Palmer-Schuyler
Excel 2016 for Human
Resource Management
Statistics
A Guide to Solving Practical Problems
Thomas J. Quirk Julie Palmer-Schuyler
Webster University Webster University
St. Louis, MO, USA St. Louis, MO, USA
Excel for Statistics
ISBN 978-3-319-40062-4 ISBN 978-3-319-40063-1 (eBook)
DOI 10.1007/978-3-319-40063-1
Library of Congress Control Number: 2016941690
© Springer International Publishing Switzerland 2016
This work is subject to copyright. All rights are reserved by the Publisher, whether the whole or part of
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
dissimilar methodology now known or hereafter developed.
The use of general descriptive names, registered names, trademarks, service marks, etc. in this
publication does not imply, even in the absence of a specific statement, that such names are exempt
from the relevant protective laws and regulations and therefore free for general use.
The publisher, the authors and the editors are safe to assume that the advice and information in this
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
herein or for any errors or omissions that may have been made.
Printed on acid-free paper
This Springer imprint is published by Springer Nature
The registered company is Springer International Publishing AG Switzerland
This book is dedicated to the more than 3,000
students I have taught at Webster University’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. I am especially grateful to those who
encouraged me to expand my horizons and
become proficient at multiple modes of
delivery. Every semester, many students leave
their footprints on my heart.
Julie Palmer-Schuyler
Preface
Excel 2016 for Human Resource Management Statistics: A Guide to Solving
Practical Problems is intended for anyone looking to learn the basics of applying
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
especially mathematically inclined, or if you are wary of computers, then this is the
right book for you.
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
practical problems in human resource management.
Excel is an easily available computer program for students, instructors, and
managers. It is also an effective teaching and learning tool for quantitative analyses
in human resource management courses. The powerful numerical computational
ability and the graphical functions available in Excel make learning statistics much
easier than in years past. However, this is the first book to show Excel’s capabilities
to more effectively teach human resource management statistics; it also focuses
exclusively on this topic in an effort to render the subject matter not only applicable
and practical, but also easy to comprehend and apply.
Unique features of this book:
• You will be told each step of the way, not only how to use Excel, but also why
you are doing each step so that you can understand what you are doing and not
merely learn how to use statistical tests by rote.
• Includes specific objectives embedded in the text for each concept, so you can
know the purpose of the Excel steps.
• Includes 162 color screenshots so that you can be sure you are performing the
Excel steps correctly.
• This book is a tool that can be used either by itself or along with any good
statistics book.
• Practical examples and problems are taken from human resource management.
vii
viii Preface
• Statistical theory and formulas are explained in clear language without bogging
you down in mathematical fine points.
• You will learn both how to write statistical formulas using Excel and how to use
Excel’s drop-down menus that will create the formulas for you.
• This book does not come with a CD of Excel files which you can upload to your
computer. Instead, you’ll be shown how to create each Excel file yourself. In a
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-
oping this important skill.
• Each chapter presents the steps needed to solve a practical human resource
management problem using Excel. In addition, there are three practice problems
at the end of each chapter so you can test your new knowledge of statistics. The
answers to these problems appear in Appendix A.
• A “Practice Test” is given in Appendix B to test your knowledge at the end of the
book. The answers to these practical human resource management problems
appear in Appendix C.
This book is appropriate for use in any course in human resource management
statistics (at both undergraduate and graduate levels) as well as for managers who
want to improve the usefulness of their Excel skills.
Prof. Tom Quirk, a current Professor of Marketing at the George Herbert Walker
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
research at the American Institutes for Research and Educational Testing Service.
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
of Secondary Education, Educational Horizons, and Phi Delta Kappan. In addition,
Professor Quirk has published more than 20 articles in professional journals and
presented more than 20 papers at professional meetings, including annual meetings
of the American Educational Research Association, the American Psychological
Association, and the National Council on Measurement in Education. He holds a
B.S. in Mathematics from John Carroll University, both an M.A. in Education and a
Ph.D. in Educational Psychology from Stanford University, and anM.B.A. from the
University of Missouri-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
Award at the University of Missouri and the William T. Kemper Award at Webster
Preface ix
University. She is also a graduate of the Program for Excellence in Teaching at the
University of Missouri. Her pedagogical research over the past 12 years includes
articles in Academy of Business Disciplines Journal and Regional Business Review,
and she has made conference presentations at the Organizational Behavior Teach-
ing Conference, Academy of Management, Society for Industrial and Organiza-
tional Psychology, Southwest Academy of Management, Western Academy of
Management, and Society for Advancement of Management.
St. Louis, MO, USA Thomas J. Quirk
St. Louis, MO, USA Julie Palmer-Schuyler