Standard Deviation Calculator

A standard deviation calculator helps you find how spread out your numbers are from the average. You can use the tool above to calculate this value instantly. Just paste your numbers into the box, choose if your data is a population or a sample, and click calculate to get your result.

Your Data

Results update as you type

n = 8

Results

Live

Sample Standard Deviation

s = 5.2372

s² = 27.4286 · x̄ = 18.0000 · n = 8

Count (n)
8
Mean
18.0000
Sum (Σx)
144.0000
Sum of squares
192.0000
Variance
27.4286
Std. error
1.8516
Margin of error (95%)
± 4.3784
Coeff. of variation
29.10%
Both methods side by side
−1sx̄+1s1023

Data distribution with the matching normal curve and standard deviation bands

Spread Around the Mean
x̄ ± 1s = [12.763, 23.237]6 of 8 (75.0% vs 68.27% expected)
x̄ ± 2s = [7.526, 28.474]8 of 8 (100.0% vs 95.45% expected)
x̄ ± 3s = [2.288, 33.712]8 of 8 (100.0% vs 99.73% expected)
95% CI for the mean
[13.6216, 22.3784]
18.0000 ± 4.3784
95% CI for s
[3.4627, 10.6592]
variance: [11.9904, 113.6183]
Margin of error for the mean at common confidence levels
ConfidenceCritical valueMargin of error
90%1.895± 3.5081
95%2.365± 4.3784
99%3.499± 6.4798
99.9%5.408± 10.0135
Across 8 values averaging 18.0000, a typical value sits about 5.2372 away from the mean. That is 29.1% of the mean, so the spread is moderate relative to the average.
William Davis

Created by William Davis

Last updated: August 14, 2026

Add to Google Preferred

What is Standard Deviation?

Standard deviation is a number that tells you how far individual data points usually sit from the average of the group. If the number is low, it means the data points are clustered closely around the average. If the number is high, the data points are spread out over a wider range.

Population vs. Sample Standard Deviation

There are two different ways to calculate this number. You must choose the right one based on where your data came from.

When to Use Population Standard Deviation

You use the population formula when you have collected data from every single member of the group you want to study. For example, if you measure the heights of every single student in a small classroom, you have population data.

When to Use Sample Standard Deviation

You use the sample formula when you only have a small part of a larger group. This is the most common type in real-world scenarios. For example, if you survey 100 people to guess the opinion of an entire country, you have a sample.

Standard Deviation Formula

The formula changes slightly depending on whether you are using population or sample data. Both formulas follow similar basic steps.

Population Formula

For a population, you take each number, subtract the mean, and square the result. Then, you add all those squared numbers together and divide by the total number of items in your group. Finally, you take the square root of that answer.

Sample Formula

The sample formula is almost exactly the same. The only difference is that you divide by the total number of items minus one. Subtracting one from the sample size makes the final result more accurate for the larger population you are trying to represent.

How to Calculate Standard Deviation Step-by-Step

If you want to do the math by hand, follow these simple steps.

  1. Find the mean, or average, of your data set.
  2. Subtract the mean from each individual number in your set.
  3. Square each of those differences. Squaring means multiplying the number by itself.
  4. Add all of the squared numbers together.
  5. Divide that total by the number of values in your set. If it is a sample, divide by the number of values minus one. This gives you the variance.
  6. Take the square root of the variance to get the standard deviation.

Worked example

A help desk counts weekly tickets for five weeks: 12, 15, 18, 14, and 21. Treat this as a sample from a longer year.

  1. Mean = (12 + 15 + 18 + 14 + 21) / 5 = 80 / 5 = 16
  2. Deviations from 16: −4, −1, 2, −2, 5
  3. Squared deviations: 16, 1, 4, 4, 25. Sum = 50
  4. Sample variance = 50 / (5 − 1) = 12.5
  5. Sample standard deviation = √12.5 ≈ 3.54

If those five weeks were the entire population, divide by 5 instead of 4. Population standard deviation = √10 ≈ 3.16. Paste 12, 15, 18, 14, 21 into the tool above and switch between sample and population to see both results.

Standard Deviation vs. Variance

Variance is the average of the squared differences from the mean. Standard deviation is simply the square root of the variance. People use standard deviation much more often because the result is in the same units as your original data. For instance, if your data is measured in meters, the variance will be in square meters, but the standard deviation will stay in meters.

What is a Good Standard Deviation?

There is no single "good" number. It depends entirely on what you are measuring. A standard deviation of 2 might be very low for a person's height in inches, but it would be incredibly high for a person's shoe size. To see how a specific data point compares to the average using your new standard deviation result, you can convert it into a z-score using our z-score calculator.

Frequently Asked Questions

How do I calculate standard deviation in Excel?

You can calculate it in Excel by using the formulas =STDEV.S() for a sample or =STDEV.P() for a population. You just highlight your data cells inside the parentheses.

What does a standard deviation of 1 mean?

A standard deviation of 1 means that, on average, most of your data points fall about 1 unit away from the mean. In a perfect normal distribution, about 68% of all data points will fall within one standard deviation of the average.

Can standard deviation be negative?

No, standard deviation can never be negative. Because the formula requires you to square the differences before averaging them, all the numbers become positive. Taking the square root of a positive number always gives a positive result.

What is the difference between standard deviation and standard error?

Standard deviation measures how spread out your data points are from the average. Standard error measures how accurate your sample mean is compared to the true population mean. Standard error is always smaller than standard deviation.

Is a higher standard deviation better?

It is not a matter of being better or worse. A higher number simply means your data is more spread out. If you are manufacturing machine parts, a high standard deviation is bad because it means the parts are not identical. If you are measuring human personality traits, a high standard deviation is normal and expected.