GroupW(column,width)

Top  Previous  Next

Allocates data in column into groups width wide.  This function is useful where you wish to force the statistics tool to group data into predetermined divisions.

 

0  -  14.5                1

14.5  -  29                3

29  -  43.5                26

43.5  -  58                58

58  -  72.5                71                Generated by GroupW(A,14.5)

72.5  -  87                35

87  -  101.5                5

101.5  -  116                1

 

Note:  If you type decimals using a comma (eg 3,2) you should enter this formula as GroupW(A; 14,5) - using the ; as a separator