StatFas emblem: a philosopher beside a rising bar chart StatFas.comAn Easy Way to Do Statistics

Funnel Chart Maker for Attrition and Participant Flow

Use this tool to see how many participants, samples or variants remain at each stage of a pipeline, for example screening to analysis in a trial, variant filtering, or a diagnostic cascade. Upload your data below (CSV or Excel, or paste it) with a stage column and a count column, then press the button to generate the chart.

About the funnel chart

A funnel chart shows how a count shrinks stage by stage, from the first stage to the last. In research it is used for participant flow and attrition (enrolled, randomised, completed, analysed), for bioinformatics filtering steps, and for diagnostic cascades. The width of each bar is proportional to the count remaining, and the percentage retained from the previous stage is shown between bars.

When to use it

Use it when you have counts that can only stay the same or fall from one stage to the next and you want to know where most participants or records are lost, whether any stage loses more than expected, and whether two groups or trial arms differ in how they are retained.

What this tool reports

Assumptions to check

How to report it in APA7

Report the starting and final counts with the overall percentage retained and its confidence interval, name the stages where retention was lower than expected, and give the test statistics with adjusted p values. The tool writes this paragraph for you and lays out the tables in APA 7 style.

Frequently asked questions

Is the Funnel Chart Maker free?

Yes. You can run the analysis and read the results without an account. Create a free account or log in only when you want to download the results.

What data do I need?

A stage column in funnel order, a count column with the number remaining at each stage, and optionally a group column such as treatment arm with one row per stage per group.

What is a bottleneck stage?

A stage where retention is significantly lower than the typical retention across all stages, based on exact binomial tests with Holm correction.

Is my data uploaded to a server?

The analysis runs in your browser. Your data stays on your device while you use the tool.

Related tools