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

References

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

Comments

Article is closed for comments.

Was this article helpful?
0 out of 0 found this helpful