1.Previous
3.Next

of each groups.

AVG:

or

or, only if COUNT(X)=COUNT(Y)

SUM(x2):The sum of squares of the values is important in order to calculate the Standard Deviation of groups

STDDEV:
For a finite population with equal probabilities at all points, we have

This means that the standard deviation is equal to the square root of the difference between the average of the squares of the values and the square

1.Previous
3.Next