Dispersion

• Variance
• Standard deviation
• Demo

Variance

Sample ($s^2 = \frac{\sum_{i=1}^n (x_i - \bar{x})^2}{n-1}$):

=VAR.S(data)

Population ($\sigma^2 = \frac{\sum_{i=1}^n (x_i - \mu)^2}{N}$):

=VAR.P(data)

Standard deviation

Sample ($s$):

=STDEV.S(data)

Population ($\sigma$):

=STDEV.P(data)

Demo