The values 0 to 9.999 are in the first range the values 10 to 19.999 are in the second range and the values 90 to 99.9999 plus the value 100 are in the last range. We can see this better when we ask Datawrapper to show us the histogram for Berries:īerries contains 101 values. To not create a new range just for this one value, 100 counts as part of the 90 to 100 range. This is true for all values except the highest value, 100. But the value 90 counts as part of the last range the one between 90 and 100. We can see that most of the values in this column fall between 80 and 90.Īttention: The values 80 and 89.99999 counts as part of this range between 80 and 90. That's the histogram of our random data (Apples): The higher the bar, the more values fall in that bin. Here's how it works: A histogram automatically creates equally-sized bins between our lowest and highest values and tells us how many values fall within each bin. This is great for understanding which values occur more or less often: Which salaries are most common, which survey replies were chosen the least, or which range of unemployment rates most counties have to deal with. The histogram is a chart that tells us how the values in the selected column are distributed. The column 'Apples' is filled with random data between 0 and 100. The column 'Lemons' is filled with numbers from 0 to 95 and with five '5000's. The column 'Berries' is filled with numbers from 0 to 100. Unlike the mean, the median isn't affected by outlier values.

Median: The number that would be in the middle of an ordered list of your values.

The sum of all the values in your column, divided them by the total number of values.

Min and max: Shows you the lowest (minimum) and highest (maximum) values in your column.

The higher the bar, the more values fall in that range. Value distribution or histogram: Shows how the values in your column are distributed.Scroll down to get more in-depth explanations with examples.

Here's a quick explanation of what all of those words mean. If you are in step 2: Describe, you can click on the header of any column with numbers to display a histogram of values, including their minimum, maximum, median, mean, and the number of potentially invalid values. How to read a histogram, min, max, median & meanĭatawrapper offers powerful tools to understand your numeric data.

Excel histogram set lower range