You are here

Excel Statistics
Share

Excel Statistics
A Quick Guide

Third Edition
Additional resources:


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

“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

Sample Materials & Chapters

Excel Quick Guide 10

Excel QuickGuide 47


Preview this book

For instructors

This book is not available as an inspection copy. For more information contact your local sales representative.

Select a Purchasing Option


Paperback
ISBN: 9781483374048
£25.99

SAGE Knowledge is the ultimate social sciences digital library for students, researchers, and faculty. Hosting more than 4,400 titles, it includes an expansive range of SAGE eBook and eReference content, including scholarly monographs, reference works, handbooks, series, professional development titles, and more.

The platform allows researchers to cross-search and seamlessly access a wide breadth of must-have SAGE book and reference content from one source.

SAGE Knowledge brings together high-quality content from across our imprints, including CQ Press and Corwin titles.