NxHistogram - Frequency Distribution (Histogram)

Calculates the histogram or cumulative histogram function for a given bin.

Syntax

NxHistogram(X, k, index, Ret_type)

X

is the input data series (one/two-dimensional array of cells (e.g., rows or columns)).

k

is the input number of bins for the histogram.

index

is the bin index or order; e.g., 1 = 1st bin (default), 2 = 2nd bin, ..., N.

Ret_type

is a switch to select the return output (0 = histogram, 1 = cumulative histogram (default)).

Order	Description
0	Histogram.
1	Cumulative histogram (default).

Remarks

1. The input data series may include missing values (e.g., #N/A, #VALUE!, #NUM!, empty cell), but they will not be included in the calculations.

Files Examples

Related Links

• Wikipedia - Empirical distribution function.

References

• Balakrishnan, N., Exponential Distribution: Theory, Methods and Applications, CRC, P 18 1996.