Plan a two-proportion study

Choose equal group sizes for a planned comparison of two proportions.

Guides · Basic statistics · 4 min read

Example: pass rates of 98% versus 94%

Plan two independent, equally sized pass/fail groups with assumed pass rates of 98% and 94%. The difference of interest is four percentage points.

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 proportions for Test and Sample size for Solve for. Enter 0.05 in Significance level (α) and choose Two-sided for Alternative hypothesis. This planning method does not apply a continuity correction; retain that distinction when comparing it with the proportions-test example.

3. Enter the planning values

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

Enter 0.94 in Baseline proportion (p₂).

Enter 0.98 in Comparison proportions (p₁).

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 two independent, equally sized pass/fail groups with assumed pass rates of 98% and 94%. The difference of interest is four percentage points.

  2. Read the calculated plan

    The plan requires 503 observations per group: 1,006 total. Achieved power is 0.900411; at 502 per group it is 0.899843, below 90%.

  3. Follow the power curve

    The curve holds sample size at 503 per group and the baseline at 0.94. At a comparison proportion of 0.98, power is about 90%; nearer the baseline it is lower.

    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-normal approximation with equal group sizes and no continuity correction. The matching Proportions analysis must leave Apply continuity correction unchecked; its corrected default uses a different convention.

  5. Decide how to collect the sample

    Confirm the four-percentage-point difference, pass/fail definition and equal allocation before sampling. Recalculate for changed proportions or choose a method that supports the required allocation.

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 records a solved effect direction; a dash means it is not applicable. 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 plan requires 503 observations per group: 1,006 total. Achieved power is 0.900411; at 502 per group it is 0.899843, below 90%.

Power and sample size scenarios · 1 row
ScenarioBranchSample size per groupTotal observationsComparison proportionTarget powerAchieved powerPower at preceding sizeDFStatusDetails
1—50310060.980.90.9004110.899843—ok—
  • 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-normal approximation with equal group sizes and no continuity correction. The matching Proportions analysis must leave Apply continuity correction unchecked; its corrected default uses a different convention.

Planning method · 7 rows
SettingValue
MethodTwo proportions
Calibrationstatswift-normal-two-proportions-v1
Alpha0.05
Alternativetwo-sided
Solve forSample size per group
AssumptionsIndependent equal-sized groups; pooled null threshold; no continuity correction.
Baseline proportion0.94
  • 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{"p1":0.98,"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 503 per group and the baseline at 0.94. At a comparison proportion of 0.98, power is about 90%; nearer the baseline it is lower.

Captured power curve values · 63 rows
Sample size per groupComparison proportionPower
5030.840.999181
5030.8426670.998806
5030.8453330.998275
5030.8480.997532
5030.8506670.9965
5030.8533330.995083
5030.8560.993159
5030.8586670.990573
5030.8613330.987137
5030.8640.982622
5030.8666670.97676
5030.8693330.969237
5030.8720.959703
5030.8746660.947769
5030.8773330.933024
5030.880.915047
5030.8826660.89343
5030.8853330.8678
5030.8880.837853
5030.8906660.803388
5030.8933330.764337
5030.8960.720801
5030.8986660.673074
5030.9013330.621658
5030.9040.567263
5030.9066660.510793
5030.9093330.453317
5030.9120.396013
5030.9146660.340111
5030.9173330.286816
5030.9199990.237244
5030.9226660.192356
5030.9253330.152916
5030.9279990.119473
5030.9306660.0923783
5030.9333330.0718321
5030.9359990.0579579
5030.9386660.0508992
5030.940.05
5030.9413330.0509164
5030.9439990.0584678
5030.9466660.0742489
5030.9493330.0991662
5030.9519990.134227
5030.9546660.180333
5030.9573330.237995
5030.9599990.307004
5030.9626660.386115
5030.9653330.472866
5030.9679990.56359
5030.9706660.653726
5030.9733320.738399
5030.9759990.813197
5030.9786660.874937
5030.980.900411
5030.9813320.922212
5030.9839990.955511
5030.9866660.976877
5030.9893320.989225
5030.9919990.995569
5030.9946660.998421
5030.9973320.999523
5030.9999990.999881
  • 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-normal approximation with equal group sizes and no continuity correction. The matching Proportions analysis must leave Apply continuity correction unchecked; its corrected default uses a different convention.

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: Plan a two-proportion study

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.