Difference between revisions of "Manuals/calci/HISTOGRAM"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
− | =HISTOGRAM( | + | =HISTOGRAM(SomeArray,BinRange,SomePareToFlag,SomeCumulativeFlag,SomeChartFlag,NewTableFlag)= |
− | *where, <math> | + | *where, <math>SomeArray</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>SomePareToFlag</math> | ||
+ | *<math>SomeCumulativeFlag</math> | ||
+ | *<math>SomeChartFlag</math> | ||
*<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. | ||
Line 9: | Line 12: | ||
== Description == | == Description == | ||
− | HISTOGRAM( | + | HISTOGRAM(SomeArray,BinRange,SomePareToFlag,SomeCumulativeFlag,SomeChartFlag,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). |
Revision as of 15:41, 18 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 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.
Need to check the functionality of NewTableFlag.
*Currently, for TRUE, result table in Calci shows (both on new zspace)
**Bin, Frequency columns and
**two more columns showing Bin and Frequency in descending order
*For FALSE, Calci displays only Bin and Frequency columns.
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 |