Do you need **calculate the standard deviation** de un conjunto de datos? Con nuestra calculadora puedes obtener la desviación estándar con sólo escribir cada cifra, separadas por un espacio o por una coma. Si vas a introducir números decimales, usa el punto '.' como separador decimal.

When you have typed in all the numbers, click the calculate button and you will automatically get the **deviation value** as well as other statistical measures such as variance or mean.

Article sections

## What is standard deviation

The standard deviation is a measure of dispersion that is a measure of** shows the deviation of the distribution data compared to its arithmetic mean.**.

This **helps us to have a more realistic view of the data.** to interpret them correctly, something that positively benefits decision making.

The standard deviation is widely used to see how far the data deviate from the mean of the distribution.

The standard deviation can also be defined as the square root of the variance.

## Standard deviation formula

For** calculate the standard deviation** the following mathematical formula must be applied:

## How to calculate the standard deviation step by step

If you do not fully understand how to apply the **standard deviation formula**In this section you will find a step-by-step explanation of how to calculate it. You only have to follow the next steps:

- Calculate the arithmetic mean of the numbers in the set
- Subtract the average obtained from each number and square the result.
- Obtain the average of the previous results
- Take the square root of the resulting number

For the sake of clarity, let's take a look at a **solved exercise on standard deviation**.

## Example of standard deviation

Let's calculate the standard deviation of the set of numbers [1, 3, 5, 7, 9].

To do this, we follow the steps seen in the previous point, so the first thing to do is to calculate its average value:

(1 + 3 + 5 + 7 + 9) / 5 = 25 / 5 = 5

Then we subtract the value of the previous average from each number in the set. Then we square it:

(1 - 5)

^{2}= 16(3 - 5)

^{2}= 4(5 - 5)

^{2}= 0(7 - 5)

^{2}= 4(9 - 5)

^{2}= 16

The next step is to find the average of the previous values:

(16 + 4 + 0 + 4 + 16) / 5 = 8

Finally, we take the square root of the obtained value:

√8 = 2,828

With this we are done.

## Standard deviation symbol

The standard deviation is usually represented by a **letter s or with the symbol σ**.

## Calculate standard deviation in Excel

To calculate the standard deviation in Excel there is a function that does the operation automatically.

To do this, just open the Microsoft spreadsheet program and write each number of the set in a separate cell. For example, let's imagine that we have a set consisting of 10 values that occupies the cell range A1:A10.

To calculate the standard deviation in Excel we write the following formula:

=DESVEST.P(A1:A5)

Logically, you will have to adapt the range of cells of the formula to your spreadsheet to cover the cells in which you have written the data of the set.

It is important to note that the above formula is used to calculate the population standard deviation. If you want to calculate the sample standard deviation, then you must write this other formula:

=DESVESTS(A1:A5)

## Sample standard deviation

The sample standard deviation is used when it is assumed that** the aggregate data are only a sample of the total population.**.

In this case, the mathematical formula we use is this:

Ingeniero de Telecomunicaciones dedicado al mundo de Internet. En esta web te ayudo a hacer cálculos y conversiones sencillas que con el paso de los años se nos ha olvidado cómo se hace. Si tienes dudas, déjame un comentario y te ayudaré. Si quieres mejorar tu proyecto online o necesitas asesoramiento, write me a message.