contador web Saltar al contenido

How to calculate standard deviation in Excel | Productivity

In Excel, standard deviation can be done in a few clicks, simply and quickly. For this, the user must use the function Shameless and select the desired data table. The calculation is a statistical data that measures the degree of dispersion of the values ??relative to the average value of the numbers.

In the following tutorial, learn how to calculate standard deviation in Excel. The procedure was performed on the latest version of Office 2016, but the tips also apply to users of previous editions of the Microsoft program.

10 Advanced Excel Tips and Tricks You Need to Know

How to create charts in Microsoft Excel

How to create charts in Microsoft Excel

Want to buy a cell phone, TV and other discounted products? Meet the Compare TechTudo

Step 1. Click on the cell in which you want to calculate the standard deviation and type "= STRIKE" (without quotes). Then double click on the function;

Enter the function and click on it Photo: Reproduction / Helito BeggioraEnter the function and click on it Photo: Reproduction / Helito Beggiora

Enter the function and click on it Photo: Reproduction / Helito Beggiora

Step 2. Now select the table with the numbers for the standard deviation calculation;

Select numbers for calculation Photo: Reproduction / Helito BeggioraSelect numbers for calculation Photo: Reproduction / Helito Beggiora

Select numbers for calculation Photo: Reproduction / Helito Beggiora

Step 3. Finally, press Enter. The standard deviation will be calculated automatically and the result will be displayed in the cell.

Calculating standard deviation Photo: Reproduction / Helito BeggioraCalculating standard deviation Photo: Reproduction / Helito Beggiora

Calculating standard deviation Photo: Reproduction / Helito Beggiora

Ready. Take advantage of the tips to calculate standard deviation quickly using Excel.

Rate this post