Find a detectable mean difference

Estimate the difference needed to reach a target power at a fixed sample size.

Guides · Basic statistics · 4 min read

Example: sixty sachets per group

Plan 60 independent sachet-fill measurements per group, 120 total, with common SD 4 g and 90% target power. The reference scenario is adapted to equal allocation.

Download the planning reference (CSV)

This is the same example used in Help. The CSV lists reference scenarios. Enter the selected planning values manually on Inputs; importing it does not configure this calculator. Use Open example in a practice copy in Help to prefill the inputs.

1. Create the workspace

In the sidebar, open Basic Statistics and choose Power & Sample Size. Create an analysis, name it, select New blank worksheet, then choose Create analysis.

2. Choose the study

On Inputs, choose Two-sample t — pooled planning for Test and Mean difference for Solve for. Enter 0.05 in Significance level (α) and choose Two-sided for Alternative hypothesis.

3. Enter the planning values

Enter one value in each field for this scenario. No worksheet columns are assigned.

Enter 4 in Common standard deviation (σ).

Enter 60 in Sample sizes per group.

Enter 0.9 in Target powers.

Power & Sample Size: Inputs with the example’s assignments and settings
Inputs with the selected test, quantity to calculate and active planning assumptions. View full-size image (opens in a new tab)

4. Run analysis

Choose Run analysis, then open Results.

5. Interpret results

  1. Check the planned study

    Plan 60 independent sachet-fill measurements per group, 120 total, with common SD 4 g and 90% target power. The reference scenario is adapted to equal allocation.

  2. Read the calculated plan

    The Branch label upper means the positive difference solution: about +2.3868 g gives 90% power. The symmetric −2.3868 g difference has the same power in this two-sided plan. Smaller differences can still be detected, but less reliably.

  3. Follow the power curve

    The curve holds sample size at 60 per group. It reaches 90% near ±2.3868 g; smaller absolute differences have lower power.

    Power versus effect
    Power versus effect View full-size chart (opens in a new tab)
  4. Understand the assumptions

    Power is the chance that the planned test detects the specified difference when that difference is real, under the entered assumptions. It is not the chance that a hypothesis is true and does not guarantee a significant result. This is a pooled t-test plan with equal sizes, independent normal groups and common SD. “Detectable” refers to the chosen 90% power, not a hard boundary below which a test can never detect a difference.

  5. Decide how to collect the sample

    Compare 2.3868 g with the smallest difference that matters. Increase the planned sample if you need 90% power for a smaller effect.

More details: read each result section

Complete result tables use six significant digits, as in Help.

Power and sample size scenarios

Scenario links this row to its input values. Branch upper names the positive difference solution; it is not an upper confidence bound. A dash means a branch does not apply. Sample size is per group for two-group plans; Total observations counts both groups. Mean difference or Comparison proportion is the effect being planned. Target power is the request; Achieved power is the calculated result. Power at preceding size checks one fewer observation per group. DF is the t-test degrees of freedom, where applicable. Status and Details record whether the scenario was calculated. The displayed upper branch gives a positive mean difference of 2.38678 g for 90% power. For this two-sided mean test, an equally large negative difference has the same power.

Power and sample size scenarios · 1 row
ScenarioBranchSample size per groupTotal observationsMean differenceTarget powerAchieved powerPower at preceding sizeDFStatusDetails
1upper601202.386780.90.9—118ok—
  • Unavailable branches retain their status and input values. Pairs count two observations each. A preceding-size power is reported only when that size is valid.

Planning method

Method and Calibration identify the calculation used. Alpha 0.05 is the test significance level; Alternative two-sided includes both directions. Solve for names the quantity being calculated. Assumptions and Planning SD or Baseline proportion record what the result depends on. This is a pooled t-test plan with equal sizes, independent normal groups and common SD. “Detectable” refers to the chosen 90% power, not a hard boundary below which a test can never detect a difference.

Planning method · 7 rows
SettingValue
MethodTwo-sample t
Calibrationpooled-noncentral-t-v1
Alpha0.05
Alternativetwo-sided
Solve forMean difference
AssumptionsIndependent normal groups; common SD; equal sizes; pooled-test planning.
Planning SD4
  • Results and curve points are captured with this run. Sample sizes are whole numbers; target power and achieved power are distinct.

Scenario input values

Scenario matches the numbered result row. Inputs records the active scenario values; these are planning assumptions, not observed measurements. Single-value inputs produce one scenario here.

Scenario input values · 1 row
ScenarioInputs
1{"n":60,"power":0.9}

Captured power curve values

Each row gives a sample size, a mean difference or comparison proportion, and its calculated Power. These are all captured values behind the native chart. For two-group plans the size is per group. Read power between zero and one; 0.9 means 90%. The curve holds sample size at 60 per group. It reaches 90% near ±2.3868 g; smaller absolute differences have lower power.

Captured power curve values · 62 rows
Sample size per groupMean differencePower
60-2.983470.981774
60-2.884020.974815
60-2.784570.965754
60-2.685120.95417
60-2.585670.939628
60-2.486230.921701
60-2.386780.9
60-2.287330.874206
60-2.187880.844098
60-2.088430.809591
60-1.988980.770755
60-1.889530.727837
60-1.790080.681263
60-1.690630.631635
60-1.591180.579708
60-1.491740.52636
60-1.392290.472545
60-1.292840.419245
60-1.193390.367421
60-1.093940.31796
60-0.994490.271636
60-0.8950410.229083
60-0.7955920.190771
60-0.6961430.157012
60-0.5966940.127966
60-0.4972450.103667
60-0.3977960.0840557
60-0.2983470.0690135
60-0.1988980.0584013
60-0.0994490.0520925
6000.05
600.0994490.0520925
600.1988980.0584013
600.2983470.0690135
600.3977960.0840557
600.4972450.103667
600.5966940.127966
600.6961430.157012
600.7955920.190771
600.8950410.229083
600.994490.271636
601.093940.31796
601.193390.367421
601.292840.419245
601.392290.472545
601.491740.52636
601.591180.579708
601.690630.631635
601.790080.681263
601.889530.727837
601.988980.770755
602.088430.809591
602.187880.844098
602.287330.874206
602.386780.9
602.386780.9
602.486230.921701
602.585670.939628
602.685120.95417
602.784570.965754
602.884020.974815
602.983470.981774
  • All captured curves are included in this table and its CSV export; the plot shows at most 12 selected sample sizes.

6. Create a report

Keep Power and sample size scenarios, Planning method, Scenario input values, the native Power versus effect chart and its complete captured-values table. Record the difference worth detecting, planning spread or proportions, sample allocation and method. This is a pooled t-test plan with equal sizes, independent normal groups and common SD. “Detectable” refers to the chosen 90% power, not a hard boundary below which a test can never detect a difference.

Choose Add to report from the completed run. Open Choose individual items and advanced options to select tables and charts, then choose Add to draft. Hidden items stay in the saved analysis.

Name the report and add the purpose of the study and your interpretation. Choose Save, review Preview, then use Export → Download HTML. The example below contains the full selected content, including results beyond one screen.

Complete native output for this Help example, including applicable tables, charts and run notes. Report numbers use the app’s displayed precision. Exported charts are static. On narrow screens, scroll wide charts and tables sideways.
View example report: Find the detectable difference with 60 per group

We use Microsoft Clarity to understand how visitors use this website, including session recordings and heatmaps. You can use the website without accepting analytics.

Your choice is saved in this browser for six months. Privacy notice

Current choice: Not chosen.