HISTOGRAM(Array, BinRange, NewTableFlag)
- where, can be array of numbers to analyze using HISTOGRAM() function.
- is the range of intervals in which data in array is counted. A data is included in particular bin range if the number is greater than lowest range and equal to or less than largest range.
- can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE.
- If is TRUE, the result is displayed on new zspace sheet.
<font=blue>Need to check the functionality of NewTableFlag
Examples
Consider the following table with Columns A and B as array inputs for ANOVASINGLEFACTOR() function.
| Array | Bin Range | |
| 1 | 10 | |
| 7 | 20 | |
| 12 | 30 | |
| 17 | 40 | |
| 20 | 50 | |
| 37 | ||
| 50 |
=HISTOGRAM(A3:A9, B3:B7, TRUE) returns the following table:
| Bin | Frequency |
|---|---|
| 10 | 2 |
| 20 | 3 |
| 30 | 0 |
| 40 | 1 |
| 50 | 1 |
| More | 0 |