Excel statistics : a quick guide

Ideal for those already familiar with basic Excel features, this updated Third Edition of Neil J. Salkind's 'Excel Statistics: A Quick Guide' shows readers how to utilize Microsoft® Excel's functions and Analysis ToolPak to answer simple and complex questions about data. Part I explores 35 Excel functions, while Part II contains 20 Analysis ToolPak tools. To make it easy to see what each function or tool looks like when applied, at-a-glance two-page spreads describe each function and its use with corresponding screenshots. In addition, actual data files used in the examples are readily available online at an open-access Student Study Site.-- Provided by publisher Cover Title Page Copyright Page Contents How to Use This Book Who Excel Statistics: A Quick Guide Is For How to Use Excel Statistics: A Quick Guide About the Windows and Macintosh Versions About the Third Edition Acknowledgments and Dedication About the Author What to Use When What to Use When What You Want to Find Out Part I. Using Excel Functions Here’s a Simple Example The Anatomy of a Function Entering a Function Manually Entering a Function Automatically Another Way to Enter Functions Automatically More About Function Names More About the RefEditButton and Collapsing and Expanding Excel QuickGuide 1. Computing Averages 1. The AVERAGE Function What the AVERAGE Function Does The Data Set Using the Average Function Check Your Understanding 2. The AVERAGEA Function What the AVERAGEA Function Does The Data Set Using the AVERAGEA Function Check Your Understanding 3. The MEDIAN Function What the MEDIAN Function Does The Data Set Using the MEDIAN Function Check Your Understanding 4. The MODE.SNGL Function What the MEDIAN Function Does The Data Set Using the MEDIAN Function Check Your Understanding 5. The MODE.MULT Function What the MODE.MULT Function Does The Data Set Using the MODE.MULT Function Check Your Understanding 6. The GEOMEAN Function What the GEOMEAN Function Does The Data Set Using the GEOMEAN Function Check Your Understanding 2. Looking at Variability 7. The STDEV.S Function What the STDEV.S Function Does The Data Set Using the STDEV.S Function Check Your Understanding 8. The STDEV.P Function What the STDEV.P Function Does The Data Set Using the STDEV.P Function Check Your Understanding 9. The VAR.S Function What the VAR.S Function Does The Data Set Using the VAR.S Function Check Your Understanding 10. The VAR.P Function What the VAR.P Function Does The Data Set Using the VAR.P Function Check Your Understanding 3. Describing Data 11. The FREQUENCY Function What the FREQUENCY Function Does The Data Set Using the FREQUENCY Function Check Your Understanding 12. The NORM.DIST Function What the NORM.DIST Function Does The Data Set Using the NORM.DIST Function Check Your Understanding 13. The PERCENTILE.INC Function What the PERCENTILE.INC Function Does The Data Set Using the PERCENTILE.INC Function Check Your Understanding 14. The PERCENTRANK.INC Function What the PERCENTRANK.INC Function Does The Data Set Using the PERCENTRANK.INC Function Check Your Understanding 15. The QUARTILE.INC Function What the QUARTILE.INC Function Does The Data Set Using the QUARTILE.INC Function Check Your Understanding 16. The RANK.AVG Function What the RANK.AVG Function Does The Data Set Using the RANK.AVG Function Check Your Understanding 17. The STANDARDIZE Function What the STANDARDIZE Function Does The Data Set Using the STANDARDIZE Function Check Your Understanding 4. Looking at Relationships 18. The COVARIANCE.S Function What the COVARIANCE.S Function Does The Data Set Using the COVARIANCE.S Function Check Your Understanding 19. The CORREL Function What the CORREL Function Does The Data Set Using the CORREL Function Check Your Understanding 20. The PEARSON Function What the PEARSON Function Does The Data Set Using the PEARSON Function Check Your Understanding 21. The INTERCEPT Function What the INTERCEPT Function Does The Data Set Using the INTERCEPT Function Check Your Understanding 22. The SLOPE Function What the SLOPE Function Does The Data Set Using the SLOPE Function Check Your Understanding 23. The TREND Function What the TREND Function Does The Data Set Using the TREND Function Check Your Understanding 24. The FORECAST Function What the FORECAST Function Does The Data Set Using the FORECAST Function Check Your Understanding 25. The RSQ Function What the RSQ Function Does The Data Set Using the RSQ Function Check Your Understanding 5. Testing Independence 26. The CHISQ.DIST Function What the CHISQ.DIST Function Does The Data Set Using the CHISQ.DIST Function Check Your Understanding 27. The CHISQ.TEST Function What the CHISQ.TEST Function Does The Data Set Using the CHISQ.TEST Function Check Your Understanding 6. Testing Significance 28. The F.DIST Function What the F.DIST Function Does The Data Set Using the F.DIST Function Check Your Understanding 29. The CONFIDENCE.NORM Function What the CONFIDENCE.NORM Function Does The Data Set Using the CONFIDENCE.NORM Function Check Your Understanding 30. The F.TEST Function What the F.TEST Function Does The Data Set Using the F.TEST Function Check Your Understanding 31. The T.DIST Function What the T.DIST Function Does The Data Set Using the T.DIST Function Check Your Understanding 32. The T.TEST Function What the T.TEST Function Does The Data Set Using the T.TEST Function Check Your Understanding 33. The Z.TEST Function What the Z.TEST Function Does The Data Set Using the Z.TEST Function Check Your Understanding 7. Looking at Data 34. The SMALL Function What the SMALL Function Does The Data Set Using the SMALL Function Check Your Understanding 35. The LARGE Function What the LARGE Function Does The Data Set Using the LARGE Function Check Your Understanding 36. The AVERAGEIF Function What the AVERAGEIF Function Does The Data Set Using the AVERAGEIF Function Check Your Understanding 37. The COUNT Function What the COUNT Function Does The Data Set Using the COUNT Function Check Your Understanding 38. The COUNTA Function What the COUNTA Function Does The Data Set Using the COUNTA Function Check Your Understanding 39. The COUNTBLANK Function What the COUNTBLANK Function Does The Data Set Using the COUNTBLANK Function Check Your Understanding 40. The COUNTIF Function What the COUNTIF Function Does The Data Set Using the COUNTIF Function Check Your Understanding Part II. Using the Analysis ToolPak Installing the Analysis ToolPak Using the Analysis ToolPak Tools Excel QuickGuide 8. Describing Data 41. Descriptive Statistics What the Descriptive Statistics Tool Does The Data Set Using the Descriptive Statistics Tool The Final Output Check Your Understanding 42. Moving Average What the Moving Average Tool Does The Data Set Using the Moving Average Tool The Final Output Check Your Understanding 43. Random Number Generator What the Random Number Generator Tool Does The Data Set Using the Random Number Generator Tool The Final Output Check Your Understanding 44. Rank and Percentile What the Rank and Percentile Tool Does The Data Set Using the Rank and Percentile Tool The Final Output Check Your Understanding 45. Sampling What the Sampling Tool Does The Data Set Using the Sampling Tool The Final Output Check Your Understanding 9. Comparing Means 46. z-Test: Two-Sample for Means What the z-Test: Two-Sample for Means Tool Does The Data Set Using the z-Test: Two-Sample for Means Tool The Final Output Check Your Understanding 47. t-Test: PairedTwo-Sample for Means What the t-Test: Paired Two-Sample for Means Tool Does The Data Set Using the t-Test: Paired Two-Sample for Means Tool The Final Output Check Your Understanding 48. t-Test: Two-Sample Assuming Unequal Variances What the t-Test: Two-Sample Assuming Unequal Variances Tool Does The Data Set Using the t-Test: Two-Sample Assuming Unequal Variances Tool The Final Output Check Your Understanding 49. t-Test: Two-Sample Assuming Equal Variances What the t-Test: Two-Sample Assuming Equal Variances Tool Does The Data Set Using the t-Test: Two-Sample Assuming Equal Variances Tool The Final Output Check Your Understanding 50. Anova: Single Factor What the Anova: Single Factor Tool Does The Data Set Using the Anova: Single Factor Tool The Final Output Check Your Understanding 51. Anova: Two-Factor With Replication What the Anova: Two-Factor With Replication Tool Does The Data Set Using the Anova: Two-Factor With Replication Tool The Final Output Check Your Understanding 52. Anova: Two-Factor Without Replication What the Anova: Two-Factor Without Replication Tool Does The Data Set Using the Anova: Two-Factor Without Replication Tool The Final Output Check Your Understanding 10. Looking at Relationships 53. The Correlation Tool What the Correlation Tool Does The Data Set Using the Correlation Tool The Final Output Check Your Understanding 54. The Regression Tool What the Regression Tool Does The Data Set Using the Regression Tool The Final Output Check Your Understanding 11. Illustrating Data 55. The Histogram Tool What the Histogram Tool Does The Data Set Using the Histogram Tool The Final Output Check Your Understanding Appendix Appendix A. Answers to QuickGuide Questions Appendix B. Using the Macintosh Excel Formula Builder Index