From ZCubes Wiki
Revision as of 18:40, 7 January 2014 by Swapna (talk | contribs)
Jump to navigation Jump to search

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


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
=HISTOGRAM(A3:A9, B3:B7, TRUE) returns the following table:

Bin Frequency
10 2
20 3
30 0
40 1
50 1
More 0

See Also