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
- 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.
Examples
Example 1:
|
|
Formula | Description (Result) |
---|---|
=NxHistogram ($B$2:$B$29,5,1,0) | Histogram (0.214) |
=NxHistogram ($B$2:$B$29,5,1,1) | Cumulative Histogram (0.214) |
Files Examples
Related Links
References
- Balakrishnan, N., Exponential Distribution: Theory, Methods and Applications, CRC, P 18 1996.
Comments
Article is closed for comments.