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
References
- Balakrishnan, N., Exponential Distribution: Theory, Methods and Applications, CRC, P 18 1996.
0 Comments