Difference between revisions of "Manuals/calci/HISTOGRAM"
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | =HISTOGRAM( | + | <div style="font-size:25px">'''HISTOGRAM (Array,BinRange,PareToFlag,CumulativeFlag,ShowChart,NewTableFlag)'''</div><br/> |
| − | *where, <math> | + | *where, <math>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>BinRange</math> is the set of intervals to create an Histogram | ||
| − | *<math> | + | *<math>PareToFlag</math> is a logical value that decides whether to make a Pareto chart, a special histogram that sorts the columns from tallest to smallest |
| − | *<math> | + | *<math>CumulativeFlag</math> is a logical value that decides whether to display cumulative percentages in addition to bin totals |
| − | *<math> | + | *<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. | *<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 == | == Description == | ||
| − | HISTOGRAM( | + | HISTOGRAM (Array,BinRange,PareToFlag,CumulativeFlag,ShowChart,NewTableFlag) |
*An Histogram is a representation of tabulated frequencies over discrete bins(intervals). | *An Histogram is a representation of tabulated frequencies over discrete bins(intervals). | ||
Latest revision as of 16:09, 10 August 2018
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
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.
- 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.
- 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:
| 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.
Related Videos
See Also
References