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