Excel Statistics: A Quick Guide 3rd Edition, (Ebook PDF)

Excel Statistics: A Quick Guide 3rd Edition, (Ebook PDF) – Digital Instant Dowload.

Product details:

• ISBN-10 ‏ : ‎ 1483374041
• ISBN-13 ‏ : ‎ 978-1483374048
• Author: Neil J. 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.

Table 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

Title Tag:

Excel Statistics: Simplified Guide for Beginners
Mastering Excel Statistics: A Comprehensive Quick Guide
Your Quick Guide to Understanding Excel Statistics