Statistical analysis with Excel for dummies
You too can understand the statistics of life, even if you're math-challenged! What do you need to calculate? Manufacturing output? A curve for test scores? Sports stats? You and Excel can do it, and this non-intimidating guide shows you how. It demystifies the different types of statistics, h...
| Formato: | Libro electrónico |
|---|---|
| Idioma: | Inglés |
| Publicado: |
Hoboken, NJ :
Wiley
c2009.
|
| Edición: | 2nd ed |
| Colección: | --For dummies.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627469006719 |
Tabla de Contenidos:
- Statistical Analysis with Excel for Dummies; About the Author; Dedication; Author's Acknowledgments; Contents at a Glance; Table of Contents; Introduction; About This Book; What You Can Safely Skip; Foolish Assumptions; How This Book Is Organized; Icons Used in This Book; Where to Go from Here; Part I: Statistics and Excel: A Marriage Made in Heaven; Chapter 1: Evaluating Data in the Real World; The Statistical (And Related) Notions You Just Have to Know; Inferential Statistics: Testing Hypotheses; What's New in Excel?; Some Things about Excel You Absolutely Have to Know
- What's New in This Edition?Chapter 2: Understanding Excel's Statistical Capabilities; Getting Started; Setting Up for Statistics; Accessing Commonly Used Functions; Part II: Describing Data; Chapter 3: Show and Tell: Graphing Data; Why Use Graphs?; Some Fundamentals; Excel's Graphics Capabilities; Becoming a Columnist; Slicing the Pie; Drawing the Line; Passing the Bar; The Plot Thickens; Chapter 4: Finding Your Center; Means: The Lore of Averages; Medians: Caught in the Middle; Statistics À La Mode; Chapter 5: Deviating from the Average; Measuring Variation
- Back to the Roots: Standard DeviationRelated Functions; Chapter 6: Meeting Standards and Standings; Catching Some Zs; Where Do You Stand?; Chapter 7: Summarizing It All; Counting Out; The Long and Short of It; Getting Esoteric; Tuning In the Frequency; Can You Give Me a Description?; Instant Statistics; Chapter 8: What's Normal?; Hitting the Curve; A Distinguished Member of the Family; Part III: Drawing Conclusions from Data; Chapter 9: The Confidence Game: Estimation; What is a Sampling Distribution?; An EXTREMELY Important Idea: The Central Limit Theorem; The Limits of Confidence
- Fit to a tChapter 10: One-Sample Hypothesis Testing; Hypotheses, Tests, and Errors; Catching Some Zs Again; t for One; Testing a Variance; Chapter 11: Two-Sample Hypothesis Testing; Hypotheses Built for Two; Sampling Distributions Revisited; t for Two; A Matched Set: Hypothesis Testing for Paired Samples; Testing Two Variances; Chapter 12: Testing More Than Two Samples; Testing More Than Two; Another Kind of Hypothesis, Another Kind of Test; Chapter 13: Slightly More Complicated Testing; Cracking the Combinations; Cracking the Combinations Again; Chapter 14: Regression: Linear and Multiple
- The Plot of ScatterGraphing Lines; Regression: What a Line!; Worksheet Functions for Regression; Data Analysis Tool: Regression; Juggling Many Relationships at Once: Multiple Regression; Excel Tools for Multiple Regression; Chapter 15: Correlation: The Rise and Fall of Relationships; Scatterplots Again; Understanding Correlation; Correlation and Regression; Testing Hypotheses About Correlation; Worksheet Functions for Correlation; Data Analysis Tool: Correlation; Data Analysis Tool: Covariance; Testing Hypotheses About Correlation; Part IV: Working with Probability
- Chapter 16: Introducing Probability
