Difference between revisions of "Manuals/calci/HISTOGRAM"
Jump to navigation
Jump to search
| Line 73: | Line 73: | ||
|} | |} | ||
| − | =HISTOGRAM(A3:A9, B3:B7, TRUE) returns the following table: | + | =HISTOGRAM(A3:A9, B3:B7, TRUE) |
| + | returns the following table: | ||
<div id="5SpaceContent" class="zcontent" align="left"> | <div id="5SpaceContent" class="zcontent" align="left"> | ||
| Line 92: | Line 93: | ||
| 20 | | 20 | ||
| 3 | | 3 | ||
| − | | | + | | 42.857142857142854% |
|- class="even" | |- class="even" | ||
| 20 | | 20 | ||
| Line 99: | Line 100: | ||
| 10 | | 10 | ||
| 2 | | 2 | ||
| − | | | + | | 71.42857142847143% |
|- class="odd" | |- class="odd" | ||
| 30 | | 30 | ||
| 0 | | 0 | ||
| 71.42857142847143% | | 71.42857142847143% | ||
| − | | | + | | 40 |
| − | | | + | | 1 |
| − | | | + | | 85.71428571428571% |
| − | |||
|- class="even" | |- class="even" | ||
| 40 | | 40 | ||
| Line 113: | Line 113: | ||
| 85.71428571428571% | | 85.71428571428571% | ||
|- class="odd" | |- class="odd" | ||
| + | | 50 | ||
| + | | 1 | ||
| + | | 100% | ||
| 50 | | 50 | ||
| 1 | | 1 | ||
| 100% | | 100% | ||
|- class="odd" | |- class="odd" | ||
| + | | More | ||
| + | | 0 | ||
| + | | 100% | ||
| More | | More | ||
| 0 | | 0 | ||
| 100% | | 100% | ||
|} | |} | ||
| + | The Histogram chart is also displayed. | ||
== See Also == | == See Also == | ||
Revision as of 18:34, 24 February 2015
HISTOGRAM(SomeArray,BinRange,SomePareToFlag,SomeCumulativeFlag,SomeChartFlag,NewTableFlag)
- where, is an array of data or reference to cells containing data to analyze
- is the set of intervals to create an Histogram
- is a logical value that decides whether to make a Pareto chart, a special histogram that sorts the columns from tallest to smallest
- is a logical value that decides whether to display cumulative percentages in addition to bin totals
- 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.
is an array of data or reference to cells containing data to analyze
is the set of intervals to create an Histogram
is a logical value that decides whether to make a Pareto chart, a special histogram that sorts the columns from tallest to smallest
is a logical value that decides whether to display cumulative percentages in addition to bin totals
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.
Description
HISTOGRAM(SomeArray,BinRange,SomePareToFlag,SomeCumulativeFlag,SomeChartFlag,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.
- 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.
- can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE.
- If is TRUE, the result is displayed on new zspace sheet.
can be array of numbers to analyze using HISTOGRAM() function.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)
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% |
| More | 0 | 100% | More | 0 | 100% |
The Histogram chart is also displayed.