Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Subtotal
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Subtotal
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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Subtotal
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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Subtotal
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 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Subtotal
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I Subtotal, then Sort by Subtotal Amounts? | Excel Discussion (Misc queries) | |||
pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
Bolding the subtotal lines automaticlly When using the Subtotal fu | New Users to Excel | |||
copy subtotal value only, subtotal value can be vlookup by others | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |