Excel statistics : a quick guide
著者
書誌事項
Excel statistics : a quick guide
SAGE, c2013
2[nd] ed
- : [pbk.]
大学図書館所蔵 件 / 全1件
-
該当する所蔵館はありません
- すべての絞り込み条件を解除する
注記
Includes index
内容説明・目次
内容説明
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.
目次
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)
「Nielsen BookData」 より