Statistics for People Who (Think They) Hate Statistics: Using Microsoft Excel 2016

Description

Statistics for People Who (Think They) Hate Statistics: Using Microsoft Excel 2016, Fourth Edition presents an often intimidating and difficult subject in a way that is clear, informative, and personable. Researchers and students will appreciate the book's unhurried pace and thorough, friendly presentation. Opening with an introduction to Excel 2016, including coverage of how to use functions and formulas, this edition also shows students how to install 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 new introductory chapter on working with large datasets and data mining using Excel. A note to the student: why I wrote this book -- About the author -- Yippee! I'm in statistics -- Statistics or sadistics? : it's up to you -- Zigma Freud and descriptive statistics -- Means to an end : computing and understanding averages -- Vive la difference : understanding variability -- A picture really is worth a thousand words -- Ice cream and crime : correlation coefficients -- Just the truth : an introduction to understanding reliability and validity -- Taking chances for fun and profit -- Hypotheticals and you : testing your questions -- Are your curves normal? : probability and why it counts -- Significantly different : using inferential statistics -- Significantly significant : what it means for you and me -- Only the lonely: the one-sample z-test -- T(ea) for Two : tests between the means of different groups -- T(ea) for Two (again) : tests between the means of related groups -- Two groups too many? : try analysis of variance -- Two too many factors : factorial analysis of variance?a brief introduction -- Cousins or just good friends? : testing relationships using the correlation coefficient -- Predicting who'll win the super bowl : using linear regression -- Big data (tentative title) -- What to do when you?re not normal : chi-square and some other nonparametric tests -- Some other (important) statistical procedures you should know about -- A statistical software sampler -- Ten things you?ll want to know and remember -- The 10 (or more) best internet sites for statistics stuff -- The 10 commandments of data collection -- Appendix a: spss in less than 30 minutes -- Appendix b: tables -- Appendix c: data sets -- Appendix d: answers to practice questions -- Appendix e: math: just the basics -- Glossary -- Index.