You are here

Core Statistical Concepts With Excel®
Share
Share

Core Statistical Concepts With Excel®
An Interactive Modular Approach



January 2019 | 376 pages | SAGE Publications, Inc
Core Statistical Concepts with Excel® connects statistical concepts to applications with Excel® using practical research examples. The text jointly promotes an understanding of Excel® and a deeper knowledge of core concepts through practice. Authors Gregory J. Privitera and Darryl Mayeaux provide students step-by-step instruction for using Excel® software as a useful tool not only to manage but also analyze data—all through the use of key themes, features, and pedagogy: an emphasis on student learning, a focus on current research, and integration of Excel® to introduce statistical concepts.

 
Preface to the Instructor
 
To the Student
 
Orientation to Excel
 
About the Authors
 
SECTION I. CENTRAL TENDENCY AND VARIABILITY
 
Learning Unit 1. Mean, Median, and Mode
Excel Toolbox

 
Mean

 
Median

 
Mode

 
Choosing an Appropriate Measure of Central Tendency

 
 
Learning Unit 2. Variability
Excel Toolbox

 
Range

 
Quartiles and Interquartiles

 
Variance

 
Standard Deviation

 
 
Learning Unit 3. Shapes of Distributions
Excel Toolbox

 
Normal Distribution Created With Frequency Array Function

 
Normal Distribution Created With a PivotTable

 
Creating a Graph of a Frequency Distribution

 
Skewed Distribution Created With a PivotTable

 
 
SECTION II. PROBABILITY
 
Learning Unit 4. Probability and the Normal Distribution
Excel Toolbox

 
Calculating Probability

 
Expected Value and the Binomial Distribution

 
Relative Frequency and Probability

 
Normal Distribution

 
 
Learning Unit 5. The Standard Normal Distribution: z Scores
Excel Toolbox

 
The Standard Normal Distribution

 
The Unit Normal Table: A Brief Introduction

 
 
Learning Unit 6. Sampling Distributions
Excel Toolbox

 
Selecting Samples From Populations

 
Sampling Distributions: The Mean

 
Computing Characteristics of the Sample Mean Using Excel

 
Sampling Distributions: The Variance

 
Computing Characteristics of the Sample Variance Using Excel

 
 
SECTION III. EVALUATING THE NATURE OF EFFECTS
 
Learning Unit 7. Hypothesis Testing: Significance, Effect Size, and Confidence Intervals
Inferential Statistics and Hypothesis Testing

 
Four Steps to Hypothesis Testing

 
Making a Decision: Types of Error

 
Nondirectional and Directional Alternatives to the Null Hypothesis

 
Effect Size

 
Estimation and Confidence Intervals

 
Delineating Statistical Effects for Hypothesis Testing

 
 
Learning Unit 8. Power
Detecting “Effects”

 
Effect Size, Power, and Sample Size

 
 
SECTION IV. COMPARING MEANS: SIGNIFICANCE TESTING, EFFECT SIZE, AND CONFIDENCE INTERVALS
 
Learning Unit 9. t Tests: One-Sample, Two-Independent-Sample, and Related-Samples Designs
Excel Toolbox

 
Origins of the t Tests

 
Computing the One-Sample t Test

 
Computing the Two-Independent-Sample t Test

 
Computing the Related-Samples t Test

 
 
Learning Unit 10. One-Way Analysis of Variance: Between-Subjects and Repeated-Measures Designs
Excel Toolbox

 
An Introduction to Analysis of Variance (ANOVA)

 
One-Way Between-Subjects ANOVA

 
One-Way Within-Subjects ANOVA

 
Post Hoc Test Using Tukey’s HSD

 
 
Learning Unit 11. Two-Way Analysis of Variance: Between-Subjects Factorial Design
Excel Toolbox

 
An Introduction to Factorial Design

 
Describing Variability: Main Effects and Interactions

 
Computing the Two-Way Between-Subjects ANOVA

 
Analyzing Main Effects and Interactions

 
Measuring Effect Size With Eta Squared

 
Computing the Two-Way Between-Subjects ANOVA Using the Analysis ToolPak

 
 
