This book shows the capabilities of Microsoft Excel in teaching educational and psychological statistics effectively. Similar to the previously published __Excel 2013 for Educational and Psychological Statistics__, this book is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical education and psychology 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 education and psychology courses. Its powerful computational ability and graphical functions make learning statistics much easier than in years past. However, __Excel 2016 for Educational and Psychological 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 educational and psychological 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.

lgli/K:\!genesis\!repository8\sp\10.1007%2F978-3-319-39720-7.pdf

lgrsnf/K:\!genesis\!repository8\sp\10.1007%2F978-3-319-39720-7.pdf

nexusstc/Excel 2016 for Educational and Psychological Statistics: A Guide to Solving Practical Problems/9a8be000ce91da54e495d7bb4af73a6a.pdf

scihub/10.1007/978-3-319-39720-7.pdf

zlib/Mathematics/Thomas J. Quirk (auth.)/Excel 2016 for Educational and Psychological Statistics: A Guide to Solving Practical Problems_2803250.pdf

Adobe InDesign CC 2015 (Windows)

Quirk, Thomas J.

Springer Nature Switzerland AG

Springer London, Limited

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

Excel for statistics, Switzerland, 2016

Excel for statistics, Cham, 2016

Switzerland, Switzerland

1st ed. 2016, US, 2016

Aug 10, 2016

sm59855114

producers:
Adobe PDF Library 15.0

{"edition":"1","isbns":["3319397192","3319397206","9783319397191","9783319397207"],"publisher":"Springer","series":"Excel for Statistics"}

Source title: Excel 2016 for Educational and Psychological Statistics: A Guide to Solving Practical Problems (Excel for Statistics)

