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
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 Beggiora
Step 2. Now select the table with the numbers for the standard deviation calculation;
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 Beggiora
Ready. Take advantage of the tips to calculate standard deviation quickly using Excel.