Returns the sample relative mean difference.
Syntax
RMD(X)
- X
- is the input data sample (one/two dimensional array of cells (e.g. rows or columns))
Remarks
- The time series may include missing values (e.g. #N/A, #VALUE!, #NUM!, empty cell), but they will not be included in the calculations.
- The relative mean difference is defined in terms of the mean difference as follows:
$$\mathrm{RMD}= \frac{\mathrm{MD}}{\bar{x}}$$
where:
- $\bar{x}$ is the sample mean (average) of the time series
- $\mathrm{MD}$ is the mean difference of the time series
- The RMD is also equal to twice the Gini coefficient.
Examples
Example 1:
|
|
Formula | Description (Result) |
---|---|
=RMD($B$2:$B$30,1,1) | Relative mean difference (-4.085) |
Files Examples
Related Links
References
- Hamilton, J .D.; Time Series Analysis , Princeton University Press (1994), ISBN 0-691-04289-6
- Tsay, Ruey S.; Analysis of Financial Time Series John Wiley & SONS. (2005), ISBN 0-471-690740
Comments
Article is closed for comments.