How do you get Root Mean Square Error out of a column?
G Gary''s Student Aug 3, 2006 #2 If the column is A1 thru A10, then in B1 enter: =(AVERAGE($A$1:$A$10)-A1)^2 and copy down thru B10. Then the root mean square is: =SUM(B1:B10)^0.5
If the column is A1 thru A10, then in B1 enter: =(AVERAGE($A$1:$A$10)-A1)^2 and copy down thru B10. Then the root mean square is: =SUM(B1:B10)^0.5
