Calculate the Standard Deviation in Excel

Your goal

You need to calculate the standard deviation of numerical data in Excel.

Step-by-step tutorial

Use the STDEV function for the sample standard deviation, or else STDEV.P for the population standard deviation. We'll use STDEV on the Central Park precipitation dataset here:

Calculating the standard deviation using STDEV

The result:

The result