Skip to content
Insider Magazin

Analysis

Distributions

The summary table per category, box plots with Tukey whiskers, and the comparison of category distributions on shared bins.

What the Distributions section shows

The Distributions section describes the shape of the selected values, split by category. It has three parts: a summary table, box plots per category and a distribution comparison by category on shared bins. All three use the current selection; the category filter decides which categories appear.

Summary table

The summary table lists the following statistics. Exact formulas are given in Statistical Analysis.

StatisticDefinitionMinimum n
nNumber of observations0
MeanArithmetic mean x̄1
MedianType-7 quantile Q(0.5)1
SDSample standard deviation s (n − 1)2
VarianceSample variance s² (n − 1)2
Min / MaxSmallest and largest value1
Q1 / Q3Type-7 quantiles Q(0.25) and Q(0.75)1
IQRQ3 − Q11
Skewness (G₁)Adjusted Fisher–Pearson sample skewness3
Coefficient of variations / |x̄|2, and x̄ ≠ 0

Reading the table

  • Mean vs median. A mean clearly above the median points to a long right tail; below the median, to a long left tail.
  • SD vs IQR. SD reacts strongly to extreme values; IQR does not. For roughly normal data, IQR ≈ 1.35 × SD. A much larger SD than that suggests heavy tails or outliers.
  • Skewness. G₁ near 0 indicates a roughly symmetric distribution. Positive values indicate a longer right tail, negative values a longer left tail.
  • Coefficient of variation. Expresses spread relative to the mean, so categories with different levels can be compared. It is only meaningful for values on a ratio scale (a true zero), such as MWh, minutes or items.

Box plots per category

Each category is drawn as a horizontal box plot on a common value axis.

Box
From Q1 to Q3; it contains the middle 50% of the values.
Line inside the box
The median.
Whiskers (Tukey)
Extend to the most extreme observation that lies within 1.5 × IQR of the box: the lower whisker to the smallest value ≥ Q1 − 1.5 · IQR, the upper whisker to the largest value ≤ Q3 + 1.5 · IQR.
lower fence = Q1 − 1.5 · IQR, upper fence = Q3 + 1.5 · IQR

The tooltip shows the category, its number of observations n, the upper whisker, Q3, the median, Q1 and the lower whisker.

Values beyond the whiskers

Values outside the fences are not drawn as individual points. To see how far the extremes reach, compare the whiskers with Min and Max in the summary table, or sort the Data Explorer by value.

Distribution comparison by category

The comparison chart overlays the distribution of each category. All categories use the same bin edges, computed from the values of all selected categories with the bin rules described in Frequency Analysis. Bars show relative frequency (count in the bin ÷ number of observations in that category), so categories with different numbers of observations are comparable.

Shared bins matter: if each category were binned separately, differences in bin width and alignment could look like differences in shape. With identical bins, a difference in bar height in a given class is a difference in the share of observations in that class.

Examples with the illustrative datasets

The illustrative datasets were generated with known properties, which makes them useful to check how the statistics behave. Open /demo and select:

  • Support Response Times: values are log-normal, so each channel shows a mean above its median, a positive skewness and a box whose upper half is longer than its lower half. Chat has the lowest level and Email the highest.
  • Regional Electricity Demand: North has a higher level and a larger seasonal amplitude than South, which shows as a wider box and a larger SD.
  • Items per Order: discrete values with one bin per integer. The minimum is 1 by construction (1 + Poisson). Restricting the date range to November and December shifts the distribution upward because λ is raised by 0.9 in those months.

Interpretation

Differences between categories are descriptive. They describe the selected data and do not, on their own, establish a cause or indicate that the difference will persist.