Advanced Statistics Calculator

Enter a range of values in the "Data Input" box, separated by commas or spaces (5000 maximum).

Alternatively paste a range of numbers into the box.

Note - if text (non-numeric data) is entered then the Total Value, Mean, Median, Quartiles and Percentile are ignored.

The following charts are created, depending on the data entered:

A column chart showing the count of values in the range.

A pie chart showing the top ten values (any values outside the top ten are grouped together as "Others").

A line chart will be created if all the values are numeric,

This chart will show all details, but you have the option to show or hide each series by ticking the relevant boxes.

There are 3 example buttons, these add data to demonstrate how the results are displayed:

Example 1 is integer (whole number) values, Example 2 is text and example 3 contains decimal numbers.

Advanced Statistics Calculator

Total number of values in range The total number of values in the range entered
Total value of numbers The total sum of all the values, if all are numeric
Mean (Average) The Mean is the average of a range of numbers. Calculated by dividing the sum of the values by the number of values
Median (Middle Value) The Median is the middle number in a sorted list of numbers. It is also known as the second percentile (Q2)
Mode - Most frequent value(s)
1st Quartile (25%) The first quartile (Q1) is the middle number between the smallest number and the median in a sorted list of numbers (also known as the lower quartile)
3rd Quartile (75%) The third quartile (Q3) is the middle number between the median and the highest number in a sorted list of numbers (also known as the upper quartile)
Percentile (1 to 100) A percentile indicates the value in a sorted list at a certain percentage of the range. e.g. the 25th percentile is the value at 25% of the range

[ No Votes ]

This calculator includes the following algorithms

The Mean (or Average) is calculated by adding all the values together, then dividing this by the number of values

The Median is calculated by sorting the values in order then selecting the value in the middle of the list

The Mode is the most frequent value in the range (there can be more than one value)

Math Calculators

You may also find the following Math calculators useful.