Statistics Help

On this page, I will list guides to various statistics topics.  If you don’t see a topic that you’re interested in, please contact me at and I will consider adding it (when I have time).


One-Way ANOVA in Excel

One-Way ANOVA in Jamovi

One-Way ANOVA in R


One-Way ANOVA Practice

Two-Way ANOVA in Excel

Two-Way ANOVA in Jamovi

Two-Way ANOVA in R


Two-Way ANOVA Practice

Basic Statistical Concepts

Conceptual Variables and Actual Measures

Independent Variables and Dependent Variables


Correlation Does NOT Equal Causation (Links to


Chi-Square in Excel (One Variable)

Chi-Square Test of Independence in Excel (Two Variable)

Chi-Square in Jamovi

Chi-Square in R

Chi-Square in SPSS

Chi-Square Practice

Video Lecture on Chi-Square Tests (One and Two Variable)


Correlations in Excel

Correlations in Jamovi

Correlations in R

Correlations in SPSS

Correlation Practice

Cronbach’s Alpha

Cronbach’s Alpha in Jamovi

Cronbach’s Alpha in R

Cronbach’s Alpha in SPSS

Introduction to Cronbach’s Alpha

Descriptive Statistics

Descriptive Statistics in Jamovi

How to Calculate Descriptive Statistics in Excel

Identifying Multiple Modes in Excel

Video Lecture on Descriptive Statistics (Opens in YouTube)


Dummy-Coded Regression in Excel

Dummy-Coded Regression in Jamovi

Dummy-Coded Regression in R

Dummy-Coded Regression in SPSS

Dummy-Coded Regression Practice


Activating “Data Analysis” in Excel

Excel Statistics Help

Factorial Designs

Two Condition Full Factorial Designs

Helpful Tools and Guides from Around the Internet

Helpful Online Statistics Tools

Item-Sort Task

Item-Sort Tasks’ Logic, Method, and Statistics


Jamovi Statistics Help

Opening .csv Files in Jamovi


Mediation (Sobel Test) Practice

Mediation with Regression in Excel (Sobel Test)

Sobel Test Formula for Serial Mediation / Sequential Mediation

Sobel Test Calculator for Serial Mediation / Sequential Mediation

Testing for Dual Mediation


Seven Things You Should Know about CMA (Comprehensive Meta-Analysis)


Regression Toward the Mean (Links to


Moderation Practice

Moderation with Regression in Excel


P-Hacking (Links to

The Meaning of p-Values: A Guide for Social and Organizational Science
Students & Researchers

The p-Value Controversy: A Guide for Social and Organizational Science
Students & Researchers

Partial Correlation

Partial Correlations in R

Partial Correlation in SPSS




Prediction with Regression in Excel


Rules of Probability

Quadratic Regression

Quadratic Regression in Excel

Quadratic Regression in Jamovi

Quadratic Regression in R

Quadratic Regression in SPSS

Quadratic Regression Practice

Quadratic Trendlines in Excel


Downloading R

Installing Packages in R

Opening .csv File in R

R Statistics Help


Regression in Excel

Regression in Jamovi

Regression in R

Regression in SPSS

Regression Practice

Sample Size

Bias with Small Sample Sizes and/or Non-Representative Samples (Links to

Scale Creation

Writing Items for a Scale


List of Commonly-Used Scales


SPSS Statistics Help


One-Sample T-Test in Excel

One-Sample T-Test in Jamovi

One-Sample T-Test in R

One-Sample T-Test in SPSS

Two-Sample T-Test in Excel

Two-Sample T-Test in Jamovi

Two-Sample T-Test in R

Two-Sample T-Test in SPSS

Two-Sample T-Test Practice


Finding the Probability of Z-Value Ranges

11 thoughts on “Statistics Help

  1. How to Perform a T-Test in Excel – Dr. Matt C. Howard

  2. Descriptive Statistics in Excel – Dr. Matt C. Howard

  3. Excel Statistics Help – Statistical Bullshit

  4. Regression and More in Excel and SPSS – Dr. Matt C. Howard

  5. Quadratic & Dummy-Coded Regression in Excel and SPSS – Dr. Matt C. Howard

  6. One-Sample and Two-Sample T-Test in Excel and SPSS – Dr. Matt C. Howard

  7. ANOVA and Chi-Square in Excel and SPSS – Dr. Matt C. Howard

  8. Practice in Excel and SPSS – Statistical Bullshit

  9. Rules of Probability – Statistical Bullshit

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s