Statistical Analysis with Excel For Dummies

Name: Statistical Analysis with Excel For Dummies
Author: Joseph Schmuller

Specificaties

Paperback, 560 blz. | Engels

John Wiley & Sons | 5e druk, 2022

ISBN13: 9781119844549

Rubricering

Hoofdrubriek : Computer en informatica

Juridisch : Computer en informatica

John Wiley & Sons 5e druk, 2022 9781119844549

Onderdeel van serie Dummies (Engelstalig)

Verwachte levertijd ongeveer 8 werkdagen

44,56

In winkelwagen

Samenvatting

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

ISBN13:9781119844549

Trefwoorden:Excel, Spreadsheets, kantoorapplicaties, Microsoft, statistische analyse

Taal:Engels

Bindwijze:paperback

Aantal pagina's:560

Uitgever:John Wiley & Sons

Druk:5

Verschijningsdatum:16-3-2022

Hoofdrubriek:Computer en informatica

Serie:Dummies (Engelstalig)

Inhoudsopgave

U kunt van deze inhoudsopgave een PDF downloaden

INTRODUCTION 1

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