Want an Effect Size (Cohen's d) Calculator in Excel?

QI Macros has a Ready-Made Cohen's d Calculator Template!

cohen's d calculator output

Go Deeper: What is Effect Size and Cohen's d?

Effect Size measures the relationship between two variables (how large an effect is). The larger the effect size, the stronger the relationship between two variables.

Cohen's d measures the DIFFERENCE between two variables' means divided by the Standard Deviation. If two groups have similar standard deviations and have the same group size, use Cohen's d. Note: It can only be used with normal data distributions.

Cohen's d Effect Size categorization:

d = 0.2 | SMALL (0.2 means the difference between the two groups' means is less than 0.2 Standard Deviations)

d = 0.3 - 0.5 | MEDIUM

d = 0.8 + | LARGE

NOTE: A d of 1 suggests the two groups differ by 1 Standard Deviation, while a d of 2 suggests 2 Standard Deviations, etc.

Where are these calculators located within QI Macros?

These values are calculated automatically and can be found in the following t-Test templates, located in the QI Macros > Stat Templates drop-down menu:

stat templates menu

  1. Two-Sample Assuming Equal Variances
  2. Two-Sample Assuming Unequal Variances
  3. Paired Two Sample for Means

cohen's d calculator output

Haven't you waited long enough?
Start creating your Cohen's d Calculation in just minutes.

Download a free 30-day trial. Get the Cohen's d Calculation now!

The Cohen's d Calculation is one of many tools included in QI Macros add-in for Excel.

QI Macros adds a new tab to Excel's menu, making it easy to find any tool you need. If you can't locate a tool, use the find tools feature on the far right side of QI Macros menu.

find tools on QI Macros menu

Learn More...

Why Choose QI Macros Statistical Software for Excel?

easy to use

Easy to Use

  • Works Right in Excel
  • Interprets p-values for You
  • Accurate No-Worry Results
  • Free Training Anytime

proven and trusted

Proven and Trusted

  • 100,000 Users in 80 Countries
  • Celebrating 20th Anniversary
  • Five Star CNET Rating - Virus Free



  • Only $349 USD
    Quantity Discounts Available
  • No annual fees
  • Free Technical Support