How do you get Root Mean Square Error out of a column?

G

Gary''s Student

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I have lost 6 months work, how can i get my file back 1
Error ! Main Document Only! in footnotes 0
Save last item copied 0
How to center adjust text above and image in a two column document. 1
sqlite-odbc write conflict 2
MS Project Import Error Row 1 Column 5 2
Negative Standard Deviation? 3
Root mean square (RMS) error formula 2

Top