You are here

Excel Statistics

Excel Statistics
A Quick Guide

Third Edition

August 2015 | 168 pages | SAGE Publications, Inc

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. 

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 RANK.AVG Function


4. Looking at Relationships

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 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 COUNTIF Function

PART II: Using the Analysis ToolPak
8. Describing Data
Descriptive Statistics

Moving Average

Random Number Generation

Rank and Percentile


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



Student Study Site
Download the Excel data files that accompany the book to put your new skills into practice!  

“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

Provides straight forward, easily understood directions regarding some of Excel's more complex analytical functions. Appropriate when used in conjunction with the primary text: Crime Analysis with Crime Mapping by Rachel Boba Santos.

Mr James Forrest Hadley
General Studies Dept, Northwest Christian Univ
February 16, 2016

Sample Materials & Chapters

Excel Quick Guide 10

Excel QuickGuide 47

For instructors

Select a Purchasing Option