Preface 8
Acknowledgments 10
Contents 12
Chapter 1: Sample Size, Mean, Standard Deviation, and Standard Error of the Mean 17
1.1 Mean 17
1.2 Standard Deviation 18
1.3 Standard Error of the Mean 19
1.4 Sample Size, Mean, Standard Deviation, and Standard Error of the Mean 20
1.4.1 Using the Fill/Series/Columns Commands 20
1.4.2 Changing the Width of a Column 22
1.4.3 Centering Information in a Range of Cells 23
1.4.4 Naming a Range of Cells 24
1.4.5 Finding the Sample Size Using the =COUNT Function 26
1.4.6 Finding the Mean Score Using the =AVERAGE Function 26
1.4.7 Finding the Standard Deviation Using the =STDEV Function 26
1.4.8 Finding the Standard Error of the Mean 27
1.4.8.1 Formatting Numbers in Number Format (Two Decimal Places) 27
1.5 Saving a Spreadsheet 29
1.6 Printing a Spreadsheet 30
1.7 Formatting Numbers in Currency Format (Two Decimal Places) 31
1.8 Formatting Numbers in Number Format (Three Decimal Places) 33
1.9 End-of-Chapter Practice Problems 34
Reference 37
Chapter 2: Random Number Generator 38
2.1 Creating Frame Numbers for Generating Random Numbers 38
2.2 Creating Random Numbers in an Excel Worksheet 42
2.3 Sorting Frame Numbers into a Random Sequence 43
2.4 Printing an Excel File So That All of the Information Fits onto One Page 47
2.5 End-of-Chapter Practice Problems 50
Reference 51
Chapter 3: Confidence Interval About the Mean Using the TINV Function and Hypothesis Testing 52
3.1 Confidence Interval About the Mean 52
3.1.1 How to Estimate the Population Mean 52
3.1.2 Estimating the Lower Limit and the Upper Limit of the 95% Confidence Interval About the Mean 53
3.1.3 Estimating the Confidence Interval the Chevy Impala in Miles Per Gallon 54
3.1.4 Where Did the Number ``1.96 ́ ́ Come From? 55
3.1.5 Finding the Value for t in the Confidence Interval Formula 56
3.1.6 Using Excel ́s TINV Function to Find the Confidence Interval About the Mean 57
3.1.7 Using Excel to find the 95% Confidence Interval for a Car ́s mpg Claim 57
3.2 Hypothesis Testing 63
3.2.1 Hypotheses Always Refer to the Population of People or Events that You Are Studying 64
3.2.2 The Null Hypothesis and the Research (Alternative) Hypothesis 65
3.2.2.1 Determining the Null Hypothesis and the Research Hypothesis When Rating Scales Are Used 65
3.2.3 The 7 Steps for Hypothesis-Testing Using the Confidence Interval About the Mean 68
3.2.3.1 STEP 1: State the Null Hypothesis and the Research Hypothesis 68
3.2.3.2 STEP 2: Select the Appropriate Statistical Test 68
3.2.3.3 STEP 3: Calculate the Formula for the Statistical Test 68
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,... 69
3.2.3.5 STEP 5: Decide on a Decision Rule 69
3.2.3.6 STEP 6: State the Result of Your Statistical Test 69
3.2.3.7 STEP 7: State the Conclusion of Your Statistical Test in Plain English! 69
3.3 Alternative Ways to Summarize the Result of a Hypothesis Test 74
3.3.1 Different Ways to Accept the Null Hypothesis 74
3.3.2 Different Ways to Reject the Null Hypothesis 75
3.4 End-of-Chapter Practice Problems 75
References 81
Chapter 4: One-Group t-Test for the Mean 82
4.1 The 7 STEPS for Hypothesis-Testing Using the One-Group t-Test 82
4.1.1 STEP 1: State the Null Hypothesis and the Research Hypothesis 83
4.1.2 STEP 2: Select the Appropriate Statistical Test 83
4.1.3 STEP 3: Decide on a Decision Rule for the One-Group t-Test 83
4.1.3.1 Finding the Absolute Value of a Number 83
4.1.4 STEP 4: Calculate the Formula for the One-Group t-Test 84
4.1.5 STEP 5: Find the Critical Value of t in the t-Table in Appendix E 85
4.1.6 STEP 6: State the Result of Your Statistical Test 86
4.1.7 STEP 7: State the Conclusion of Your Statistical Test in Plain English! 86
4.2 One-Group t-Test for the Mean 87
4.3 Can You Use Either the 95% Confidence Interval About the Mean OR the One-Group t-Test When Testing Hypotheses? 93
4.4 End-of-Chapter Practice Problems 93
References 99
Chapter 5: Two-Group t-Test of the Difference of the Means for Independent Groups 100
5.1 The 9 STEPS for Hypothesis-Testing Using the Two-Group t-Test 101
5.1.1 STEP 1: Name One Group, Group 1, and the Other Group, Group 2 101
5.1.2 STEP 2: Create a Table That Summarizes the Sample Size, Mean Score, and Standard Deviation of Each Group 101
5.1.3 STEP 3: State the Null Hypothesis and the Research Hypothesis for the Two-Group t-Test 103
5.1.4 STEP 4: Select the Appropriate Statistical Test 103
5.1.5 STEP 5: Decide on a Decision Rule for the Two-Group t-Test 103
5.1.6 STEP 6: Calculate the Formula for the Two-Group t-Test 104
5.1.7 STEP 7: Find the Critical Value of t in the t-Table in Appendix E 104
5.1.7.1 Finding The Degrees of Freedom (df) for the Two-Group t-Test 104
5.1.8 STEP 8: State the Result of Your Statistical Test 105
5.1.9 STEP 9: State the Conclusion of Your Statistical Test in Plain English! 105
5.1.9.1 Writing the Conclusion of the Two-Group t-Test When You Accept the Null Hypothesis 106
5.1.9.2 Writing the Conclusion of the Two-Group t-Test When You Reject the Null Hypothesis and Accept the Research Hypothesis 107
5.2 Formula #1: Both Groups Have More Than 30 People in Them 109
5.2.1 An Example of Formula #1 for the Two-Group t-Test 111
5.3 Formula #2: One or Both Groups Have Less Than 30 People in Them 117
5.3.1 End-of-Chapter Practice Problems 125
References 129
Chapter 6: Correlation and Simple Linear Regression 130
6.1 What Is a ``Correlation? ́ ́ 130
6.1.1 Understanding the Formula for Computing a Correlation 135
6.1.2 Understanding the Nine Steps for Computing a Correlation, r 135
6.2 Using Excel to Compute a Correlation Between Two Variables 137
6.3 Creating a Chart and Drawing the Regression Line onto the Chart 142
6.3.1 Using Excel to Create a Chart and the Regression Line Through the Data Points 144
6.3.1.1 Drawing the Regression Line Through the Data Points in the Chart 148
6.3.1.2 Moving the Chart Below the Table in the Spreadsheet 150
6.3.1.3 Making the Chart ``Longer ́ ́ So That It Is ``Taller ́ ́ 150
6.3.1.4 Making the Chart ``Wider ́ ́ 151
6.4 Printing a Spreadsheet So That the Table and Chart Fit onto One Page 152
6.5 Finding the Regression Equation 153
6.5.1 Installing the Data Analysis ToolPak into Excel 154
6.5.1.1 Installing the Data Analysis ToolPak into Excel 2016 154
6.5.1.2 Installing the Data Analysis ToolPak into Excel 2013 155
6.5.1.3 Installing the Data Analysis ToolPak into Excel 2010 156
6.5.1.4 Installing the Data Analysis ToolPak into Excel 2007 156
6.5.2 Using Excel to Find the SUMMARY OUTPUT of Regression 157
6.5.2.1 Finding the y-intercept, a, of the Regression Line 161
6.5.2.2 Finding the Slope, b, of the Regression Line 161
6.5.3 Finding the Equation for the Regression Line 161
6.5.4 Using the Regression Line to Predict the y-value for a Given x-value 162
6.6 Adding the Regression Equation to the Chart 163
6.7 How to Recognize Negative Correlations in the SUMMARY OUTPUT Table 166
6.8 Printing Only Part of a Spreadsheet Instead of the Entire Spreadsheet 166
6.8.1 Printing Only the Table and the Chart on a Separate Page 167
6.8.2 Printing Only the Chart on a Separate Page 167
6.8.3 Printing Only the SUMMARY OUTPUT of the Regression Analysis on a Separate Page 168
6.9 End-of-Chapter Practice Problems 168
References 173
Chapter 7: Multiple Correlation and Multiple Regression 174
7.1 Multiple Regression Equation 174
7.2 Finding the Multiple Correlation and the Multiple Regression Equation 177
7.3 Using the Regression Equation to Predict FROSH GPA 182
7.4 Using Excel to Create a Correlation Matrix in Multiple Regression 182
7.5 End-of-Chapter Practice Problems 186
References 192
Chapter 8: One-Way Analysis of Variance (ANOVA) 193
8.1 Using Excel to Perform a One-Way Analysis of Variance (ANOVA) 195
8.2 How to Interpret the ANOVA Table Correctly 197
8.3 Using the Decision Rule for the ANOVA F-Test 198
8.4 Testing the Difference Between Two Groups Using the ANOVA t-Test 199
8.4.1 Comparing LECTURES vs. INDEPENDENT in Their Exam Scores Using the ANOVA t-Test 199
8.4.1.1 Finding the Degrees of Freedom for the ANOVA t-Test 200
8.4.1.2 Stating the Decision Rule for the ANOVA t-Test 201
8.4.1.3 Performing an ANOVA t-Test Using Excel Commands 201
8.5 End-of-Chapter Practice Problems 203
References 211
Appendices 212
Appendix A: Answers to End-of-Chapter Practice Problems 212
Appendix B: Practice Test 247
Appendix C: Answers to Practice Test 258
Appendix D: Statistical Formulas 269
Appendix E: t-Table 271
Index 272

