# Difference between revisions of "Manuals/calci/HISTOGRAM"

HISTOGRAM (Array,BinRange,PareToFlag,CumulativeFlag,ShowChart,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 (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.
• 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,TRUE,TRUE,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.

HISTOGRAM