Quick summary
The STDEV.S formula in Microsoft Excel lets you calculate standard deviation for a sample dataset in seconds. Select your target cell, enter the formula, highlight your data range, and press Enter to get an instant result.
Steps
- Click the cell where you want the standard deviation result to appear.
- Type =STDEV( and select STDEV.S from the suggested formula list for a sample standard deviation.
- Click cell B2 to start your data range selection, then drag down to the last cell of your dataset.
- Press Enter to display the calculated standard deviation in the selected cell.
