You are here

Excel Statistics
Share

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

NEW TO THIS EDITION:

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

 KEY FEATURES:

  • 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 textsales@sagepub.com.

Select a Purchasing Option

Electronic version
Prices from
$17.00*
*180 day rental

This title is also available on SAGE Knowledge, the ultimate social sciences online library. If your library doesn’t have access, ask your librarian to start a trial.