Manuals/calci/HISTOGRAM
Jump to navigation
Jump to search
HISTOGRAM(Array, BinRange, NewTableFlag)
where,
Array - Input range should be one block.
BinRange - Input range should be one block.
NewTableFlag - is the TRUE or FALSE.If set as TRUE,the result in new sheet. If NewTableFlag is omitted, it assumed to be FALSE.
Histogram counts occurences in each of several data bins.
Lets see an example in (Column3Row1)
=HISTOGRAM (R1C1:R6C1, R1C2:R6C2, TRUE)
HISTOGRAM returns the result in new sheet(5Space).
HISTOGRAM
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 1 | 3 | 5Space | 5 |
| Row2 | 7 | 8 | 9 | 128 |
| Row3 | 12 | 8 | 14 | 15 |
| Row4 | 17 | 18 | 10000 | 20 |
| Row5 | 37 | 34 | 10023 | 168 |
| Row6 | 6 | 5 | 1.619775 | 0.525322 |
| Bin | Frequency |
|---|---|
| 3 | 1 |
| 8 | 2 |
| 8 | 0 |
| 18 | 2 |
| 34 | 0 |
| 5 | 0 |
| More | 1 |