Excel Statistics : A Quick Guide /: A Quick Guide. ([2013])

• Record Type: Book
• Further Information: Note: Neil J. Salkind.
• Authors: Salkind, Neil J
• Contents: 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);
• Edition: 2nd Edition
• Publisher Details: Los Angeles : SAGE
• Publication Date: 2013
• Extent: 1 online resource, illustrations
• Subjects: 005.54; Social sciences -- Statistical methods -- Computer programs; Electronic spreadsheets
• Languages: English
• ISBNs: 9781506316314
• Related ISBNs: 150631631X; 9781452257921; 1452257922
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.