Difference between revisions of "Manuals/calci/HISTOGRAM"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
=HISTOGRAM(Array, BinRange, NewTableFlag)= | =HISTOGRAM(Array, BinRange, NewTableFlag)= | ||
| − | *where, <math>Array<math> is an array of data or reference to cells containing data to analyze | + | *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>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. | ||
| Line 17: | Line 17: | ||
*<math>NewTableFlag</math> can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE. | *<math>NewTableFlag</math> can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE. | ||
*If <math>NewTableFlag</math> is TRUE, the result is displayed on new zspace sheet. | *If <math>NewTableFlag</math> is TRUE, the result is displayed on new zspace sheet. | ||
| − | <font=blue>Need to check the functionality of NewTableFlag</font> | + | |
| + | <font color="blue">Need to check the functionality of NewTableFlag</font> | ||
== Examples == | == Examples == | ||
| − | Consider the following table with Columns A and B as array inputs for | + | Consider the following table in Calci, with Columns A and B as array inputs for HISTOGRAM() function. |
<div id="2SpaceContent" class="zcontent" align="left"> | <div id="2SpaceContent" class="zcontent" align="left"> | ||
Revision as of 18:45, 7 January 2014
HISTOGRAM(Array, BinRange, 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 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 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.
- 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.
Need to check the functionality of NewTableFlag
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 |
|---|---|
| 10 | 2 |
| 20 | 3 |
| 30 | 0 |
| 40 | 1 |
| 50 | 1 |
| More | 0 |