"This Microsoft Excel version of this bestelling text presents an often intimidating and difficult subject in a way that is clear, informative, and personable. Students appreciate the book's unhurried pace and thorough, friendly presentation using a step-by-step approach to explaining each statistic and its procedure in Excel. Opening with an introduction to Excel, including coverage of how to use functions and formulas, this text shows students how to install and use the Excel Data Analysis Tools option to access a host of useful analytical techniques. The book walks readers through various statistical procedures, beginning with simple descriptive statistics, correlations, and graphical representations of data, and ending with inferential techniques, analysis of variance, and a final chapter on working with large datasets and data mining using Excel. New to the Fifth Edition is new co-author Bruce Frey who has added a new feature on statisticians throughout history (with a focus on the contributions of women and people of color). He has updated the "Real-World Stats" feature, and added more on effect sizes, updated the discussions on hypotheses, measurement concepts like validity and reliability, and has more closely tied analytical choices to the level of measurement of variables. A website is available for the book with resources for instructors and students"-- Provided by publisher.

Part I. Yippee! I'm in statistics! Statistics or sadistics? It's up to you ; Getting started in excel -- Part II. Eigma Freud and descriptive statistics. Computing and understanding averages: means to an end ; Understanding variability: vive la différence ; Creating graphs: a picture is worth a thousand words ; Computing correlation coefficients: ice cream and crime ; Understanding reliability and validity: just the truth -- Part III. Taking chances for fun and profit. Hypotheticals and you: testing your questions ; Probability and why it counts: fun with a bell-shaped curve -- Part IV. Significantly different: using inferential statistics. Significantly significant: what it means for you and me ; The one-sample Z test: only the lonely ; t(ea) for two: tests between the means of different groups ; t(ea) for two (Again): tests between the means of related groups ; Analysis of variance: two groups too many? ; Factorical analysis of variance: two too many factors ; Testing relationships using the correlation coefficient: cousins or just good friends? ; Using linear regression: predicting the future -- Part V. More statistics! more tools! more fun! Chi-square and some other nonparametric tests: what to do when you're not normal ; Some other (important) statistical procedures you should know about ; Data mining: a introduction to getting the most out of your big data.