-
Excel Tutorial
- Excel HOME
- Excel Introduction
- Excel Get Started
- Excel Overview
- Excel Syntax
- Excel Ranges
- Excel Fill
- Excel Move Cells
- Excel Add Cells
- Excel Delete Cells
- Excel Undo Redo
- Excel Formulas
- Excel Relative Reference
- Excel Absolute Reference
- Excel Arithmetic Operators
- Excel Parentheses
- Excel Functions
Excel Formatting
- Excel Formatting
- Excel Format Painter
- Excel Format Colors
- Excel Format Fonts
- Excel Format Borders
- Excel Format Numbers
- Excel Format Grids
- Excel Format Settings
Excel Data Analysis
- Excel Sort
- Excel Filter
- Excel Tables
- Excel Conditional Format
- Excel Highlight Cell Rules
- Excel Top Bottom Rules
- Excel Data Bars
- Excel Color Scales
- Excel Icon Sets
- Excel Manage Rules (CF)
- Excel Charts
Table Pivot
Excel Case
Excel Functions
- AND
- AVERAGE
- AVERAGEIF
- AVERAGEIFS
- CONCAT
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUNTIFS
- IF
- IFS
- LEFT
- LOWER
- MAX
- MEDIAN
- MIN
- MODE
- NPV
- OR
- RAND
- RIGHT
- STDEV.P
- STDEV.S
- SUM
- SUMIF
- SUMIFS
- TRIM
- VLOOKUP
- XOR
Excel How To
Guided Projects
- Introduction to Excel
- Learn Data Calculations
- Learn Data Visualization
- Learn to Create a Budget
- Learn to Create a Timeline
- Learn to Style in Excel
Excel Examples
Excel References
Excel STDEV.S Function
The STDEV.S function is a premade function in Excel, which calculates the Standard Deviation (Std) for a sample
STDEV.S Function
The STDEV.S function is a premade function in Excel, which calculates the Standard Deviation (Std) for a sample.
It is typed =STDEV.S
Note: This function ignores cells with text and logic.
Note: Standard deviation (σ) measures how far a 'typical' observation is from the average of the data (μ). You can read more about standard deviation in our Statistics - Standard Deviation Tutorial.
Tip: There is another function called STDEV.P that can be used if you have the data for the entire population.
How to use the =STDEV.S function:
H5)=STDEV.SE2:E21)Let's have a look at an example!
Find the Standard Deviation for the sample of Pokemon total stats in the range E2:E21:
113,2319 for the sample of Pokemons Total stats.
function copyFormulas(elementId){ /* Get the text field */ var copyText = document.getElementById(elementId); /* Select the text field */ copyText.select(); copyText.setSelectionRange(0, 99999); /* For mobile devices */ /* Copy the text inside the text field */ navigator.clipboard.writeText(copyText.value) .then(() => { alert('Range copied to clipboard.\nIt can now be pasted into the Excel spreadsheet.') }) .catch((error) => { alert(`Copy failed! ${error}`) }) }