Subtotal

  • Thread starter Thread starter Hardeep_kanwar
  • Start date Start date
H

Hardeep_kanwar

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
 
Thanks for Quick reply

What is STDEV,STDEVP,VAR,VARP


Sheeloo said:
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 said:
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
Click to expand...
Click to expand...
 
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 said:
Thanks for Quick reply

What is STDEV,STDEVP,VAR,VARP


Sheeloo said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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 said:
Thanks for Quick reply

What is STDEV,STDEVP,VAR,VARP


Sheeloo said:
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

:

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
Click to expand...
Click to expand...
Click to expand...
 
Shane Devenshire said:
These statistics are only valid if you can fairly assume that the
distribution of data is "normal" or bell shaped.
Click to expand...

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
 
Back
Top