Skip to main content
7B BusyBoss

Statistics Calculator: Mean, Median, Mode, SD, Quartiles

Mean, median, mode, sample and population standard deviation, variance, quartiles by four named methods, IQR, outliers and a step-by-step panel for your data.

No limitsZero data leaksSuper fast

Split the sorted list at the median, leave the median out when n is odd, and take the median of each half.

Count (n)

9

Sum

207

Mean

23

Median

22

Mode

22

Range

23

Min

12

Max

35

Q1 (25%)

16.5

Q3 (75%)

29

IQR (Q3 − Q1)

12.5

Sum of squares (SS)

434

Sample (divides by n − 1)

Variance (s²)

54.25

Std dev (s)

7.3655

Population (divides by n)

Variance (σ²)

48.2222

Std dev (σ)

6.9442

Outliers (1.5 × IQR rule)

Lower fence (Q1 − 1.5 × IQR)

-2.25

Upper fence (Q3 + 1.5 × IQR)

47.75

Outside the fences

none

ValueFrequencyRelativeMode
22222.2%mode
12111.1%
15111.1%
18111.1%
25111.1%
28111.1%
30111.1%
35111.1%

Sample variance and standard deviation divide by n − 1. Population figures divide by n. Quartiles use the method you pick above, so Q1, Q3, IQR and the outlier fences all match that convention.

Don't take our word for it — turn your wi-fi off.

This tool keeps working with no connection at all, because your file is processed here in the browser. A site that uploads your file cannot do that. Disconnect and try it — this box will notice.

Prefer to check properly? Open DevTools → Network, then run the tool. Your file appears in no request. Why none of our tools upload

You're on 7BusyBoss — 300+ free tools that run instantly in your browser. No signup, nothing uploaded.

Browse all Math Calculators →
About this tool

A statistics calculator takes a list of numbers and returns the descriptive statistics: the mean (sum ÷ n), the median (middle value once sorted), the mode (most frequent value), variance and standard deviation, quartiles, the interquartile range and any outliers. Paste your numbers above and every figure is computed on your data. Standard deviation is shown both ways, sample (divides by n − 1) and population (divides by n), and the Show steps button prints the arithmetic.

Mean, median and mode on one dataset

Take the nine values the calculator loads by default: 12, 15, 18, 22, 22, 25, 28, 30, 35.

  • Mean: the sum is 207, so 207 ÷ 9 = 23.
  • Median: n = 9 is odd, so the median is the 5th sorted value, 22. With an even count you average the two middle values.
  • Mode: 22 appears twice and every other value once, so the mode is 22. The frequency table under the results lists 22 with a count of 2 and a relative frequency of 22.2%, and marks it as the mode.

The mean and median sit close here (23 and 22) because nothing in the data is extreme. Add one extreme value and they separate fast. Six salaries of 40,000, 42,000, 45,000, 48,000, 50,000 and 250,000 have a mean of 79,166.67 and a median of 46,500. The mean sits above five of the six people. When a few values are far from the rest, report the median. When you need a figure that multiplies back to a total, use the mean.

Sample vs population standard deviation

Both start from the same sum of squared deviations from the mean, written SS. The sample version divides by n − 1, the population version by n.

SamplePopulation
Variances² = SS ÷ (n − 1)σ² = SS ÷ n
Standard deviations = √s²σ = √σ²
Use whenYour numbers are a sample and you want the spread of the larger group they came fromYour numbers are the whole group: every student in the class, every order this month
ExcelSTDEV.S, VAR.SSTDEV.P, VAR.P
Default datasets² = 54.25, s = 7.3655σ² = 48.2222, σ = 6.9442

Here is the sample calculation on the default data, which is what the steps panel prints. The mean is 23. The deviations are −11, −8, −5, −1, −1, 2, 5, 7 and 12. Squared, they are 121, 64, 25, 1, 1, 4, 25, 49 and 144, which add up to SS = 434. Then 434 ÷ 8 = 54.25 and √54.25 = 7.3655. For the population figures, 434 ÷ 9 = 48.2222 and its square root is 6.9442.

