How to calculate standard deviation in excel without formula

This page explains how to calculate the standard deviation based on the entire population using the STDEV.P function in Excel and how to estimate the standard deviation based on a sample using the STDEV.S function in Excel.

What is Standard Deviation?

Standard deviation is a number that tells you how far numbers are from their mean.

1.

Standard deviation in excel graph

For example, the numbers below have a mean (average) of 10.

Explanation: the numbers are all the same which means there's no variation. As a result, the numbers have a standard deviation of zero. The STDEV function is an old function.

Microsoft Excel recommends using the new STDEV.S function which produces the exact same result.

2.

How to calculate 2 standard deviations in excel

How to calculate standard deviation in excel from mean

How to calculate standard error in excel

Relative standard deviation excel

How to calculate variance in excel

The numbers below also have a mean (average) of 10.

Explanation: the numbers are close to the mean. As a result, the numbers have a low standard deviation.

3. The numbers below also have a mean (average) of 10.

Explanation: the numbers are spread out.

As a result, the numbers have a high standard deviation.

STDEV.P

The STDEV.P function (the P stands for Population) in Excel

how to calculate 1 std deviation in excel

how to calculate stdev on excel