Statistical Analysis with Excel for Dummies - Brossura

Schmuller, Joseph, Ph.d.

Brossura

ISBN 10: 1118464311 ISBN 13: 9781118464311

Casa editrice: For Dummies, 2013

Riassunto

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.

Su questo libro

L'autore

Joseph Schmuller, PhD, is a technical architect at Blue Cross-Blue Shield of Florida. An adjunct professor at the University of North Florida, he is a former member of the American Statistical Association and has taught statistics at the undergrad, honors undergrad, and graduate levels.

Dalla quarta di copertina

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 mumbo-jumbo!

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 all-important Central Limit Theorem
• It's probable — explore Excel's rich set of built-in 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 pinch-hit as a database
• What to do with random variables
• Appendixes that delve into specific tools and tricks

Dettagli dell?edizione

• Editore: For Dummies
• Data di pubblicazione: 2013
• ISBN 10: 1118464311
• ISBN 13: 9781118464311
• Rilegatura: Copertina flessibile
• Lingua: Inglese
• Numero edizione: 3
• Numero di pagine: 504