This is the first book to show the capabilities of Microsoft Excel to teach human resource management statistics effectively. It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical human resource management problems. If understanding statistics isn’t your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, this is the right book for you.
Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in human resource management courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. However, __Excel 2010 for Human Resource Management Statistics: A Guide to Solving Practical Problems__ is the first book to capitalize on these improvements by teaching students and managers how to apply Excel to statistical techniques necessary in their courses and work.
Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand human resource management problems. Practice problems are provided at the end of each chapter with their solutions in an Appendix. Separately, there is a full Practice Test (with answers in an Appendix) that allows readers to test what they have learned.
Includes 159 illustrations in color
Suitable for undergraduate and graduate students

lgli/G:\!genesis\_add\!woodhead\Springer\bok%3A978-3-319-10650-2.pdf

lgrsnf/G:\!genesis\_add\!woodhead\Springer\bok%3A978-3-319-10650-2.pdf

nexusstc/Excel 2010 for Human Resource Management Statistics: A Guide to Solving Practical Problems/f5a144d21fd0c21457c225789e5733e4.pdf

scihub/10.1007/978-3-319-10650-2.pdf

zlib/Mathematics/Thomas J Quirk, Julie Palmer-Schuyler (auth.)/Excel 2010 for Human Resource Management Statistics: A Guide to Solving Practical Problems_2486406.pdf

Thomas J. Quirk, Julie Palmer-Schuyler, Thomas J. Quirk

Quirk, Thomas J, Palmer-Schuyler, Julie

Adobe InDesign CS6 (Windows)

Springer Nature Switzerland AG

Springer London, Limited

Springer Nature (Textbooks & Major Reference Works), Cham, 2014

Excel for statistics, Cham, 2014

Switzerland, Switzerland

Nov 07, 2014

sm36385368

producers:
Adobe PDF Library 10.0.1

{"edition":"1","isbns":["331910649X","3319106503","9783319106496","9783319106502"],"last_page":261,"publisher":"Springer","series":"Excel for Statistics"}

Source title: Excel 2010 for Human Resource Management Statistics: A Guide to Solving Practical Problems (Excel for Statistics)

