×

# Amongst which of the following is / are related to Standard Deviation Function?

9. Amongst which of the following is / are related to Standard Deviation Function?

1. Standard Deviation is one of the ways to quantify dispersion
2. It is a measure of how widely values are dispersed from the average value
3. STDEV.P function which is used to calculate standard deviation based on the entire population given as arguments
4. All of the mentioned above

Answer: D) All of the mentioned above

Explanation:

If you use a sample of the population (STDEV) or a biassed sample of the population (STDEV), then the statistical standard deviation of all values in the set will be returned by the standard deviation function (STDEVP). The standard deviation is useful for measuring variance within a data set and, in the context of statistical results, for assessing confidence in those results. To quantify dispersion, one of the methods used is to calculate the standard deviation. In other words, it is a measure of how widely values are dispersed from the mean value.