how to find Mean Error(ME), RMSE, Std Deviation either in matlab or in exel

i am working on my ME thesis in the field "Tuning of propagation Model at 1800 MHz for dense urban areas" got the plots for theoretical model like Free space,Cost 231 hata, Cost 231 WI,ECC,Sui, Erricson and also got the Actual measurements from field via drive test. Now i have to find these error metrics to compare the theoretical and actual data. if anyone can help please do.

Answer 1

[Star Strider]

Defining:

Err = model - actual;                   % Both Are Column Vectors
mean_err = mean(Err);
mean_abs_err = mean(abs(Err));
RMSE = sqrt(mean(Err.^2));
std_err = std(Err);

[ranjeeta verma]

Thank You for replying. once i use this in my thesis i hope i get expected results

[Star Strider]

My pleasure.

I wish you well in your research.