How to calculate standard deviation in Excel?
In statistics, standard deviation is usually used for measuring the dispersion from the average. But in fact, to calculate standard deviation is a little complex, you need to get the average first, and then calculate the difference of each data point from the mean, and square the result of each and so on. The equation of standard deviation in Math or Statistics is shown as following:
Now I will tell you a formula in Excel to quickly get the standard deviation of a data range.
In Excel, it has a standard deviation can help you get the result at once.
Please select a blank cell and type this formula =STDEV(A1:A6) into it, then press Enter key on the key board, now you get the standard deviation of the data range from A1 to A6.
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!