Excel Statistics A Quick Guide 3rd Edition by Neil Salkind – Ebook PDF Instant Download/Delivery: 148337405X, 9781483374055
Full download Excel Statistics A Quick Guide 3rd edition after payment
Product details:
ISBN 10: 148337405X
ISBN 13: 9781483374055
Author: Neil Salkind
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.
Excel Statistics A Quick Guide 3rd Table of contents:
Part I. Using Excel Functions
1. Computing Averages
Excel QuickGuide 1 The AVERAGE Function
Excel QuickGuide 2 The AVERAGEA Function
Excel QuickGuide 3 The MEDIAN Function
Excel QuickGuide 4 The MODE.SNGL Function
Excel QuickGuide 5 The MODE.MULT Function
Excel QuickGuide 6 The GEOMEAN Function
2. Looking at Variability
Excel QuickGuide 7 The STDEV.S Function
Excel QuickGuide 8 The STDEV.P Function
Excel QuickGuide 9 The VAR.S Function
Excel QuickGuide 10 The VAR.P Function
3. Describing Data
Excel QuickGuide 11 The FREQUENCY Function
Excel QuickGuide 12 The NORM.DIST Function
Excel QuickGuide 13 The PERCENTILE.INC Function
Excel QuickGuide 14 The PERCENTRANK.INC Function
Excel QuickGuide 15 The QUARTILE.INC Function
Excel QuickGuide 16 The RANK.AVG Function
Excel QuickGuide 17 The STANDARDIZE Function
4. Looking at Relationships
Excel QuickGuide 18 The COVARIANCE.S Function
Excel QuickGuide 19 The CORREL Function
Excel QuickGuide 20 The PEARSON Function
Excel QuickGuide 21 The INTERCEPT Function
Excel QuickGuide 22 The SLOPE Function
Excel QuickGuide 23 The TREND Function
Excel QuickGuide 24 The FORECAST Function
Excel QuickGuide 25 The RSQ Function
5. Testing Independence
Excel QuickGuide 26 The CHISQ.DIST Function
Excel QuickGuide 27 The CHISQ.TEST Function
6. Testing Significance
Excel QuickGuide 28 The F.DIST Function
Excel QuickGuide 29 The CONFIDENCE.NORM Function
Excel QuickGuide 30 The F.TEST Function
Excel QuickGuide 31 The T.DIST Function
Excel QuickGuide 32 The T.TEST Function
Excel QuickGuide 33 The Z.TEST Function
7. Looking at Data
Excel QuickGuide 34 The SMALL Function
Excel QuickGuide 35 The LARGE Function
Excel QuickGuide 36 The AVERAGEIF Function
Excel QuickGuide 37 The COUNT Function
Excel QuickGuide 38 The COUNTA Function
Excel QuickGuide 39 The COUNTBLANK Function
Excel QuickGuide 40 The COUNTIF Function
Part II. Using the Analysis ToolPak
8. Describing Data
Excel QuickGuide 41 Descriptive Statistics
Excel QuickGuide 42 Moving Average
Excel QuickGuide 43 Random Number Generator
Excel QuickGuide 44 Rank and Percentile
Excel QuickGuide 45 Sampling
9. Comparing Means
Excel QuickGuide 46 z-Test: Two-Sample for Means
Excel QuickGuide 47 t-Test: Paired Two-Sample for Means
Excel QuickGuide 48 t-Test: Two-Sample Assuming Unequal Variances
Excel QuickGuide 49 t-Test: Two-Sample Assuming Equal Variances
Excel QuickGuide 50 Anova: Single Factor
Excel QuickGuide 51 Anova: Two-Factor With Replication
Excel QuickGuide 52 Anova: Two-Factor Without Replication
10. Looking at Relationships
Excel QuickGuide 53 The Correlation Tool
Excel QuickGuide 54 The Regression Tool
11. Illustrating Data
Excel QuickGuide 55 The Histogram Tool
Appendix A. Answers to QuickGuide Questions
Appendix B. Using the Macintosh Excel Formula Builder
Index
People also search for Excel Statistics A Quick Guide 3rd:
excel statistics a quick guide pdf
3.0 excel activity 1 – statistical functions and analysis (tutorial)
quick statistics excel
excel statistics a quick guide third edition pdf
1-3 excel workbook descriptive statistics and charts using excel
Tags: Neil Salkind, Excel Statistics, Quick Guide