Preface 8
Acknowledgements 12
Contents 14
Chapter 1: Sample Size, Mean, Standard Deviation, and Standard Error of the Mean 19
1.1 Mean 19
1.2 Standard Deviation 20
1.3 Standard Error of the Mean 21
1.4 Sample Size, Mean, Standard Deviation, and Standard Error of the Mean 22
1.4.1 Using the Fill/Series/Columns Commands 22
1.4.2 Changing the Width of a Column 23
1.4.3 Centering Information in a Range of Cells 24
1.4.4 Naming a Range of Cells 26
1.4.5 Finding the Sample Size Using the=COUNT Function 27
1.4.6 Finding the Mean Score Using the =AVERAGE Function 27
1.4.7 Finding the Standard Deviation Using the =STDEV Function 28
1.4.8 Finding the Standard Error of the Mean 28
1.4.8.1 Formatting Numbers in Number Format (2 Decimal Places) 29
1.5 Saving a Spreadsheet 30
1.6 Printing a Spreadsheet 32
1.7 Formatting Numbers in Currency Format (2 Decimal Places) 33
1.8 Formatting Numbers in Number Format (3 Decimal Places) 35
1.9 End-of-Chapter Practice Problems 35
References 38
Chapter 2: Random Number Generator 39
2.1 Creating Frame Numbers for Generating Random Numbers 39
2.2 Creating Random Numbers in an Excel Worksheet 43
2.3 Sorting Frame Numbers into a Random Sequence 44
2.4 Printing an Excel File So That All of the Information Fits onto One Page 49
2.5 End-of-Chapter Practice Problems 52
Chapter 3: Confidence Interval About The Mean Using the TINV Function and Hypothesis Testing 54
3.1 Confidence Interval About the Mean 54
3.1.1 How to Estimate the Population Mean 54
3.1.2 Estimating the Lower Limit and the Upper Limit of the 95 Percent Confidence Interval About the Mean 55
3.1.3 Estimating the Confidence Interval for TIME TO FILL 56
3.1.4 Where Did the Number ``1.96 ́ ́ Come From? 57
3.1.5 Finding the Value for t in the Confidence Interval Formula 58
3.1.6 Using Excel ́s TINV Function to Find the Confidence Interval About the Mean 59
3.1.7 Using Excel to Find the 95 Percent Confidence Interval for TIME TO FILL 59
3.2 Hypothesis Testing 67
3.2.1 Hypotheses Always Refer to the Population That You Are Studying 68
3.2.2 The Null Hypothesis and the Research (Alternative) Hypothesis 69
3.2.2.1 Determining the Null Hypothesis and the Research Hypothesis When Rating Scales are Used 70
3.2.3 The 7 Steps for Hypothesis-Testing Using the Confidence Interval About the Mean 73
3.2.3.1 STEP 1: State the Null Hypothesis and the Research Hypothesis 73
3.2.3.2 STEP 2: Select the Appropriate Statistical Test 73
3.2.3.3 STEP 3: Calculate the Formula for the Statistical Test 73
3.2.3.4 STEP 4: Draw a Picture of the Confidence Interval about the Mean, Including the Mean, the Lower Limit of the Interval,... 74
3.2.3.5 STEP 5: Decide on a Decision Rule 74
3.2.3.6 STEP 6: State the Result of your Statistical Test 74
3.2.3.7 STEP 7: State the Conclusion of your Statistical Test in Plain English! 74
3.3 Alternative Ways to Summarize the Result of a Hypothesis Test 79
3.3.1 Different Ways to Accept the Null Hypothesis 79
3.3.2 Different Ways to Reject the Null Hypothesis 80
3.4 End-of-Chapter Practice Problems 80
References 86
Chapter 4: One-Group t-Test for the Mean 87
4.1 The 7 Steps for Hypothesis-Testing Using the One-Group t-Test 87
4.1.1 STEP 1: State the Null Hypothesis and the Research Hypothesis 88
4.1.2 STEP 2: Select the Appropriate Statistical Test 88
4.1.3 STEP 3: Decide on a Decision Rule for the One-Group t-Test 88
4.1.3.1 Finding the Absolute Value of a Number 89
4.1.4 STEP 4: Calculate the Formula for the One-Group t-Test 89
4.1.5 STEP 5: Find the Critical Value of t in the t-Table in Appendix E 90
4.1.6 STEP 6: State the Result of Your Statistical Test 91
4.1.7 STEP 7: State the Conclusion of Your Statistical Test in Plain English! 91
4.2 One-Group t-Test for the Mean 91
4.3 Can You Use Either the 95 Percent Confidence Interval About the Mean OR the One-Group t-Test When Testing Hypotheses? 98
4.4 End-of-Chapter Practice Problems 98
References 102
Chapter 5: Two-Group t-Test of the Difference of the Means for Independent Groups 103
5.1 The 9 STEPS for Hypothesis-Testing Using the Two-Group t-Test 104
5.1.1 STEP 1: Name One Group, Group 1, and the Other Group, Group 2 104
5.1.2 STEP 2: Create a Table that Summarizes the Sample Size, Mean Score, and Standard Deviation of Each Group 104
5.1.3 STEP 3: State the Null Hypothesis and the Research Hypothesis for the Two-Group t-Test 106
5.1.4 STEP 4: Select the Appropriate Statistical Test 106
5.1.5 STEP 5: Decide on a Decision Rule for the Two-Group t-Test 106
5.1.6 STEP 6: Calculate the Formula for the Two-Group t-Test 106
5.1.7 STEP 7: Find the Critical Value of t in the t-Table in Appendix E 107
5.1.7.1 Finding the Degrees of Freedom (df) for the Two-Group t-Test 107
5.1.8 STEP 8: State the Result of Your Statistical Test 108
5.1.9 STEP 9: State the Conclusion of Your Statistical Test in Plain English! 108
5.1.9.1 Writing the Conclusion of the Two-Group t-Test When You Accept the Null Hypothesis 108
5.1.9.2 Writing the Conclusion of the Two-Group t-Test When You Reject the Null Hypothesis and Accept the Research Hypothesis 110
5.2 Formula #1: Both Groups Have a Sample Size Greater Than 30 112
5.2.1 An example of Formula #1 for the Two-Group t-Test 113
5.3 Formula #2: One or Both Groups Have a Sample Size Less Than 30 121
5.4 End-of-Chapter Practice Problems 128
References 131
Chapter 6: Correlation and Simple Linear Regression 132
6.1 What Is a ``Correlation? ́ ́ 132
6.1.1 Understanding the Formula for Computing a Correlation 137
6.1.2 Understanding the Nine Steps for Computing a Correlation, r 138
6.2 Using Excel to Compute a Correlation Between Two Variables 140
6.3 Creating a Chart and Drawing the Regression Line onto the Chart 145
6.3.1 Using Excel to Create a Chart and the Regression Line Through the Data Points 146
6.3.1.1 Moving the Chart Below the Table in the Spreadsheet 150
6.3.1.2 Making the Chart ``Longer ́ ́ so that it is ``Taller ́ ́ 152
6.3.1.3 Making the Chart ``Wider ́ ́ 152
6.3.1.4 Drawing the Regression Line Through the Data Points in the Chart 153
6.4 Printing a Spreadsheet So That the Table and Chart Fit onto One Page 155
6.5 Finding the Regression Equation 157
6.5.1 Installing the Data Analysis ToolPak into Excel 157
6.5.1.1 Installing the Data Analysis ToolPak into Excel 2010 157
6.5.1.2 Installing the Data Analysis ToolPak into Excel 2007 158
6.5.1.3 Installing the Data Analysis ToolPak into Excel 2003 158
6.5.2 Using Excel to Find the SUMMARY OUTPUT of Regression 159
6.5.2.1 Finding the y-Intercept, a, of the Regression Line 163
6.5.2.2 Finding the Slope, b, of the Regression Line 163
6.5.3 Finding the Equation for the Regression Line 164
6.5.4 Using the Regression Line to Predict the y-Value for a Given x-Value 164
6.6 Adding the Regression Equation to the Chart 165
6.7 How to Recognize Negative Correlations in the SUMMARY OUTPUT Table 169
6.8 Printing Only Part of a Spreadsheet Instead of the Entire Spreadsheet 169
6.8.1 Printing Only the Table and the Chart on a Separate Page 170
6.8.2 Printing Only the Chart on a Separate Page 170
6.8.3 Printing Only the SUMMARY OUTPUT of the Regression Analysis on a Separate Page 171
6.9 End-of-Chapter Practice Problems 171
References 177
Chapter 7: Multiple Correlation and Multiple Regression 179
7.1 Multiple Regression Equation 179
7.2 Finding the Multiple Correlation and the Multiple Regression Equation 182
7.3 Using the Regression Equation to Predict FIRST-YEAR GPA 187
7.4 Using Excel to Create a Correlation Matrix in Multiple Regression 187
7.5 End-of-Chapter Practice Problems 191
References 196
Chapter 8: One-Way Analysis of Variance (ANOVA) 197
8.1 Using Excel to Perform a One-Way Analysis of Variance (ANOVA) 199
8.2 How to Interpret the ANOVA Table Correctly 202
8.3 Using the Decision Rule for the ANOVA F-Test 203
8.4 Testing for the Difference Between Two Groups Using the ANOVA t-Test 204
8.4.1 Comparing Division B vs. Division C in Job Satisfaction Using the ANOVA t-Test 204
8.4.1.1 Finding the Degrees of Freedom for the ANOVA t-Test 206
8.4.1.2 Stating the Decision Rule for the ANOVA t-Test 206
8.4.1.3 Performing an ANOVA t-Test Using Excel Commands 207
8.5 End-of-Chapter Practice Problems 209
References 214
Appendix A: Answers to End-of-Chapter Practice Problems 215
Appendix B: Practice Test 247
Appendix C: Answers to Practice Test 259
Appendix D: Statistical Formulas 269
Appendix E: t-Table 271
Index 273