The gap between the two shrinks as n grows. The sample SD is √(n ÷ (n − 1)) times the population SD: 1.118 times at n = 5, 1.0607 at n = 9, 1.0171 at n = 30 and 1.005 at n = 100. Below about 30 values the choice changes the second significant figure, so say which one you used.

Quartiles by four methods, and which software uses each

Quartiles have no single definition. Every package agrees on the median and then splits on how to find Q1 and Q3, which is why a TI-84 and Excel disagree on the same homework problem. This calculator offers four methods and names the one in use next to the result, so you can match whatever your course or spreadsheet expects.

MethodWhere you meet itQ1Q3IQR
Median of halves (median excluded when n is odd)TI-83/84, most school textbooks, Moore and McCabe16.52912.5
Tukey hinges (median kept in both halves)Tukey's box plots, some older texts182810
Inclusive interpolationExcel QUARTILE.INC and QUARTILE, Google Sheets, NumPy and pandas defaults, R type 7182810
Exclusive interpolationExcel QUARTILE.EXC, Minitab, SPSS, R type 616.52912.5

Figures are for the default dataset 12, 15, 18, 22, 22, 25, 28, 30, 35. On the halves method the lower half is 12, 15, 18, 22 with median 16.5 and the upper half is 25, 28, 30, 35 with median 29. The inclusive method puts Q1 at position (9 − 1) × 0.25 = 2 counted from the first value, starting at 0, which lands on 18 exactly. The exclusive method uses (9 + 1) × 0.25 = 2.5, halfway between the second and third values, 15 and 18, so 16.5.

For even counts the two halves methods agree with each other and the two interpolation methods still differ. On the values 1 to 8, Excel's QUARTILE.INC gives 2.75 and 6.25, QUARTILE.EXC gives 2.25 and 6.75, and a TI-84 gives 2.5 and 6.5. All three are right under their own definition. Pick the method your course or your spreadsheet uses, and name it when you report the figure.

IQR and outliers by the 1.5 × IQR rule

The interquartile range is Q3 − Q1, the spread of the middle half of the data. Multiply it by 1.5, subtract from Q1 for the lower fence and add to Q3 for the upper fence. Anything outside the fences is flagged as an outlier.

Ten delivery times in minutes: 18, 20, 21, 22, 23, 24, 25, 27, 29, 58. The mean is 26.7 and the median 23.5, which is already a hint. With the halves method Q1 = 21 and Q3 = 27, so IQR = 6, the lower fence is 21 − 9 = 12 and the upper fence is 27 + 9 = 36. The 58-minute delivery is above 36 and gets flagged. Switch to the inclusive method and the fences move to 13.375 and 34.375, and 58 is still out. That one value also inflates the spread: the sample standard deviation is 11.4703 with it and 3.4561 without it.

Fences depend on the quartile method, so a borderline value can be an outlier under one method and inside the fence under another. On the default dataset the halves fences are −2.25 and 47.75 and nothing is flagged under any of the four methods.

How to use this statistics calculator

  1. Paste the numbers into the box. Commas, spaces, tabs or one value per line all work, so a column copied from Excel or Google Sheets pastes straight in. Anything that is not a number is skipped.
  2. Pick a quartile method. The default is median of halves, the TI-84 convention. The note under the menu says what the method does.
  3. Read the grid: count, sum, mean, median, mode, range, min, max, Q1, Q3, IQR and the sum of squares.
  4. Sample and population variance and standard deviation sit side by side below the grid.
  5. The outlier panel shows both fences and the values outside them. The frequency table lists each distinct value with its count and share, with the mode marked.
  6. Press Show steps for the sum, the mean, the sorted list with the median position, a table of deviations and squared deviations, SS, both variances, both standard deviations, and the quartile and fence arithmetic.

Results show up to four decimal places with trailing zeros trimmed. The standard deviation of a series of returns is what the Sharpe ratio calculator divides by, and the spread you measure here decides how many observations a comparison needs, which the A/B test sample size calculator works out.

