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

where, Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array} is an array of data or reference to cells containing data to analyze
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle BinRange} is the set of intervals to create an Histogram
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle PareToFlag} is a logical value that decides whether to make a Pareto chart, a special histogram that sorts the columns from tallest to smallest
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle CumulativeFlag} is a logical value that decides whether to display cumulative percentages in addition to bin totals
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle SomeChart} is a logical value that decides whether to display the chart
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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.

Description

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.
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Array} can be array of numbers to analyze using HISTOGRAM() function.
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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.
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NewTableFlag} can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE.
If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NewTableFlag} is TRUE, the result is displayed on new zspace sheet.

Examples

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

Array	Bin Range

1	10
7	20
12	30
17	40
20	50
37
50

=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%