Statistical analysis with excel for dummies
Take the mystery out of statistical terms and put Excel to work! If you need to create and interpret statistics in business or classroom settings, this easy-to-use guide is just what you need. It shows you how to use Excel's powerful tools for statistical analysis, even if you've never tak...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Hoboken, N.J. :
John Wiley & Sons
c2013.
|
| Edición: | 3rd ed |
| Colección: | --For dummies.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628449406719 |
Tabla de Contenidos:
- Statistical Analysis with Excel® For Dummies®, 3rd Edition; 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: Getting Started with Statistical Analysis with Excel; 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 2013?; What's Old in Excel 2013?; Knowing the Fundamentals; What's New in This Edition?
- Chapter 2: Understanding Excel's Statistical Capabilities Getting Started; Setting Up for Statistics; Accessing Commonly Used Functions; For Mac Users; Part II:Describing Data; Chapter 3: Show and Tell: Graphing Data; Why Use Graphs?; Some Fundamentals; Excel's Graphics (Chartics?) Capabilities; Becoming a Columnist; Slicing the Pie; Drawing the Line; Adding a Spark; Passing the Bar; The Plot Thickens; Finding Another Use for the Scatter Chart; Power View!; For Mac Users; 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 Deviation; Related Functions; Chapter 6: Meeting Standards and Standings; Catching Some Zs; Where Do You Stand?; For Mac Users; 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?; Be Quick About It!; Instant Statistics; For Mac Users; 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
- Understanding Sampling Distribution An EXTREMELY Important Idea: The Central Limit Theorem; The Limits of Confidence; Fit to a t; Chapter 10: One-Sample Hypothesis Testing; Hypotheses, Tests, and Errors; Catching Some Z's 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; For Mac Users; Chapter 12: Testing More Than Two Samples; Testing More Than Two; Another Kind of Hypothesis, Another Kind of Test; For Mac Users
- Chapter 13: Slightly More Complicated Testing Cracking the Combinations; Cracking the Combinations Again; For Mac Users; Chapter 14: Regression: Linear and Multiple; The Plot of Scatter; Graphing 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; For Mac Users; Chapter 15: Correlation: The Rise and Fall of Relationships; Scatterplots Again; Understanding Correlation; Correlation and Regression; Testing Hypotheses About Correlation
- Worksheet Functions for Correlation