SECTION V. IDENTIFYING PATTERNS AND MAKING PREDICTIONS
 
Learning Unit 12. Correlation
Excel Toolbox

 
The Structure of Data Used for Identifying Patterns

 
Fundamentals of the Correlation

 
The Strength of a Correlation

 
The Pearson Correlation Coefficient

 
Effect Size: The Coefficient of Determination

 
Hypothesis Testing: Testing for Significance

 
Limitations in Interpretation: Causality, Outliers, and Restriction of Range

 
An Alternative to Pearson for Ranked Data: Spearman

 
An Overview of Other Alternatives to Pearson

 
 
Learning Unit 13. Linear Regression
Excel Toolbox

 
Fundamentals of Linear Regression

 
Using the Method of Least Squares to Find the Regression Line

 
Using Regression to Determine Significance

 
Computing the Analysis of Regression With the Analysis ToolPak

 
 
Appendix A: Core Statistical Concepts
A1: Normal and Skewed Distributions

 
A2: Scales of Measurement

 
A3: Outliers

 
A4: The Empirical Rule for Normal Distributions

 
A5: Chebyshev’s Theorem for Any Type of Distribution

 
A6: Expected Value as a Long-Term Mean

 
A7: The Informativeness of the Mean and Standard Deviation for Finding Probabilities

 
A8: Comparing Differences Between Two Groups

 
A9: Calculation and Interpretation of the Pooled Sample Variance

 
A10: Reducing Standard Error by Computing Difference Scores

 
A11: Categories of Related-Samples Designs

 
A12: Degrees of Freedom for Parametric Tests

 
 
Appendix B: Global Excel Skills
B1: Viewing in Cells the Functions or Formulas Versus the Results of Those Functions or Formulas

 
B2: Formatting Cells: Decimals, Alignment, Merge Cells, Fonts, Bold, Borders, Superscripts, Subscripts

 
B3: Freezing the Display of Some Rows and Columns

 
B4: Highlighting Portions of Spreadsheet, Pasting, or Filling

 
B5: Sorting Data in a Spreadsheet

 
B6: Anchoring Cell References

 
B7: Inserting (Creating) and Formatting a Chart (Graph of Data)

 
B8: Inserting Equations

 
 
Appendix C: Statistical Tables
C1: The Unit Normal Table

 
C2: Critical Values for the t Distribution

 
C3: Critical Values for the F Distribution

 
C4: The Studentized Range Statistic (q)

 
C5: Critical Values for the Pearson Correlation

 
C6: Critical Values for the Spearman Correlation

 
 
Glossary
 
References
 
Index

Supplements

Instructor Resource Site

study.sagepub.com/priviteraexcel1e

A Test Bank is available with this text on a password-protected Instructor Resource Site.


may adopt in future. got exam copy too late for course. Looks solid, and covers a lot of professional uses of excel.

Mr Gwen Urey
Urban/Regional Planning Dept, Cal State Polytechnic-Pomona
August 8, 2019
Key features

 

  • Organization that builds upon concepts and skills makes the book accessible for students using the book as their core text to understand concepts or to sharpen their technical skills in Excel®.
  • Section-opening vignettes use everyday language to connect students to the material and prepare them for the forthcoming material.
  • Step-by-step exercises with the Excel® skills needed to work through them help students understand illustrated concepts.
  • Skill Set Toolbox sections outline the skills in Excel® that students will master in each learning unit.
  • A Core Statistical Concepts Appendix and Global Excel® Skills Appendix compile in one place the core skills in statistics and Excel® that students need across learning units.

 

 

Sage College Publishing

You can purchase or sample this product on our Sage College Publishing site:

Go To College Site

This title is also available on SAGE Research Methods, the ultimate digital methods library. If your library doesn’t have access, ask your librarian to start a trial.