Cover image not available
Includes index.
Part I. Using Excel Functions
1. Computing Averages
Excel QuickGuide 1. The AVERAGE Function
Excel QuickGuide 2. The MEDIAN Function
Excel QuickGuide 3. The MODE.SNGL Function
Excel QuickGuide 4. The GEOMEAN Function
2. Looking at Variability
Excel QuickGuide 5. The STDEV.S Function
Excel QuickGuide 6. The STDEV.P Function
Excel QuickGuide 7. The VAR.S Function
Excel QuickGuide 8. The VAR.P Function
3. Describing Data
Excel QuickGuide 9. The FREQUENCY Function
Excel QuickGuide 10. The NORM.DIST Function
Excel QuickGuide 11. The PERCENTILE.INC Function
Excel QuickGuide 12. The PERCENTRANK.INC Function
Excel QuickGuide 13. The QUARTILE.INC Function
Excel QuickGuide 14. The RANK.AVG Function
Excel QuickGuide 15. The STANDARDIZE Function
4. Looking at Relationships
Excel QuickGuide 16. The COVARIANCE.S Function
Excel QuickGuide 17. The CORREL Function
Excel QuickGuide 18. The PEARSON Function
Excel QuickGuide 19. The INTERCEPT Function
Excel QuickGuide 20. The SLOPE Function
Excel QuickGuide 21. The TREND Function
Excel QuickGuide 22. The FORECAST Function
Excel QuickGuide 23. The RSQ Function
5. Tests of Independence
Excel QuickGuide 24. The CHISQ.DIST Function
Excel QuickGuide 25. The CHISQ.TEST Function
6. Tests of Significance
Excel QuickGuide 26.The F.DIST Function
Excel QuickGuide 27. The F.TEST Function
Excel QuickGuide 28. The T.DIST Function
Excel QuickGuide 29. The T.TEST Function
Excel QuickGuide 30. The Z.TEST Function
7. Looking at Data
Excel QuickGuide 31. The AVERAGEIF Function
Excel QuickGuide 32. The COUNT Function
Excel QuickGuide 33. The COUNTA Function
Excel QuickGuide 34. The COUNTBLANK Function
Excel QuickGuide 35. The COUNTIF Function
Part II. Using the Analysis Toolpak
8. Describing Data
Excel QuickGuide 36. Descriptive Statistics
Excel QuickGuide 37. Moving Average
Excel QuickGuide 38. Random Number Generation
Excel QuickGuide 39. Rank and Percentile
Excel QuickGuide 40. Sampling
9. Comparing Means
Excel QuickGuide 41. z-Test: Two-Sample for Means
Excel QuickGuide 42. t-Test: Paired Two-Sample for Means
Excel QuickGuide 43. t-Test: Two-Sample Assuming Unequal Variances
Excel QuickGuide 44. t-Test: Two-Sample Assuming Equal Variances
Excel QuickGuide 45. Anova: Single Factor
Excel QuickGuide 46. Anova: Two-Factor with Replication
Excel QuickGuide 47. Anova: Two-Factor without Replication
10. Looking at Relationships
Excel QuickGuide 48. The Correlation Tool
Excel QuickGuide 49. The Regression Tool
11. Illustrating Data
Excel QuickGuide 50. The Histogram Tool
Appendix A. Answers to QuickGuide Questions
Appendix B. The Formula Builder (for Mac users)
OBNB doesn't sell books, but you may be able to find a copy at one of these websites:
Excel Statistics : A Quick Guide by Neil J. Salkind. ISBN 9781506316314. Published by SAGE in 2013. Publication and catalogue information, links to buy online and reader comments.