Excel 2016 for Educational and Psychological Statistics A Guide to Solving Practical Problems /

• Main Author: Quirk, Thomas J. (Author)
• Corporate Author: SpringerLink (Online service)
• Format: Electronic eBook
• Language: English
• Published: Cham : Springer International Publishing : Imprint: Springer, 2016.
• Series: Excel for Statistics
• Subjects: Statistics.; Application software.; Psychology > Methodology.; Psychological measurement.; Statistics for Social Science, Behavorial Science, Education, Public Policy, and Law.; Computer Appl. in Social and Behavioral Sciences.; Psychological Methods/Evaluation.

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...

Table of Contents:

• 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.