Statistical Analysis with Excel For Dummies

You too can understand the statistics of life, even if you'remath-challenged!What do you need to calculate? Manufacturing output? A curve fortest scores? Sports stats? You and Excel can do it, and thisnon-intimidating guide shows you how. It demystifies the differenttypes of statistics, how Excel functions and formulas work, themeaning of means and medians, how to interpret your figures, andmore -- in plain English.* Getting there -- learn how variables, samples, andprobability are used to get the information you want* Excel tricks -- find out what's built into the program tohelp you work with Excel formulas* Playing with worksheets -- get acquainted with the worksheetfunctions for each step* Graphic displays -- present your data as pie graphs, bargraphs, line graphs, or scatter plots* What's normal? -- understand normal distribution andprobability* Hyping hypotheses -- learn to use hypothesis testing withmeans and variables* When regression is progress -- discover when and how to useregression for forecasting* What are the odds -- work with probability, randomvariables, and binomial distributionOpen the book and find:* Ten statistical and graphical tips and traps* The difference between descriptive and inferentialstatistics* Why graphs are good* How to measure variations* What standard scores are and why they're used* When to use two-sample hypothesis testing* How to use correlations* Different ways of working with probability