Statistical Analysis with Excel For Dummies
Paperback Engels 2022 5e druk 9781119844549Samenvatting
Become a stats superstar by using Excel to reveal the powerful secrets of statistics
Microsoft Excel offers numerous possibilities for statistical analysis—and you don’t have to be a math wizard to unlock them. In 'Statistical Analysis with Excel For Dummies', fully updated for the 2021 version of Excel, you’ll hit the ground running with straightforward techniques and practical guidance to unlock the power of statistics in Excel.
Bypass unnecessary jargon and skip right to mastering formulas, functions, charts, probabilities, distributions, and correlations. Written for professionals and students without a background in statistics or math, you’ll learn to create, interpret, and translate statistics—and have fun doing it!
In this book you’ll find out how to:
- Understand, describe, and summarize any kind of data, from sports stats to sales figures
- Confidently draw conclusions from your analyses, make accurate predictions, and calculate correlations
- Model the probabilities of future outcomes based on past data
- Perform statistical analysis on any platform: Windows, Mac, or iPad
- Access additional resources and practice templates through Dummies.com
For anyone who’s ever wanted to unleash the full potential of statistical analysis in Excel—and impress your colleagues or classmates along the way—Statistical Analysis with Excel For Dummies walks you through the foundational concepts of analyzing statistics and the step-by-step methods you use to apply them.
Specificaties
Lezersrecensies
Inhoudsopgave
PART 1: GETTING STARTED WITH STATISTICAL ANALYSIS WITH EXCEL: A MARRIAGE MADE IN HEAVEN 7
CHAPTER 1: Evaluating Data in the Real World 9
CHAPTER 2: Understanding Excel’s Statistical Capabilities 29
PART 2: DESCRIBING DATA 63
CHAPTER 3: Show-and-Tell: Graphing Data 65
CHAPTER 4: Finding Your Center 91
CHAPTER 5: Deviating from the Average 107
CHAPTER 6: Meeting Standards and Standings 125
CHAPTER 7: Summarizing It All 141
CHAPTER 8: What’s Normal? 161
PART 3: DRAWING CONCLUSIONS FROM DATA 173
CHAPTER 9: The Confidence Game: Estimation 175
CHAPTER 10: One-Sample Hypothesis Testing 189
CHAPTER 11: Two-Sample Hypothesis Testing 211
CHAPTER 12: Testing More Than Two Samples 247
CHAPTER 13: Slightly More Complicated Testing 281
CHAPTER 14: Regression: Linear and Multiple 303
CHAPTER 15: Correlation: The Rise and Fall of Relationships 341
CHAPTER 16: It’s About Time 363
CHAPTER 17: Nonparametric Statistics 379
PART 4: PROBABILITY 393
CHAPTER 18:Introducing Probability 395
CHAPTER 19: More on Probability 419
CHAPTER 20: Using Probability: Modeling and Simulation 433
PART 5: THE PART OF TENS 465
CHAPTER 22: Ten (12, Actually) Statistical and Graphical Tips and Traps 467
CHAPTER 23: Ten Topics (Thirteen, Actually) That Just
PART 6: APPENDICES 501
APPENDIX A:When Your Data Live Elsewhere 503
APPENDIX B:Tips for Teachers (and Learners) 507
APPENDIX C:More on Excel Graphics 515
APPENDIX D:The Analysis of Covariance 529
INDEX 545
Rubrieken
- advisering
- algemeen management
- coaching en trainen
- communicatie en media
- economie
- financieel management
- inkoop en logistiek
- internet en social media
- it-management / ict
- juridisch
- leiderschap
- marketing
- mens en maatschappij
- non-profit
- ondernemen
- organisatiekunde
- personal finance
- personeelsmanagement
- persoonlijke effectiviteit
- projectmanagement
- psychologie
- reclame en verkoop
- strategisch management
- verandermanagement
- werk en loopbaan