Last night I was given a problem to write an algorithm to calculate standard deviation in excel. Can you please tell what it is as I have no idea about it? Reply ASAP.
As we all know that excel has functions to calculate both the population standard deviation and the sample standard deviation. The population standard deviation is used for indicating whole population and uses following equation for its calculation:
where xis the average or statistical mean of the given set of values and nis the total number of values.
If the data set used is a sample of given population and not an entire population use a little modified onecalledsample standard deviation. Required equation for this is
