Excel 2016 for Social Science Statistics A Guide to Solving Practical Problems /
This book shows the capabilities of Microsoft Excel in teaching social science statistics effectively. Similar to the previously published Excel 2013 for Social Sciences Statistics, this book is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve pra...
| Main Author: | |
|---|---|
| Corporate Author: | |
| Language: | English |
| Published: |
Cham :
Springer International Publishing : Imprint: Springer,
2016.
|
| Edition: | 1st ed. 2016. |
| Series: | Excel for Statistics,
|
| Subjects: | |
| Online Access: | https://doi.org/10.1007/978-3-319-39711-5 |
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.