Subtotal

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

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

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

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

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

"Shane Devenshire" wrote:

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

Not true. AVERAGE and VAR are unbiased sample estimators of the population
mean and variance, regardless of the distribution. VARP and STDEVP are only
unbiased with a complete population enumeration, which necessitates a
discrete finite (and hence non-normal) population.

Where you would need normality is to assume a Student's t distribution for
(AVERAGE-mu)/(STDEV/SQRT(n))

Jerry