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
|