HISTOGRAM(Array, BinRange, NewTableFlag)

where, $Array<math>isanarrayofdataorreferencetocellscontainingdatatoanalyze*<math>BinRange<math>isthesetofintervalstocreateanHistogram*<math>NewTableFlag<math>isalogicalvaluethatdecideswhethertodisplaytheoutputinthesameworksheetoranewspacecube.HISTOGRAM()countsthenumberofoccurrencesofeachdatapointineachofseveraldatabins.==Description==HISTOGRAM(Array,BinRange,NewTableFlag)*AnHistogramisarepresentationoftabulatedfrequenciesoverdiscretebins(intervals).*HISTOGRAM()performsdataanalysisinanarraydependingontheintervals,andreturnsacolumnchartthatdisplaysfrequencydata.*<math>Array$ can be array of numbers to analyze using HISTOGRAM() function.
$BinRange$ 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.
$NewTableFlag$ can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE.
If $NewTableFlag$ 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.

=HISTOGRAM(A3:A9, B3:B7, TRUE) returns the following table: