Statistics

Data Distribution Visualizer

Paste numbers from a spreadsheet or type them in, and instantly see the shape of your data with a histogram, mean and standard deviation lines, a normal curve and a box plot.

WithinYour dataNormal (68-95-99.7)
BinCount%

Runs entirely in your browser. Nothing is uploaded to any server.

Why visualise your data

See the shape

Spot skew, multiple peaks and gaps that averages hide.

Find outliers

The box plot flags values beyond 1.5 × IQR.

Test normality

Compare your data with the 68-95-99.7 rule and a normal curve.

How to visualise a data distribution

  1. Paste your numbersCopy a column from a spreadsheet or type values separated by commas or spaces.
  2. Choose the binsUse a rule such as Sturges or set your own bin count.
  3. Read the chartCompare the histogram with the mean, σ lines, normal curve and box plot.

Reading the histogram and statistics

A histogram groups values into equal-width bins and shows how many fall in each one. The red line marks the mean, and the dashed lines mark one and two sample standard deviations either side of it. The orange curve is a normal distribution with the same mean and standard deviation, scaled to the histogram.

Quartiles use linear interpolation between sorted values, the same method as Excel's QUARTILE.INC. Skewness and excess kurtosis use the sample-adjusted formulas. Values near 0 for both suggest a roughly normal shape; positive skew means a longer right tail.

Sturges rule

k = ⌈log₂ n + 1⌉ bins, good for small, roughly normal data.

Freedman-Diaconis

Bin width 2 × IQR / ∛n, robust to outliers.

Box plot

Box from Q1 to Q3, red median, whiskers to the last non-outlier.

Data distribution FAQ

Which standard deviation should I use?

Use the sample standard deviation when your data is a sample from a larger group, and the population value when it is the entire group.

How are outliers defined?

Values below Q1 − 1.5 × IQR or above Q3 + 1.5 × IQR, which is Tukey's rule used in box plots.

What is the 68-95-99.7 rule?

For normally distributed data about 68% of values lie within one standard deviation of the mean, 95% within two and 99.7% within three.

Can I paste numbers with thousands separators?

No. Commas are treated as separators between numbers, so remove thousands separators first.

Is my data uploaded?

No. Everything is calculated in your browser.

Try other math and statistics tools

More free tools from My Panda Toolbox.