Formula for calculating Standard deviation

Formula for calculating Standard deviation

For Example if we wish to know the how fuel-efficient a new purchased is. We need to calculate how many kilometres have travelled per litre on our first seven trips. This information is presented Kilometers/liter below. To find the standard deviation we can us the formula as =STDEVP(VALUES).

Kilometers/liter
22
21
22
21
21
23
21

 

From stated example above we give command as =STDEV(A2:A8) and result is 0.79

Data source http://libweb.surrey.ac.uk