How to calculate standard deviation by using microsoft excel

Learn why people trust wikiHow. Download Article Explore this Article Steps. Tips and Warnings. Related Articles. This wikiHow teaches you how to find the standard deviation of a set of data in Microsoft Excel. Open Microsoft Excel. Click or double-click the Microsoft Excel app icon, which resembles a white "X" on a dark-green background.

The Excel launch page will open. If you have an Excel document which contains the data you want to use, double-click the document to open it in Excel, then skip ahead to the "Click a blank cell" step.

Click Blank Workbook. It's in the upper-left side of the Excel launch page. Enter the values you want to use. Pick a column in which you want to enter your data, then type each data value into individual cells in that column. For example, if you select column "A" as the area in which to enter your data, you might type a number into cell A1 , cell A2 , cell A3 , and so on.

Click a blank cell. This should be the cell in which you want to display the standard deviation value. Doing so selects the cell.

Type in the standard deviation formula. P where "P" stands for "Population". Population standard deviation takes into account all of your data points N. S here. Sample standard deviation takes into account one less value than the number of data points you have N Add your value range. The selection of standard deviation formula for a particular task is based on the logical or text values present in the datasets.

The below-mentioned table will help you out. It is very simple and easy to use. Where the sum value is calculated with the help of the sum formula, i. And Mean Average is calculated with the help of the Average formula, i. Here we are calculating Standard deviation only for the sample of the data set, which is taken out from a large population; therefore, we need to select either of them, i.

S for a sample from the Statistical category. S in excel. A dialog box appears where arguments for the Standard deviation function need to be filled or entered, i.

S number1, [number2], …. So that column range will get selected, i. A standard deviation value of 1. Here, the standard deviation is close to zero; therefore, it indicates lower data variability and a more reliable mean or average value.

Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen. Incorrect instructions. Too technical. Not enough information. Not enough pictures. Any additional feedback? Submit feedback. Thank you for your feedback! Description Result.