Excel 2016 for Marketing Statistics A Guide to Solving Practical Problems /

• Main Authors: Quirk, Thomas J. (Author), Rhiney, Eric (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.; Marketing.; Application software.; Statistical Theory and Methods.; Computer Appl. in Social and Behavioral Sciences.

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

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.