Excel 2013 for Business Statistics A Guide to Solving Practical Business Problems /

• Main Author: Quirk, Thomas J. (Author)
• Corporate Author: SpringerLink (Online service)
• Format: Electronic eBook
• Language: English
• Published: Cham : Springer International Publishing : Imprint: Springer, 2015.
• Series: Excel for Statistics
• Subjects: Statistics.; Business mathematics.; Statistics for Business/Economics/Mathematical Finance/Insurance.; Business Mathematics.; Statistics and Computing/Statistics Programs.

This is the first book to show the capabilities of Microsoft Excel to teach business statistics effectively.  It is a step-by-step exercise-driven guide for students and practitioners who need to master Excel to solve practical business problems.  If understanding statistics isn’t your strongest sui...

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.