Excel 2016 for Marketing Statistics A Guide to Solving Practical Problems

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

Full description

Bibliographic Details
Main Authors: Quirk, Thomas J., Rhiney, Eric (Author)
Format: eBook
Language:English
Published: Cham Springer International Publishing 2016, 2016
Edition:1st ed. 2016
Series:Excel for Statistics
Subjects:
Online Access:
Collection: Springer eBooks 2005- - Collection details see MPG.ReNa
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