You are here

Excel Statistics

Excel Statistics
A Quick Guide

Third Edition
Additional resources:

July 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 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 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  
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
March 10, 2016
Key features


  • New data sets along with expanded Excel functions and ToolPak features provide additional opportunities for students to work with and understand the data.
  • Screenshots and steps feature Microsoft Excel 2013 and are compatible with Microsoft 97 –2003 and Excel 5.0/95 for students using previous program versions.
  • Part II now includes five new database functions that cover computing averages, tests of significance, and looking at data, to help readers organize and analyze information.


  • An online Excel data file accompanies each function and tool covered to provide examples of each analysis.  
  • Flow charts throughout help the reader determine which function to use and when, and a helpful What To Use When table summarizes key functions for the Data Analysis Toolpak.

Sample Materials & Chapters

Excel Quick Guide 10

Excel QuickGuide 47

Preview this book

For instructors

Review and Desk copies for this title are available digitally via VitalSource.

Request e-review copy

If you require a print review copy, please call: (800) 818-7243 ext. 6140 or email

Select a Purchasing Option

Electronic version
Prices from
*180 day rental