Difference between revisions of "Manuals/calci/HISTOGRAM"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''HISTOGRAM'''(Array, BinRange, NewTableFlag) where, '''Array '''- Input range should be one block. '''B...") |
(No difference)
|
Revision as of 02:36, 25 October 2013
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 |