You are here

Excel Statistics
Share

Excel Statistics
A Quick Guide

Third Edition
Companion Website


© 2016 | 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 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  

Supplements

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

Sample Materials & Chapters

Excel Quick Guide 10

Excel QuickGuide 47


Preview this book

For instructors

Inspection copies for this title are available digitally via VitalSource.

e-inspection copy

If you require a print inspection copy, please contact your local sales rep

Purchasing options

Please select a format:

ISBN: 9781483374048