Designed for users already familiar with basic computer operations, Neil J. Salkind’s Excel Statistics: A Quick Guide shows readers how to utilize the features of Microsoft Excel to answer both simple and complex questions about data analysis. Excel novices and experts alike will find this text not only practical but easy to use and engaging. Key features: - Each function and tool is accompanied by an Excel file, accessible through the SAGE Web site, to be used as an example of each analysis. Access these files through the SAGE website or through www.onlinefilefolder.com. - The screenshots and steps feature Microsoft Excel 2010 and are compatible with Microsoft 97–2003 and Excel 5.0/95. INDICE: Part I. Using Excel Functions1. 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 Function2. 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 Function3. 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 Function4. 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 Function5. Tests of Independence Excel QuickGuide 24. The CHISQ.DIST Function Excel QuickGuide 25. The CHISQ.TEST Function6. 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 Function7. 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 FunctionPart II. Using the Analysis Toolpak8. 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. Sampling9. 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 Replication10. Looking at Relationships Excel QuickGuide 48. The Correlation Tool Excel QuickGuide 49. The Regression Tool11. Illustrating Data Excel QuickGuide 50. The Histogram ToolAppendix A. Answers to QuickGuide QuestionsAppendix B. The Formula Builder (for Mac users)
- ISBN: 978-1-4522-5792-1
- Editorial: SAGE Publications, Inc
- Encuadernacion: Rústica
- Páginas: 160
- Fecha Publicación: 16/01/2013
- Nº Volúmenes: 1
- Idioma: