Excel has become an important and nearly ubiquitous classroom and office resource for students and practitioners who are faced with solving statistical problems on an everyday basis. Despite this, there has yet to emerge a truly practical, “how-do-I-do-it” manual that teaches the various applications and processes/formulas for Excel  in educational and psychological Statistics. Quirk’s Excel 2010 for Educational and Psychological Statistics will fill this void, as it is designed to be a step-by-step, exercise-driven guide for education and psychology students who need to master Excel to create  formulas and solve statistical problems.    Each chapter first explains briefly the formulas that are included in the chapter, and then directs the student on  how to use Excel commands and formulas to solve a specific business problem.  Three practice problems are provided at the end of each chapter, along with their solutions in an Appendix.  At the end of the Excel Guide, an additional Practice Exam allows the reader to test his or her understanding of each chapter by attempting to solve a specific educational or psychometrical issue or problem using Excel (the solution to this problem is also given in an Appendix).  From the beginning of the book, readers/students are taught how to write their own formulas and then how to utilize Excel drop-down formula menus as well for such exercises involving one-way ANOVA, simple linear regression, and multiple correlation.​
From the Back Cover This is the first book to show the capabilities of Microsoft Excel to teach educational and psychological statistics effectively.  It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical problems in education and psychology.  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 practitioners, is also an effective teaching and learning tool for quantitative analyses in statistics courses.  Its powerful computational ability and graphical functions make learning statistics much easier than in years past.  However, Excel 2010 for Educational and Psychological Statistics: A Guide to Solving Practical Problems is the first book to capitalize on these improvements by teaching students and practitioners 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 problems in education and psychology.  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 163 illustrations in color.
About the Author At the beginning of his academic career, Prof. Quirk spent six years in educational research at The American Institutes for Research and Educational Testing Service.  He then taught Social Psychology, Educational Psychology, and General Psychology at Principia College, and is currently a Professor of Marketing in the George Herbert Walker School of Business & Technology at Webster University based in St. Louis, Missouri (USA) where he teaches Marketing Statistics, Marketing Research, and Pricing Strategies.  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, he has written 60+ textbook supplements in Marketing and Management, published 20+ articles in professional journals, and presented 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 an M.B.A. from The University of Missouri-St. Louis.

motw/Excel 2010 for Educational and Psychologic - Thomas J. Quirk.pdf

nexusstc/Excel 2010 for Educational and Psychological Statistics/6486bd5a2715b0659d4026d88e438344.pdf

lgli/_518291.6486bd5a2715b0659d4026d88e438344.pdf

lgrsnf/_518291.6486bd5a2715b0659d4026d88e438344.pdf

scihub/10.1007/978-1-4614-2071-2.pdf

zlib/Computers/Thomas Quirk (auth.)/Excel 2010 for Educational and Psychological Statistics: A Guide to Solving Practical Problems_1246720.pdf

Thomas Joseph Quirk

Quirk, Thomas J

Springer Science+Business Media, LLC

United States, United States of America

New York, London, New York State, 2012

New York, NY, cop. 2012

sm28777587

{"content":{"parsed_at":1697468963,"source_extension":"epub"},"edition":"1","isbns":["1461420709","1461420717","9781461420705","9781461420712"],"last_page":243,"publisher":"Springer New York"}

Memory of the World Librarian: Quintus

Includes index.

