Hi,

These statistics are only valid if you can fairly assume that the
distribution of data is "normal" or bell shaped.

The formula for STDDEV and STEDEVP differ by the numerator inside of the
square root, in one case you divide by n, in the other case by n-1.

Variance is used in some cases because it is undimentioned or unitless and
many statisticians perfer that.

You might also ask what PRODUCT is - it is the product of all the numbers.
=5*2*123*.... for example.

These same 11 functions are available in the PivotTable and Subtotal and
with D-Functions.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Sheeloo" wrote:

STDEV is standard deviation - a measure of how widely values are dispersed
from the average value (the mean). This is calculated assuming data is a
sample. STDEVP assumes that data consists of the entire population.

VAR/VARP are variance (square of STDEV/STEDEVP)

Look under Statistical Functions for details and examples.


"Hardeep_kanwar" wrote:

Thanks for Quick reply

What is STDEV,STDEVP,VAR,VARP


"Sheeloo" wrote:

1 gives you average, 2 count,.... and so on. See list below;
[lokup examples in HELP]
Value Explanation
1 AVERAGE
2 COUNT
3 COUNTA
4 MAX
5 MIN
6 PRODUCT
7 STDEV
8 STDEVP
9 SUM
10 VAR
11 VARP

"Hardeep_kanwar" wrote:

What is the use of the numbers in Subtotal function

i.e 1,2,3,4,5,6,7,8,9

=Subtotal(1,a2:a45)
=Subtotal(2,a2:a45)
=Subtotal(3,a2:a45)
=Subtotal(4,a2:a45)
=Subtotal(5,a2:a45)
=Subtotal(6,a2:a45)
=Subtotal(7,a2:a45)
=Subtotal(8,a2:a45)
=Subtotal(9,a2:a45)

It Give me different Result

Thanks in Advance