hi!

i was asked to calculate the RMSre between my reference and estimated data and i have simply no clue how to do this...

i think that the RMSre is somthing similar to the root mean square error (RMSE) right???

can somebody tell how to calculate this in excel??? for example, i now that for the RMSE i have to apply the following formula:

=SQRT((SUMXMY2(estimated data sum,reference data sum))/COUNT(number of estimated data fields))

can someone provide with a similar formula for excel please??? can you also write the formula using the language i used above???

thank you in advance!!!