You are here

This is a test website. For our live site please visit www.sagepub.com

We’re currently experiencing issues with our website. If you need assistance with ordering an inspection copy, please contact our Customer Service team at inspectioncopies@sagepub.co.uk or your local representative for assistance. Thank you for your patience and we apologise for the inconvenience

Excel Statistics
A Quick Guide

Third Edition

Neil J. Salkind

Other Titles in:
Quantitative Techniques for Business & Management Research | Quantitative/Statistical Research (General) | Research Methods in Psychology

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!

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

Report this review