Schmuller J. Statistical Analysis with Excel For Dummies

John Wiley & Sons, Inc., 2013. - 530 Pages. 3rd Edition. На англ. языке.Пусть Вас не вводит в заблуждение название книги - она не учит статистике, а рассказывает как новейшие инструменты Excel возможно использовать для простейшего статистического анализа разнообразных данных.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 understand
Explains 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 more
Covers formulas and functions, charts and PivotTables, samples and normal distributions, probabilities and related distributions, trends, and correlations
Clarifies statistical terms such as median vs. mean, margin of error, standard deviation, correlations, and permutations
Statistical Analysis with Excel For Dummies, 3rd Edition helps you make sense of statistics and use Excel’s statistical analysis tools in your daily life.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