How to use Standard Deviation Calculator
- Paste one numeric list into Numbers to measure. Use decimal points and no thousands separators.
- Choose How the numbers are separated, or keep Detect from the text. Fix any unreadable entry named in the error.
- Choose Population or sample and Decimal places. The selected convention controls the headline; both spread figures appear in the summary table.
- Leave Add the deviation table on to inspect the working for up to 50 values. Turn it off for the summary alone.
Example: Standard Deviation Calculator
Population standard deviation of 2, 4, 4, 4, 5, 5, 7 and 9.
Options
- Population or sample
- Population (divide by n) treats the list as the whole set. Sample (divide by n - 1) treats it as part of a larger set and needs two values.
- Add the deviation table
- Lists each value with its deviation from the mean and the squared deviation, for up to 50 values. Longer lists return the summary alone.
- How the numbers are separated
- Detect from the text takes the separator that appears most often; when none is found, spaces separate values.
Supported inputs and limits
- Up to 10,000 numbers and 200,000 characters, with up to 80 significant digits per number and a decimal exponent from -999 to 999.
- Use decimal points without thousands separators.
- In comma mode, 1,000 is two entries; other separator choices may reject it.
- Population mode accepts one value; sample mode requires at least two.
- The selected convention drives the headline, while the summary includes both population and sample figures where defined.
More details
Deviation working is available for at most 50 values.
Arithmetic uses 80 significant digits before display rounding.
This describes the entered list; it is not a confidence interval, hypothesis test or guarantee about a wider population.
Where your input is processed
This tool does not upload your inputs. See the limits for anything saved on your device.
Variance and standard deviation use different units
Squaring each distance from the mean is why variance comes out in squared units, so values in kilograms give a variance in kilograms squared. The standard deviation is its square root and returns to the input unit, which is why it is read beside the mean. The table prints the sum of squared deviations so the arithmetic can be followed.
Why the sample formula divides by n - 1
The mean is estimated from the same sample as the spread. The sample-variance convention sums squared deviations from that sample mean and divides by n - 1 rather than n. Taking its square root gives the displayed sample standard deviation. Choose this when the list is a sample of the population you want to describe; the calculation still cannot establish whether your sample is representative.
Questions about Standard Deviation Calculator
Should I choose population or sample?
Population when the list is the whole set, sample when it is part of a larger set. The only difference is the denominator, n or n - 1.
Why is the sample standard deviation larger?
For 2, 4, 4, 4, 5, 5, 7 and 9 the population figures are variance 4 and standard deviation 2. Sample mode divides by 7, giving variance 4.571429 and standard deviation 2.13809.
Why is variance in different units from the input?
Each deviation is squared before averaging, so variance is in squared units. The standard deviation is its square root and returns to the input unit.
Can the standard deviation be zero?
Yes, when every value is identical. Every deviation is then zero, so the variance and the standard deviation are zero too.