Difference between revisions of "Manuals/calci/HISTOGRAM"

Latest revision as of 17:09, 10 August 2018

HISTOGRAM (Array,BinRange,PareToFlag,CumulativeFlag,ShowChart,NewTableFlag)

where, $Array$ is an array of data or reference to cells containing data to analyze
$BinRange$ is the set of intervals to create an Histogram
$PareToFlag$ is a logical value that decides whether to make a Pareto chart, a special histogram that sorts the columns from tallest to smallest
$CumulativeFlag$ is a logical value that decides whether to display cumulative percentages in addition to bin totals
$SomeChart$ is a logical value that decides whether to display the chart
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.

HISTOGRAM (Array,BinRange,PareToFlag,CumulativeFlag,ShowChart,NewTableFlag)

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,TRUE,TRUE,TRUE)

returns the following table:

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

The Histogram chart is also displayed.

@@ Line 7: / Line 7: @@
 *<math>SomeChart</math> is a logical value that decides whether to display the chart
 *<math>NewTableFlag</math> 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.
-HISTOGRAM() counts the number of occurrences of each data point in each of several data bins.
 == Description ==