Cover 1
Excel 2010 for Educational and Psychological Statistics 4
ISBN 9781461420705 5
Preface 8
Acknowledgments 10
Contents 12
Chapter 1: Sample Size, Mean, Standard Deviation, and Standard Error of the Mean 18
1.1 Mean 18
1.2 Standard Deviation 19
1.3 Standard Error of the Mean 20
1.4 Sample Size, Mean, Standard Deviation, and Standard Error of the Mean 21
1.4.1 Using the Fill/Series/Columns Commands 21
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 25
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 27
1.4.8 Finding the Standard Error of the Mean 27
1.4.8.1 Formatting Numbers in Number Format (Two Decimal Places) 28
1.5 Saving a Spreadsheet 29
1.6 Printing a Spreadsheet 30
1.7 Formatting Numbers in Currency Format (Two Decimal Places) 32
1.8 Formatting Numbers in Number Format (Three Decimal Places) 33
1.9 End-of-Chapter Practice Problems 34
Reference 36
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 41
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 46
2.5 End-of-Chapter Practice Problems 48
Reference 50
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 for 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 55
3.1.6 Using Excel ́s TINV Function to Find the Confidence Interval About the Mean 56
3.1.7 Using Excel to Find the 95% Confidence Interval for a Car ́s Miles per Gallon Claim 57
3.2 Hypothesis Testing 61
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 64
3.2.2.1 Determining the Null Hypothesis and the Research Hypothesis When Rating Scales Are Used 65
3.2.3 The Seven Steps for Hypothesis Testing Using the Confidence Interval About the Mean 67
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,... 68
3.2.3.5 Step 5: Decide on a Decision Rule 68
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 73
3.3.1 Different Ways to Accept the Null Hypothesis 74
3.3.2 Different Ways to Reject the Null Hypothesis 74
3.4 End-of-Chapter Practice Problems 75
References 80
Chapter 4: One-Group t-Test for the Mean 82
4.1 The Seven 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? 91
4.4 End-of-Chapter Practice Problems 92
References 96
Chapter 5: Two-Group t-Test of the Difference of the Means for Independent Groups 98
5.1 The Nine Steps for Hypothesis Testing Using the Two-Group t-Test 99
5.1.1 Step 1: Name One Group, Group 1, and the Other Group, Group 2 99
5.1.2 Step 2: Create a Table That Summarizes the Sample Size, Mean Score, and Standard Deviation of Each Group 99
5.1.3 Step 3: State the Null Hypothesis and the Research Hypothesis for the Two-Group t-Test 101
5.1.4 Step 4: Select the Appropriate Statistical Test 101
5.1.5 Step 5: Decide on a Decision Rule for the Two-Group t-Test 101
5.1.6 Step 6: Calculate the Formula for the Two-Group t-Test 101
5.1.7 Step 7: Find the Critical Value of t in the t-Table in Appendix E 102
5.1.7.1 Finding the Degrees of Freedom (df) for the Two-Group t-Test 102
5.1.8 Step 8: State the Result of Your Statistical Test 103
5.1.9 Step 9: State the Conclusion of Your Statistical Test in Plain English! 103
5.1.9.1 Writing the Conclusion of the Two-Group t-Test When You Accept the Null Hypothesis 103
5.1.9.2 Writing the Conclusion of the Two-Group t-Test When You Reject the Null Hypothesis and Accept the Research Hypothesis 105
5.2 Formula #1: Both Groups Have More Than 30 People in Them 107
5.2.1 An Example of Formula #1 for the Two-Group t-Test 108
5.3 Formula #2: One or Both Groups Have Less Than 30 People in Them 114
5.4 End-of-Chapter Practice Problems 119
References 123
Chapter 6: Correlation and Simple Linear Regression 124
6.1 What Is a ``Correlation ́ ́? 124
6.1.1 Understanding the Formula for Computing a Correlation 129
6.1.2 Understanding the Nine Steps for Computing a Correlation, r 129
6.2 Using Excel to Compute a Correlation Between Two Variables 131
6.3 Creating a Chart and Drawing the Regression Line onto the Chart 136
6.3.1 Using Excel to Create a Chart and the Regression Line Through the Data Points 137
6.3.1.1 Moving the Chart Below the Table in the Spreadsheet 140
6.3.1.2 Making the Chart ``Longer ́ ́ so that It Is ``Taller ́ ́ 141
6.3.1.3 Making the Chart ``Wider ́ ́ 142
6.3.1.4 Drawing the Regression Line Through the Data Points in the Chart 143
6.4 Printing a Spreadsheet so that the Table and Chart Fit onto One Page 144
6.5 Finding the Regression Equation 147
6.5.1 Installing the Data Analysis ToolPak into Excel 147
6.5.1.1 Installing the Data Analysis ToolPak into Excel 2010 147
6.5.1.2 Installing the Data Analysis ToolPak into Excel 2007 148
6.5.1.3 Installing the Data Analysis ToolPak into Excel 2003 148
6.5.2 Using Excel to Find the SUMMARY OUTPUT of Regression 149
6.5.2.1 Finding the y-Intercept, a, of the Regression Line 152
6.5.2.2 Finding the Slope, b, of the Regression Line 152
6.5.3 Finding the Equation for the Regression Line 152
6.5.4 Using the Regression Line to Predict the Y-Value for a Given X-Value 153
6.6 Adding the Regression Equation to the Chart 154
6.7 How to Recognize Negative Correlations in the SUMMARY OUTPUT Table 156
6.8 Printing Only Part of a Spreadsheet Instead of the Entire Spreadsheet 157
6.8.1 Printing Only the Table and the Chart on a Separate Page 157
6.8.2 Printing Only the Chart on a Separate Page 158
6.8.3 Printing Only the SUMMARY OUTPUT of the Regression Analysis on a Separate Page 158
6.9 End-of-Chapter Practice Problems 159
References 164
Chapter 7: Multiple Correlation and Multiple Regression 166
7.1 Multiple Regression Equation 166
7.2 Finding the Multiple Correlation and the Multiple Regression Equation 169
7.3 Using the Regression Equation to Predict FROSH GPA 172
7.4 Using Excel to Create a Correlation Matrix in Multiple Regression 173
7.5 End-of-Chapter Practice Problems 176
References 181
Chapter 8: One-Way Analysis of Variance (ANOVA) 182
8.1 Using Excel to Perform a One-Way Analysis of Variance (ANOVA) 183
8.2 How to Interpret the ANOVA Table Correctly 186
8.3 Using the Decision Rule for the ANOVA F-Test 187
8.4 Testing the Difference Between Two Groups Using the ANOVA t-Test 188
8.4.1 Comparing LECTURES vs. INDEPENDENT in Their Exam Scores Using the ANOVA t-Test 188
8.4.1.1 Finding the Degrees of Freedom for the ANOVA t-Test 189
8.4.1.2 Stating the Decision Rule for the ANOVA t-test 190
8.4.1.3 Performing an ANOVA t-Test Using Excel Commands 190
8.5 End-of-Chapter Practice Problems 192
References 198
Appendices 200
Appendix A: Answers to End-of-Chapter Practice Problems 200
Appendix B: Practice Test 233
Appendix C: Answers to Practice Test 244
Appendix D: Statistical Formulas 255
Appendix E: t-Table 257
Index 258
1461420709,9781461420705
Springer 2011

