HISTOGRAM

Macro Sheets Only

Calculates individual and cumulative percentages for a range of data and a corresponding range of data bins.

If this function is not available, you must install the Analysis ToolPak add-in macro.

Syntax

HISTOGRAM(inprng, outrng, binrng, pareto, chartc, chart, labels)
HISTOGRAM?(inprng, outrng, binrng, pareto, chartc, chart, labels)

Inprng is the input range.

Outrng is the first cell (the upper-left cell) in the output table or the name, as text, of a new sheet to contain the output table. If FALSE, blank, or omitted, places the output table in a new workbook.

Binrng is an optional set of numbers that define the bin ranges. The values must be in ascending order. The values are interpreted as more than value A up to value B, more than value B up to value C, and so on. One additional bin is created for values for less than the minimum value specified in binrng.

Pareto is a logical value.

• If pareto is TRUE, data in the output table is presented in both ascending-bin order and descending-frequency order.
• If pareto is FALSE or omitted, data in the output table is presented in ascending-bin order only.

Chartc is a logical value. If chartc is TRUE, HISTOGRAM generates a cumulative percentages column in the output table. If both chartc and chart are TRUE, HISTOGRAM also includes a cumulative percentage line in the histogram chart. If omitted, chartc is FALSE.

Chart is a logical value. If chart is TRUE, HISTOGRAM generates a histogram chart in addition to the output table. If omitted, chart is FALSE.

Labels is a logical value.

• If labels is TRUE, then the first row or column of inprng contains labels.
• If labels is FALSE or omitted, all cells in inprng are considered data. Microsoft Excel generates appropriate data labels for the output table.

Related Function

List of Statistical Functions