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
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)
You may also find the following Math calculators useful.