Manuals/calci/HISTOGRAM

Revision as of 19:35, 24 February 2015 by Swapna (talk | contribs) (→‎Examples)

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.

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.

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:


Histogram
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.

See Also

References