Root mean square (RMS) error formula

[Guest]

Hello,

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

Thanks,

 

[Guest]

Lea,

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

http://geology.asu.edu/~glg410/2000/Lectures/GLG410--CurveFittingSolver.html

 

[Harlan Grove]

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.