Statistical Analysis with Excel For Dummies by Schmuller

Description: About this productProduct IdentifiersPublisherWiley & Sons, Incorporated, JohnISBN-101118464311ISBN-139781118464311eBay Product ID (ePID)143545845Product Key FeaturesNumber of Pages528 PagesLanguageEnglishPublication NameStatistical Analysis with Excel for DummiesPublication Year2013SubjectProbability & Statistics / General, Desktop Applications / SpreadsheetsTypeTextbookSubject AreaMathematics, ComputersAuthorJoseph SchmullerFormatTrade PaperbackDimensionsItem Height1.1 inItem Weight24.9 OzItem Length9.1 inItem Width7.4 inAdditional Product FeaturesEdition Number3Intended AudienceTradeLCCN2013-932117Dewey Edition23CLASSIFICATION_METADATA{"IsNonfiction":["No"],"IsOther":["Yes"],"IsAdult":["No"],"MuzeFormatDesc":["Trade Paperback"],"IsChildren":["No"],"Genre":["COMPUTERS","MATHEMATICS"],"Topic":["Desktop Applications / Spreadsheets","Probability & Statistics / General"],"IsTextBook":["No"],"IsFiction":["No"]}IllustratedYesDewey Decimal519.5028Table Of ContentIntroduction 1 Part I: Getting Started with Statistical Analysis with Excel 7 Chapter 1: Evaluating Data in the Real World 9 Chapter 2: Understanding Excel's Statistical Capabilities 31 Part II: Describing Data 63 Chapter 3: Show and Tell: Graphing Data 65 Chapter 4: Finding Your Center 97 Chapter 5: Deviating from the Average 113 Chapter 6: Meeting Standards and Standings 131 Chapter 7: Summarizing It All 147 Chapter 8: What's Normal? 173 Part III: Drawing Conclusions from Data 185 Chapter 9: The Confi dence Game: Estimation 187 Chapter 10: One-Sample Hypothesis Testing 203 Chapter 11: Two-Sample Hypothesis Testing 219 Chapter 12: Testing More Than Two Samples 251 Chapter 13: Slightly More Complicated Testing 279 Chapter 14: Regression: Linear and Multiple 293 Chapter 15: Correlation: The Rise and Fall of Relationships 331 Part IV: Probability 353 Chapter 16: Introducing Probability 355 Chapter 17: More on Probability 379 Chapter 18: A Career in Modeling 393 Part V: The Part of Tens 413 Chapter 19: Ten Statistical and Graphical Tips and Traps 415 Chapter 20: Ten Things (Thirteen, Actually) That Just Didn't Fit in Any Other Chapter 421 Appendix A: When Your Worksheet Is a Database 451 Appendix B: The Analysis of Covariance 467 Index 481 Bonus Appendix 1: When Your Data Live Elsewhere Bonus Appendix 2: Tips for Teachers (And Learners)SynopsisTake 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 from sports stats to medical correlations. Statistics have a reputation for being challenging and math-intensive; this friendly guide makes statistical analysis with Excel easy to understand Explains how to use Excel to crunch numbers and interpret the statistics of everyday life: sales figures, gambling odds, sports stats, a grading curve, and much more Covers formulas and functions, charts and PivotTables, samples and normal distributions, probabilities and related distributions, trends, and correlations Clarifies statistical terms such as median vs. mean, margin of error, standard deviation, correlations, and permutations Statistical Analysis with Excel For Dummies, 3rd Edition helps you make sense of statistics and use Excel's statistical analysis tools in your daily life., Learn to: Understand common statistical terms Interpret sales figures, gambling odds, sports stats, and more Use Excel formulas, functions, charts, and PivotTables Develop a grading curve or medical correlations Forget the mumbojumbo! Statistical analysis with Excel can be easy and useful, too Stunned by statistics? Exhausted by Excel? Relax! This book makes it easy to learn statistical analysis and actually use it to interpret the statistics of everyday life. Take your Excel knowledge to a new level as you discover how to use Excel's perfectly designed tools to analyze and understand data, predict trends, make decisions, and much more. The scoop on stats learn about statistical concepts such as samples and populations, variables, and probability New Excel stuff check out naming conventions, new functions, and other elements that are different in Excel 2013 Striking sparks discover the cool new "sparklines" feature that lets you quickly create small graphs to illustrate data trends Means to an end understand means, medians, and modes and the worksheet functions associated with them Reasonable estimation work with sampling distributions for estimation and understand the allimportant Central Limit Theorem It's probable explore Excel's rich set of builtin capabilities for understanding and applying probability Send in the data see how to import data from databases, the web, or from text Open the book and find: A roundup of new Excel capabilities Different types of hypothesis testing Tools and instructions just for Mac users What ANOVA means and why you must know Statistical and graphical tips and traps How Excel can pinchhit as a database What to do with random variables Appendixes that delve into specific tools and tricks, 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., 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 from sports stats to medical correlations. Statistics have a reputation for being challenging and math-intensive; this friendly guide makes statistical analysis with Excel easy to understand Explains how to use Excel to crunch numbers and interpret the statistics of everyday life: sales figures, gambling odds, sports stats, a grading curve, and much more Covers formulas and functions, charts and PivotTables, samples and normal distributions, probabilities and related distributions, trends, and correlations Clarifies statistical terms such as median vs. mean, margin of error, standard deviation, correlations, and permutations Statistical Analysis with Excel For Dummies, 3rd Edition helps you make sense of statistics and use Excel's statistical analysis tools in your daily life.LC Classification NumberHF5548.4.M523S3534Copyright Date2013ebay_catalog_id4

Price: 10.9 USD

Location: Multiple Locations

End Time: 2024-08-29T22:49:41.000Z

Shipping Cost: 3.97 USD