Calculates the root mean squared deviations (aka., root mean squared error (RMSE)) function.
Syntax
RMSD(X, Y, Ret_type)
- X
- is the original (eventual outcomes) time series sample data (a one dimensional array of cells (e.g. rows or columns)).
- Y
- is the forecast time series data (a one dimensional array of cells (e.g. rows or columns)).
- Ret_type
- is a switch to select the return output (1= RMSD (default), 2= NRMSD, 3= CV(RMSD)).
Order Description 1 RMSD (default) 2 Normalized RMSD (NRMSD) 3 Coefficient of Variation of the RMSD (CV(RMSD))
Remarks
- The RMSD is also known as root mean squared error (RMSE).
- The RMSD compares differences between two data sets, neither of which is accepted as the "standard or actual."
- The time series is homogeneous or equally spaced.
- The two time-series must be identical in size.
- The root mean squared errors (deviations) function is defined as follows:
$$\mathrm{RMSD}=\mathrm{RMSE}=\sqrt{\frac{\mathrm{SSE}}{N}}=\sqrt{\frac{\sum_{i=1}^N (x_i - \hat x_i)^2}{N}}$$
Where:
- $\{x_i\}$ is the actual observations time series
- $\{\hat x_i\}$ is the estimated or forecasted time series
- $N$ is the number of non-missing data points
- The normalized root-mean deviation (or errors) function is defined as follows:
$$\mathrm{NRMSD}=\frac{\mathrm{RMSD}}{x_{\mathrm{max}}-x_{\mathrm{min}}} $$
Where:
- $x_{\mathrm{max}}$ is the maximum value in the first time series
- $x_{\mathrm{min}}$ is the minimum value in the first time series
- The coefficient of variation of the RMSD $\mathrm{CV_{RMSD}}$ is defined as follows:
$$\mathrm{CV(RMSD)}=\frac{\mathrm{RMSD}}{\bar x}$$
Where:
- $\bar x$ is the mean of the first (observed) time series
Examples
Example 1:
|
|
Formula | Description (Result) |
---|---|
=RMSD($B$1:$B$19,$C$1:$C$19,1) | RMSD (1.689) |
=NRMSD($B$1:$B$19,$C$1:$C$19,2) | Normalized RMSD (1.689) |
=CV(RMSD)($B$1:$B$19,$C$1:$C$19,3) | Coefficient of Variation of the RMSD (1.689) |
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.