Statistical analysis with Excel for dummies, Joseph Schmuller
Type
Label
Statistical analysis with Excel for dummies, Joseph Schmuller
Language
eng
Illustrations
illustrations
Index
index present
Literary Form
non fiction
Main title
Statistical analysis with Excel for dummies
Nature of contents
dictionaries
Oclc number
1842854710
Responsibility statement
Joseph Schmuller
Series statement
For dummies
Summary
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 taken a course in statistics. Learn the meaning of terms like mean and median, margin of error, standard deviation, and permutations, and discover how to interpret the statistics of everyday life. You'll learn to use Excel formulas, charts, PivotTables, and other tools to make sense of everything fro
Table Of Contents
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 CapabilitiesGetting 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 ModeChapter 5: Deviating from the AverageMeasuring 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: EstimationUnderstanding Sampling DistributionAn 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 UsersChapter 13: Slightly More Complicated TestingCracking 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