Excel 2019 for Human Resource Management Statistics

Description

Excel 2019 for Human Resource Management Statistics

A Guide to Solving Practical Problems

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 fields.
Applications include any disciplines that use data and can benefit from the power and
simplicity of Excel. Books cover all the steps for running statistical analyses in Excel
2019, Excel 2016 and Excel 2013. The approach also teaches critical statistics skills,
making the books particularly applicable for statistics courses taught outside of mathematics
or statistics departments.

Excel 2019 for Human Resource Management Statistics: A Guide to Solving Practical
Problems updates the Excel steps and screenshots from the previously
published Excel 2016 for Human Resource Management Statistics: A Guide to
Solving Practical Problems, and it contains a number of important changes. The
explanations of statistics and statistical formulas have been made clearer. The Excel
steps now match perfectly the Excel 2019 version. Thirty percent of the end-ofchapter
problems, and their answers in an Appendix, are new to this book. Thirty
percent of the 160+ screenshots are new so that they match the new Excel commands
to ensure that you are using Excel correctly each step of the way.
The eight chapters in the book (Mean, Standard Deviation, and Standard Error of
the Mean; Random Sampling; Confidence Interval about the Mean; One-Group t-test;
Two-Group t-test; Correlation and Linear Regression; Multiple Correlation; and
One-Way Analysis of Variance) have been rewritten to improve their explanation of
statistics. The answers to all of the problems in the book are provided, and there is a
Practice Test so that you can test your ability to solve statistics problems using Excel.
This book is an introduction to statistics, not a full-blown explanation of statistics.
A word of caution: This book does not attempt to teach you all of the “bells and
whistles” of Excel 2019. We have left that objective to other books. Instead, this
book will teach you the Excel steps you need to solve the interesting problems in the
book. You should think of Excel as merely the “computer language” needed to solve
statistics problems. In a sense, this approach is similar to the one you would need if
you planned to spend a year living in Europe in Vienna, Austria, where you needed
to learn some basic German (e.g., “How much does this cost?” “Where is the train
station?” “Please give me the bill for my dinner” “How can I get to the airport?”) but
you do not need to become fluent in that language to survive. This book focuses on
the Excel steps needed to solve the problems in the book. The task of showing you
how to use the many powers of Excel is beyond the scope of this book.