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
