Bookstore

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 (R) Excel's functions and Analysis ToolPak to answer simple and complex questions about data.



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.



Ancillaries

Actual data files used in the examples are readily available online at an open-access Student Study Site.



TOC

Part I explores 35 Excel functions, while Part II contains 20 Analysis ToolPak tools. "The explanations are simple, concise, thorough, and easy to follow. The book covers everything you would want a book like this to cover. It is an excellent resource..." -- Darrell Johnson, Carroll University "My students, as geographers, don't really need to understand the in-depth math behind the statistics, I really like that it's straightforward and simple." -- Caitlin Finlayson, University of Mary Washington "The plentiful example data and exercises (with answers) are really useful for enabling students to confidently enact each of the methods." -- Jamal Lahmar, The University of Sheffield, England "Dr. Salkind's approach is so helpful for [readers], as it's very guided and with very clear written directions. [T]he level of difficulty is just perfect for them and that is why I really prefer using his materials." -- Deborah C. Messecar, Oregon Health & Science University "The book covers the most important aspects for an introduction to Excel." -- Stephen Sammut, Franciscan University of Steubenville "I think this text will serve as a great reference, one that I believe my students will use outside of class in years to come." -- Eric Teoro, Lincoln Christian University "I liked this text because it enables students to use software they already have." -- Kay Davis, Pepperdine University

Excel Statistics: A Quick Guide

PART I: Using Excel Functions

1. Computing Averages

The AVERAGE Function

The AVERAGE A Function

The MEDIAN Function

The MODE.SNGL Function

The MODE.MULT Function

GEOMEAN Function

2. Looking at Variability

The STDEV.S Function

The STDEV.P Function

The VAR.S Function

The VAR.P Function

3. Describing Data

The FREQUENCY Function

The NORM.DIST Function

The PERCENTILE.INC Function

The PERCENTRANK.INC Function

The QUARTILE.INC Function

The RANK.AVG Function

The STANDARDIZE Function

4. Looking at Relationships

The COVARIANCE.S Function

The CORREL Function

The PEARSON Function

The INTERCEPT Function

The SLOPE Function

The TREND Function

The FORECAST Function

The RSQ Function

5. Testing Independence

The CHISQ.DIST Function

The CHISQ.TEST Function

6. Testing Significance

The F.DIST Function

The CONFIDENCE.NORM Function

The F.TEST Function

The T.DIST Function

The T.TEST Function

The Z.TEST Function

7. Looking at Data

The SMALL Function

The LARGE Function

The AVERAGEW IF Function

The COUNT Function

The COUNTA Function

The COUNTBLANK Function

The COUNTIF Function

PART II: Using the Analysis ToolPak

8. Describing Data

Descriptive Statistics

Moving Average

Random Number Generation

Rank and Percentile

Sampling

9. Comparing Means

z-Test: Two-Sample for Means

t-Test: Paired Two-Sample for Means

t-Test: Two-Sample Assuming Unequal Variances

t-Test: Two-Sample Assuming Equal Variances

Anova: Single Factor

Anova: Two-Factor With Replication

Anova: Two-Factor Without Replication

10. Looking at Relationships

The Correlation Tool

The Regression Tool

11. Illustrating Data

The Histogram Tool