Root mean square (RMS) error formula
 

Hello,

does anyone know what the formula for calculating root mean square (RMS)
error is? Can this be done in Excel?

Thanks,

Lea,

This web site looks like it might have the Excel calculation that you're
looking for:

http://geology.asu.edu/~glg410/2000/...ingSolver.html

----
Regards,
John Mansfield
http://www.pdbook.com

"Lea Olsen" wrote:

Hello,

does anyone know what the formula for calculating root mean square (RMS)
error is? Can this be done in Excel?

Thanks,

"Lea Olsen" <Lea wrote...
does anyone know what the formula for calculating root mean square (RMS)
error is? Can this be done in Excel?

RMS is just the (population) standard deviation of your residuals. If you
have actual data, Y, and fitted estimates of those data points, Z, your RMS
is given by the array formulas

=SQRT(DEVSQ(Y-Z)/COUNT(Y))

or

=STDEVP(Y-Z)

The former is less susceptible to truncation error.