Statistical Analysis with Excel For Dummies

3rd Edition

By Joseph Schmuller

ISBN: 8126543442
Publisher: For Dummies
Year: 2013
Pages: 528

About This Book

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 understandExplains 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 moreCovers formulas and functions, charts and PivotTables, samples and normal distributions, probabilities and related distributions, trends, and correlationsClarifies statistical terms such as median vs. mean, margin of error, standard deviation, correlations, and permutationsStatistical Analysis with Excel For Dummies, 3rd Edition helps you make sense of statistics and use Excel's statistical analysis tools in your daily life.

Product Details

Publisher For Dummies
Publication date January 1, 2013
Language English
Print length 528 pages
ISBN-10 8126543442
ISBN-13 978-1118464311
Item Weight 1.54 pounds

Editorial Reviews

Editorial Review

From the Back CoverLearn to:Learn to:Understand common statistical termsUnderstand common statistical termsInterpret sales figures, gambling odds, sports stats, and moreInterpret sales figures, gambling odds, sports stats, and moreUse Excel formulas, functions, charts, and PivotTablesUse Excel formulas, functions, charts, and PivotTablesDevelop a grading curve or medical correlationsDevelop a grading curve or medical correlationsForget the mumbo-jumbo!Forget the mumbo-jumbo!Statistical analysis with Excel can be easy — and useful, tooStatistical analysis with Excel can be easy — and useful, tooStunned 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.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 probabilityThe scoop on stats — learn about statistical concepts such as samples and populations, variables, and probabilityNew Excel stuff — check out naming conventions, new functions, and other elements that are different in Excel 2013New Excel stuff — check out naming conventions, new functions, and other elements that are different in Excel 2013Striking sparks — discover the cool new "sparklines" feature that lets you quickly create small graphs to illustrate data trendsStriking sparks — discover the cool new "sparklines" feature that lets you quickly create small graphs to illustrate data trendsMeans to an end — understand means, medians, and modes and the worksheet functions associated with themMeans to an end — understand means, medians, and modes and the worksheet functions associated with themReasonable estimation — work with sampling distributions for estimation and understand the all-important Central Limit TheoremReasonable estimation — work with sampling distributions for estimation and understand the all-important Central Limit TheoremIt's probable — explore Excel's rich set of built-in capabilities for understanding and applying probabilityIt's probable — explore Excel's rich set of built-in capabilities for understanding and applying probabilitySend in the data — see how to import data from databases, the web, or from textSend in the data — see how to import data from databases, the web, or from textOpen the book and find:Open the book and find:A roundup of new Excel capabilitiesA roundup of new Excel capabilitiesDifferent types of hypothes
Shipping set per seller
Compare book + shipping totals for each offer
Seller-error returns
Returns accepted for seller errors. Ask the seller about change-of-mind returns
Partner purchases
MedicalBook.online handles payment, shipping and returns for its orders
Email Support
[email protected] for buyers and sellers