Statistical analysis with excel for dummies.

Format:

Book

Author/Creator:

Schmuller, Joseph.

Series:

Makes Everything Easier!

Language:

English

Subjects (All):

Microsoft Excel (Computer file).

Electronic spreadsheets.

Statistics--Data processing.

Statistics.

Physical Description:

1 online resource (530 p.)

Edition:

3rd ed.

Place of Publication:

Hoboken, N.J. : John Wiley & Sons, c2013.

Language Note:

English

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, Pivot Tables, and other tools to make sense of everything

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 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

Notes:

Includes index.

Description based on online resource; title from title page (ebrary, viewed May 9, 2013).

ISBN:

9781118464328

111846432X

9781118464342

1118464346

OCLC:

831118427