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 - this calculator is for numeric values only, non-numeric values will be excluded and placed in a separate box.

Advanced Statistics Calculator with text and number calculations.

The following charts are created:

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 with 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 decimal values and example 3 contains a non-numeric value

Statistics Calculator

Data Input (click examples to see required format)

Statistics

Measurement	Value	Comments
Number of values (count)		The total number of values in the range entered
Total value of numbers(sum)		The total sum of all the values
Mean (Average)		The Mean is the average of a range of numbers.
Median (Middle Value)		The Median is the middle number in a sorted list of numbers. It is also known as the second percentile (Q2)
Minimum		The smallest value in the range
Maximum		The largest value in the range
Variance		The sum of the squared differences between each value and the mean divided by the number of items
Standard Deviation		Standard Deviation is calculated as the square root of the varience
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

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)