Revision as of 14:41, 18 February 2015

HISTOGRAM(SomeArray,BinRange,SomePareToFlag,SomeCumulativeFlag,SomeChartFlag,NewTableFlag)

where, $SomeArray$ is an array of data or reference to cells containing data to analyze
$BinRange$ is the set of intervals to create an Histogram
$SomePareToFlag$
$SomeCumulativeFlag$
$SomeChartFlag$
$NewTableFlag$ is a logical value that decides whether to display the output in the same worksheet or a new space cube.

HISTOGRAM() counts the number of occurrences of each data point in each of several data bins.

An Histogram is a representation of tabulated frequencies over discrete bins(intervals).
HISTOGRAM() performs data analysis in an array depending on the intervals, and returns a column chart that displays frequency data.
$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.

Need to check the functionality of NewTableFlag.

*Currently, for TRUE, result table in Calci shows (both on new zspace)

**Bin, Frequency columns and

**two more columns showing Bin and Frequency in descending order

*For FALSE, Calci displays only Bin and Frequency columns.

Consider the following table in Calci, with Columns A and B as array inputs for HISTOGRAM() function.

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

@@ Line 1: / Line 1: @@
-=HISTOGRAM(Array, BinRange, NewTableFlag)=
+=HISTOGRAM(SomeArray,BinRange,SomePareToFlag,SomeCumulativeFlag,SomeChartFlag,NewTableFlag)=
-*where, <math>Array</math> is an array of data or reference to cells containing data to analyze
+*where, <math>SomeArray</math> is an array of data or reference to cells containing data to analyze
 *<math>BinRange</math> is the set of intervals to create an Histogram
+*<math>SomePareToFlag</math>
+*<math>SomeCumulativeFlag</math>
+*<math>SomeChartFlag</math>
 *<math>NewTableFlag</math> is a logical value that decides whether to display the output in the same worksheet or a new space cube.
@@ Line 9: / Line 12: @@
 == Description ==
-HISTOGRAM(Array, BinRange, NewTableFlag)
+HISTOGRAM(SomeArray,BinRange,SomePareToFlag,SomeCumulativeFlag,SomeChartFlag,NewTableFlag)
 *An Histogram is a representation of tabulated frequencies over discrete bins(intervals).