HISTOGRAM(Array, BinRange, 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<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>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. == Description == HISTOGRAM(Array, BinRange, 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. *<math>Array}
can be array of numbers to analyze using HISTOGRAM() function.
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.
<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.
| Array
|
Bin Range
|
|
|
|
|
|
| 1
|
10
|
|
| 7
|
20
|
|
| 12
|
30
|
|
| 17
|
40
|
|
| 20
|
50
|
|
| 37
|
|
|
| 50
|
|
|
=HISTOGRAM(A3:A9, B3:B7, TRUE) returns the following table:
Histogram
| Bin
|
Frequency
|
| 10
|
2
|
| 20
|
3
|
| 30
|
0
|
| 40
|
1
|
| 50
|
1
|
| More
|
0
|
See Also
References