Revision as of 16:52, 24 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$ is a logical value that decides whether to make a Pareto chart, a special histogram that sorts the columns from tallest to smallest
$SomeCumulativeFlag$ is a logical value that decides whether to display cumulative percentages in addition to bin totals
$SomeChartFlag$ is a logical value that decides whether to display the chart
$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.

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:

Histogram
Bin	Frequency	Cumulative	Bin	Frequency	Cumulative
10	2	28.57142857142857%	20	3
20	3	71.42857142847143%	10	2
30	0	71.42857142847143%	10	2	28.57142857142857%
40	1	85.71428571428571%
50	1	100%
More	0	100%

@@ Line 20: / Line 20: @@
 *<math>NewTableFlag</math> can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE.
 *If <math>NewTableFlag</math> is TRUE, the result is displayed on new zspace sheet.
-<font color="blue">Need to check the functionality of NewTableFlag.</font>
-<font color="blue">*Currently, for TRUE, result table in Calci shows (both on new zspace)</font>
-<font color="blue">**Bin, Frequency columns and </font>
-<font color="blue">**two more columns showing Bin and Frequency in descending order</font>
-<font color="blue">*For FALSE, Calci displays only Bin and Frequency columns.</font>
 == Examples ==
@@ Line 92: / Line 82: @@
 ! Bin
 ! Frequency
+! Cumulative
+! Bin
+! Frequency
+! Cumulative
 |- class="odd"
 | 10
 | 2
+| 28.57142857142857%
+| 20
+| 3
+|
 |- class="even"
 | 20
 | 3
+| 71.42857142847143%
+| 10
+| 2
+|
 |- class="odd"
 | 30
 | 0
+| 71.42857142847143%
+| 10
+| 2
+| 28.57142857142857%
 |- class="even"
 | 40
 | 1
+| 85.71428571428571%
 |- class="odd"
 | 50
 | 1
+| 100%
 |- class="odd"
 | More
 | 0
+| 100%
 |}