Common mistakes and limits

  • Comparing a sample SD with a population SD from another source. Excel's STDEV defaults to the sample version, and a textbook population example divides by n. Match the formula before you call either one wrong.
  • Reporting quartiles without the method. Two correct Q1 values for the same nine numbers differ by 1.5 in the table above (16.5 against 18).
  • Reading "none" for the mode as an error. It means no value repeats, which is normal for measured data such as weights or times. Round the data first if you want a modal class.
  • Trusting a standard deviation on skewed data. It describes symmetric, single-peaked data well. For income or response times, quote the median and the IQR.
  • Pasting numbers with thousands separators. "1,250" splits on the comma into 1 and 250. Remove the separators first.
  • With a single value the sample variance shows 0, and the halves and exclusive quartiles show n/a, since they need at least two and three values.

Percentage differences between two of these figures, such as how far the mean sits above the median, are a job for the percentage calculator.

How to use the Statistics Calculator

Takes about a minute. No signup, no download, your data stays in your browser.

  1. 1
    Open the tool. Scroll up to the Statistics Calculator above — it loads instantly in your browser, no install needed.
  2. 2
    Enter your values. The fields come pre-filled with realistic defaults so you can see how it works — replace them with your own numbers.
  3. 3
    Read the result. The output updates instantly. Copy or share it — nothing is uploaded to a server, everything stays on your device.

Frequently asked questions

Common questions about the Statistics Calculator.

How do you calculate mean, median and mode?

Mean: add the values and divide by how many there are, so 12, 15, 18, 22, 22, 25, 28, 30, 35 gives 207 ÷ 9 = 23. Median: sort the list and take the middle value, 22 here. With an even count, average the two middle values. Mode: the value that appears most often, 22, which appears twice. If nothing repeats there is no mode.

What is the difference between sample and population standard deviation?

Both measure spread around the mean from the same sum of squared deviations. Sample SD divides by n − 1 and estimates the spread of a larger group from a subset. Population SD divides by n and describes a complete group. On the default data they are 7.3655 and 6.9442. The gap shrinks with n: at 100 values the sample figure is 1.005 times the population figure.

Why does my standard deviation differ from Excel's?

Excel has two functions. STDEV.S (and the old STDEV) divide by n − 1, while STDEV.P divides by n. The same split applies to VAR.S and VAR.P. Check which one the sheet used, then compare against the matching card here. A difference in the fourth decimal is rounding, since this calculator shows four decimals with trailing zeros trimmed.

How do you find quartiles, and why does Excel disagree with my TI-84?

They use different definitions. A TI-84 splits the sorted data at the median, leaves the median out when n is odd, and takes the median of each half. Excel's QUARTILE.INC interpolates at position (n − 1) × 0.25. On the values 1 to 8 that gives Q1 = 2.5 on the calculator and 2.75 in Excel. Pick the matching method in the menu and the figures agree.

How do you find outliers using the IQR?

Compute IQR = Q3 − Q1, then the fences Q1 − 1.5 × IQR and Q3 + 1.5 × IQR. Values outside the fences are outliers. For delivery times 18, 20, 21, 22, 23, 24, 25, 27, 29, 58, Q1 = 21 and Q3 = 27 on the halves method, so the fences are 12 and 36 and 58 is flagged. The calculator lists the flagged values and both fences.

What is the difference between variance and standard deviation?

Variance is the average squared deviation from the mean, so its unit is squared: minutes squared, dollars squared. Standard deviation is its square root, back in the original unit, which is why it is the one people quote. On the default data the sample variance is 54.25 and the sample SD is √54.25 = 7.3655.

What does it mean when the mode is "none"?

Every value appears exactly once. That is common for measured data such as heights or timings, where exact repeats are rare. The frequency table still shows each value with a count of 1. If you need a typical value anyway, use the median, or round the data into classes and look for the most frequent class.

Can I paste data straight from Excel or a CSV?

Yes. Copy a column or a row and paste it in. The calculator splits on commas, spaces, tabs and line breaks and ignores anything that is not a number, including a header cell. Numbers with thousands separators such as 1,250 are the one trap, since the comma splits them into 1 and 250. Remove the separators first.

Community rating

Discussion (0)

No comments yet. Start the discussion.