Standard Deviation - Statistics - Excel

Measures how widely values are dispersed from the mean average.

Standard Deviation for a sample - Excel

=STDEV(range)

The above function ignores text and logical values (False/True),
The below function includes logical values and text. Text and logical value False = 0, True = 1.


=STDEVA(range) 


Standard Deviation for an entire population - Excel


=STDEVP(range)


The above function ignores text and logical values (False/True),
The below function includes logical values and text. Text and logical value False = 0, True = 1.


=STDEVAP(range)