This is the first book to show the capabilities of Microsoft Excel to teach human resource management statistics effectively. It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical human resource management problems. If understanding statistics isn’t your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, this is the right book for you. Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in human resource management courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. However, Excel 2010 for Human Resource Management Statistics: A Guide to Solving Practical Problems is the first book to capitalize on these improvements by teaching students and managers how to apply Excel to statistical techniques necessary in their courses and work. Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand human resource management problems. Practice problems are provided at the end of each chapter with their solutions in an Appendix. Separately, there is a full Practice Test (with answers in an Appendix) that allows readers to test what they have learned.Includes 159 illustrations in colorSuitable for undergraduate and graduate students
Erscheinungsdatum: 18.12.2014

This is the first book to show the capabilities of Microsoft Excel to teach human resource management statistics effectively. It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical human resource management problems. If understanding statistics isn't your strongest suit, you are not especially mathematically-inclined, or if you are wary of computers, this is the right book for you. Excel, a widely available computer program for students and managers, is also an effective teaching and learning tool for quantitative analyses in human resource management courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. However, Excel 2010 for Human Resource Management Statistics: A Guide to Solving Practical Problems is the first book to capitalize on these improvements by teaching students and managers how to apply Excel to statistical techniques necessary in their courses and work. Each chapter explains statistical formulas and directs the reader to use Excel commands to solve specific, easy-to-understand human resource management problems. Practice problems are provided at the end of each chapter with their solutions in an Appendix. Separately, there is a full Practice Test (with answers in an Appendix) that allows readers to test what they have learned. Includes 159 illustrations in color Suitable for undergraduate and graduate students -- Book jacket

Front Matter....Pages i-xvii
Sample Size, Mean, Standard Deviation, and Standard Error of the Mean....Pages 1-20
Random Number Generator....Pages 21-35
Confidence Interval About The Mean Using the TINV Function and Hypothesis Testing....Pages 37-69
One-Group t-Test for the Mean....Pages 71-86
Two-Group t-Test of the Difference of the Means for Independent Groups....Pages 87-115
Correlation and Simple Linear Regression....Pages 117-163
Multiple Correlation and Multiple Regression....Pages 165-182
One-Way Analysis of Variance (ANOVA)....Pages 183-200
Back Matter....Pages 201-261

2015-02-17