This Book Shows The Capabilities Of Microsoft Excel In Teaching Educational And Psychological Statistics Effectively. Similar To The Previously Published Excel 2013 For Educational And Psychological Statistics, This Book Is A Step-by-step Exercise-driven Guide For Students And Practitioners Who Need To Master Excel To Solve Practical Education And Psychology 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 Education And Psychology Courses. Its Powerful Computational Ability And Graphical Functions Make Learning Statistics Much Easier Than In Years Past. However, Excel 2016 For Educational And Psychological 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 Educational And Psychological 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. Introduction -- Sample Size, Mean, Standard Deviation, Standard Error Of The Mean -- Random Number Generator -- Confidence Interval About The Mean Using The Tinv Function And Hypothesis Testing -- One-group T-test For The Mean -- Two-group T-test Of The Difference Of The Means For Independent Groups -- Correlation And Simple Linear Regression -- Multiple Correlation And Multiple Regression -- One-way Analysis Of Variance (anova) -- Appendix A -- Appendix B -- Appendix C -- Appendix D -- Appendix E -- Index. By Thomas J. Quirk.

Front Matter....Pages i-xv
Sample Size, Mean, Standard Deviation, and Standard Error of the Mean....Pages 1-21
Random Number Generator....Pages 23-36
Confidence Interval About the Mean Using the TINV Function and Hypothesis Testing....Pages 37-66
One-Group t-Test for the Mean....Pages 67-84
Two-Group t-Test of the Difference of the Means for Independent Groups....Pages 85-114
Correlation and Simple Linear Regression....Pages 115-158
Multiple Correlation and Multiple Regression....Pages 159-177
One-Way Analysis of Variance (ANOVA)....Pages 179-197
Back Matter....Pages 199-260

2016-11-20