Response Distribution Calculator

Turn raw answers into clean distributions fast. See totals, percentages, confidence ranges, and comparisons instantly. Download tables, share insights, and validate your survey results.

Calculator

Paste responses or enter category counts. Results appear above after submit.

Raw: one value per line, comma, or semicolon.
Choose how the distribution table is ordered.
Keep the top N rows, group the rest.
Used when Top N is enabled.
Wilson score interval for each proportion.
Creates a binned distribution (histogram table).
If unchecked, non-numeric becomes a category.
Provide expected probabilities or counts.
Count must match displayed categories (after Top N).
Reset

Example data

You can paste raw answers or enter counts like the sample below.

Category Count
Strongly agree42
Agree58
Neutral19
Disagree12
Strongly disagree9
No answer3
Example expected probabilities for the same six rows: 0.45, 0.30, 0.15, 0.06, 0.03, 0.01

Formula used

Frequency and percentage
For each response group i:
  • countᵢ is the number of occurrences.
  • pᵢ = countᵢ / n is the relative frequency.
  • %ᵢ = 100 × pᵢ is the percentage.
  • Cumulative values add counts in table order.
Wilson confidence interval
For a group with x successes out of n, and z-score z:
center = (p̂ + z²/(2n)) / (1 + z²/n)
radius = (z/(1+z²/n)) × √(p̂(1-p̂)/n + z²/(4n²))
The interval is [center − radius, center + radius], clipped to 0–1.
Chi-square goodness-of-fit (optional)
If you provide expected values, the statistic is:
χ² = Σ ( (Oᵢ − Eᵢ)² / Eᵢ )
with degrees of freedom df = k − 1. The p-value is the upper-tail probability.

How to use

  1. Choose an input mode: raw responses or category counts.
  2. Set cleanup options like trimming and case grouping.
  3. Optional: enable Top N to group long tails.
  4. Optional: enable numeric binning for number-only inputs.
  5. Optional: add expected values for chi-square comparison.
  6. Press Submit to display the distribution above.
  7. Use the download buttons to export your table.

Distribution tables for surveys and logs

This calculator turns raw answers or category totals into a frequency distribution. Each row includes count, proportion p_i = count_i / n, percent, and cumulative percent. Use trimming, case grouping, and blank removal to standardize messy exports from forms, chats, or incident notes. When Top N is enabled, remaining categories are consolidated into an Other row while totals stay unchanged. This is useful when you have dozens of labels.

Reading percentages, cumulative share, and concentration

Percent values describe how common each response is in the sample. Cumulative percent helps you see how quickly the table reaches 50 percent, 80 percent, or 95 percent of all responses. The summary also reports Shannon entropy in bits and Gini impurity. Higher entropy means a broader mix, while lower entropy signals strong convergence on one choice. Track these metrics monthly to compare stability across releases.

Confidence ranges for response proportions

Every percent is an estimate that changes with sample size. The calculator uses the Wilson score interval, which behaves well for small n and for proportions near 0 or 1. Select 90, 95, or 99 percent confidence and the tool derives a z value. It returns lower and upper bounds, clipped to valid percentage limits. Overlapping intervals suggest differences may be inconclusive.

Goodness of fit against expected patterns

When you enter expected values, the calculator runs a chi square goodness of fit test. Expected inputs may be probabilities that sum to one, or counts that are normalized to n. The statistic is computed as sum over i of ( O_i minus E_i ) squared divided by E_i, with degrees of freedom k minus 1. A small p value indicates a meaningful deviation. Ensure expected counts are not extremely small for reliable results.

Numeric binning and export ready reporting

For numeric responses, the tool can bin values into ranges using Sturges, square root, or Freedman Diaconis rules, or your custom bin count and limits. The summary reports how many numeric entries were used, plus mean and median. Set custom minimum and maximum bounds to control outliers. Export as CSV for spreadsheets, or as PDF for reports, audits, and dashboards.

FAQs

What input formats can I paste?

Paste values separated by new lines, commas, tabs, or semicolons. You can also switch to category counts and enter labels with integers. Cleanup options let you trim spaces, ignore blanks, and group by case.

How does Top N grouping affect totals?

Top N keeps only the largest N categories in the table. All remaining categories are summed into the Other label you choose. The overall n stays the same, so percentages and cumulative totals remain consistent.

What does the confidence interval mean here?

For each category, the interval estimates where the true population proportion may lie at your chosen confidence level. Wider intervals usually indicate smaller samples or rarer categories. It is a range, not a guarantee for any single run.

When should I enable numeric binning?

Enable it when responses are numbers like scores, times, or measurements. The tool will create ranges and count how many values fall into each bin. Use custom limits to control outliers or to match reporting standards.

How do expected values work in the chi square test?

Enter one expected number per displayed category, in the same order as the result table. You may provide probabilities that sum near one or counts. The calculator normalizes them to match n, then reports chi square, df, and p value.

Why is the PDF export minimal?

The PDF is generated without external libraries, so it focuses on readable text and a compact table. For branded layouts, export CSV and style it in your reporting tool, then print to PDF with your preferred template.

Related Calculators

Confidence Interval SurveyNet Promoter ScoreSurvey Participation RateSurvey Mean ScoreSurvey Median ScoreCross Tabulation ToolSurvey Standard DeviationSurvey Chi SquareSurvey Regression ToolResponse Kurtosis

Important Note: All the Calculators listed in this site are for educational purpose only and we do not guarentee the accuracy of results. Please do consult with other sources as well.