EDF - Empirical Distribution Function

Calculates the empirical distribution function, or empirical CDF, of the sample data.

Syntax

X

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

target

is the target value to compute the underlying CDF for.

Ret_type

is a switch to select the return output (1 = CDF (default), 2 = Inverse CDF).

Order	Description
1	Cumulative EDF (default).
2	Inverse Cumulative EDF.

Remarks

1. For the inverse cumulative EDF calculation, the target value must be between 0 and 1 (exclusive).
2. 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.