STANDARD DEVIATION - Descriptive Statistics using Microsoft Excel Statistical Functions - Measure of Dispersion

The practice sheet can be downloaded from Link. Statistics Marks Data - Download Sheet

About the Data Sheet - The data in this sheet is related to marks scored by 100 Students in a Statistical Test. 

Based on the data, we will use Microsoft Excel Statistical functions to analyse the descriptive statistics. 

In the Data Sheet, we have Data from A2:A101, A1 being the header of the Data. 

STANDARD DEVIATION

Standard Deviation is measure of the dispersion of a set of data from its mean. The more spread apart the data, the higher the deviation. Standard deviation is calculated as the square root of variance.

Standard deviation is calculated based on a sample. The standard deviation is a measure of how widely values are dispersed from the average value (the mean).

= STDEV(number1,number2,...)

STDEV uses the following formula:

where x is the sample mean AVERAGE(number1,number2,…) and n is the sample size.

Or

=SQRT(Variance)

In the Data Sheet, we have Data from A2:A101, A1 being the header of the Data. 

=STDEV(A2:A101)

Result is 14.24
Or
=SQRT(Variance) or =SQRT(202.7777)

STDEV.P is for population

STDEV.S is for Sample

The practice sheet can be downloaded from Link. Statistics Marks Data - Download Sheet