Plan a one-proportion study

Choose a sample size for comparing a proportion with a baseline.

Guides · Basic statistics · 4 min read

Example: a pass-rate increase from 93% to 97%

Plan independent pass/fail observations to distinguish a 97% pass rate from a fixed 93% baseline. 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 One proportion for Test and Sample size 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 0.93 in Baseline proportion (p₀).

Enter 0.97 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 independent pass/fail observations to distinguish a 97% pass rate from a fixed 93% baseline. The difference of interest is four percentage points.

  2. Read the calculated plan

    Plan 323 independent trials to distinguish a 97% pass rate from a fixed 93% baseline, at 90% target power. This normal-approximation plan gives power 0.900198; 322 trials give 0.899049. The count is trials, not passes, and the method is not exact-binomial planning.

  3. Follow the power curve

    The curve holds sample size at 323 and varies the comparison proportion. At 0.97 it reaches about 90%. Power is lowest near the 0.93 baseline; it also rises for lower rates because the test is two-sided.

    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 method uses a normal approximation with null-based thresholds and variance at the comparison proportion. It is not an exact-binomial calculation.

  5. Decide how to collect the sample

    Check whether 93% is the appropriate fixed baseline and 97% is the effect worth detecting. Use independent observations and the same pass/fail definition in the planned study.

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 needs 323 observations. Achieved power is 0.900198; with 322, it is 0.899049, below the 90% target. These are planned observations, not a required number of passes.

Power and sample size scenarios · 1 row
ScenarioBranchSample sizeTotal observationsComparison proportionTarget powerAchieved powerPower at preceding sizeDFStatusDetails
1—3233230.970.90.9001980.899049—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 method uses a normal approximation with null-based thresholds and variance at the comparison proportion. It is not an exact-binomial calculation.

Planning method · 7 rows
SettingValue
MethodOne proportion
Calibrationstatswift-normal-proportion-v1
Alpha0.05
Alternativetwo-sided
Solve forSample size
AssumptionsNormal approximation using null thresholds and alternative variance.
Baseline proportion0.93
  • 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.97,"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 323 and varies the comparison proportion. At 0.97 it reaches about 90%. Power is lowest near the 0.93 baseline; it also rises for lower rates because the test is two-sided.

Captured power curve values · 63 rows
Sample sizeComparison proportionPower
3230.830.999723
3230.8328330.999581
3230.8356670.999371
3230.83850.999064
3230.8413330.998618
3230.8441670.997976
3230.8470.997062
3230.8498330.995772
3230.8526670.99397
3230.85550.99148
3230.8583330.988076
3230.8611660.983476
3230.8640.977331
3230.8668330.969223
3230.8696660.958664
3230.87250.945095
3230.8753330.927904
3230.8781660.906446
3230.8810.880082
3230.8838330.848222
3230.8866660.810394
3230.88950.766313
3230.8923330.715957
3230.8951660.659647
3230.8980.5981
3230.9008330.532462
3230.9036660.464294
3230.90650.395512
3230.9093330.328268
3230.9121660.264785
3230.9149990.207161
3230.9178330.15718
3230.9206660.116146
3230.9234990.0848113
3230.9263330.0633843
3230.9291660.0516607
3230.930.05
3230.9319990.0492336
3230.9348330.0557509
3230.9376660.0711539
3230.9404990.0958347
3230.9433330.130658
3230.9461660.176818
3230.9489990.23552
3230.9518330.307503
3230.9546660.392459
3230.9574990.488419
3230.9603330.591299
3230.9631660.694833
3230.9659990.791202
3230.9688330.872531
3230.970.900198
3230.9716660.933083
3230.9744990.971346
3230.9773320.99075
3230.9801660.998009
3230.9829990.999767
3230.9858320.99999
3230.9886661
3230.9914991
3230.9943321
3230.9971661
3230.9999991
  • 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 method uses a normal approximation with null-based thresholds and variance at the comparison proportion. It is not an exact-binomial calculation.

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 one-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.