Excel has become an important and nearly ubiquitous classroom and office resource for students and practitioners who are faced with solving statistical problems on an everyday basis. Despite this, there has yet to emerge a truly practical, “how-do-I-do-it” manual that teaches the various applications and processes/formulas for Excel in educational and psychological Statistics. Quirk’s Excel 2010 for Educational and Psychological Statistics will fill this void, as it is designed to be a step-by-step, exercise-driven guide for education and psychology students who need to master Excel to create formulas and solve statistical problems. Each chapter first explains briefly the formulas that are included in the chapter, and then directs the student on how to use Excel commands and formulas to solve a specific business problem. Three practice problems are provided at the end of each chapter, along with their solutions in an Appendix. At the end of the Excel Guide, an additional Practice Exam allows the reader to test his or her understanding of each chapter by attempting to solve a specific educational or psychometrical issue or problem using Excel (the solution to this problem is also given in an Appendix). From the beginning of the book, readers/students are taught how to write their own formulas and then how to utilize Excel drop-down formula menus as well for such exercises involving one-way ANOVA, simple linear regression, and multiple correlation.
Erscheinungsdatum: 15.12.2011

Front Matter....Pages i-xv
Sample Size, Mean, Standard Deviation, and Standard Error of the Mean....Pages 1-19
Random Number Generator....Pages 21-33
Confidence Interval About the Mean Using the TINV Function and Hypothesis Testing....Pages 35-63
One-Group t -Test for the Mean....Pages 65-79
Two-Group t -Test of the Difference of the Means for Independent Groups....Pages 81-106
Correlation and Simple Linear Regression....Pages 107-147
Multiple Correlation and Multiple Regression....Pages 149-164
One-Way Analysis of Variance (ANOVA)....Pages 165-181
Back Matter....Pages 183-243

2012-03-09