Excel 2016 for Advertising Statistics A Guide to Solving Practical Problems
Each chapter briefly explains a topic and then demonstrates how to use Excel commands and formulas to solve specific advertising statistics problems. This book gives practice in using Excel in two different ways: (1) writing formulas (e.g., confidence interval about the mean, one-group t-test, two...
| Main Authors: | , |
|---|---|
| Format: | eBook |
| Language: | English |
| Published: |
Cham
Springer International Publishing
2017, 2017
|
| Edition: | 1st ed. 2017 |
| Series: | Excel for Statistics
|
| Subjects: | |
| Online Access: | |
| Collection: | Springer eBooks 2005- - Collection details see MPG.ReNa |
Table of Contents:
- Preface
- Acknowledgements
- Ch 1 Sample Size, Mean, Standard Deviation, and Standard Error of the Mean
- Ch 2 Random Number Generator
- Ch 3 Confidence Interval About the Mean Using the TINV Function and Hypothesis Testing
- Ch 4 One-Group t-Test for the Mean
- Ch 5 Two-Group t-Test of the Difference of the Means for Independent Groups
- Ch 6 Correlation and Simple Linear Regression
- Ch 7 Multiple Correlation and Multiple Regression
- Ch 8 One-Way Analysis of Variance (ANOVA).- Appendix A: Answers to End-of-Chapter Practice Problems.- Appendix B: Practice Test.- Appendix C: Answers to Practice Test.- Appendix D: Statistical Formulas.- Appendix E: t-table.- Index