How to calculate rmse in daily and monthly scale?

Hello

I have a problem in calculating rmse in daily and weekly time scale.

I have two matrixes as A for real measurement and B for predictoin both are 30x1

like :

A = [3;8;...;7;9];

B = [2;6;...;11;7];

How can i calculate rmse for A and B in daily and monthly time scale and compare them?

Any help will be appreciated.

Answer 1

[dpb]

Where's the date data to go with the data -- or is it daily for a given 30-day month, maybe?

If so, use a timetable with the date and then retime or groupsummary using the builtin timing methods.

You'll want to combine A and B into the single table and use an anonymous function to compute the rmse from the difference between the two columns, it's not a builtin function to apply between the two, although you could also then build the difference as a third variable and just operate over it to compute the std deviation.