Retime mean data not aligning
3 views (last 30 days)
Show older comments
Hi there,
I'm using retime on a data set with a one second interval, to obtain averages for days and months (and many other intervals). One of the variables, Cool, in the table is a cooling % calculated from two other table variables, C1 and C2;
T1.Cool = 100*((T1.C1 - T1.C2) ./ T1.C1);
However when I use retime to change the interval of the data e.g.
TDay = retime(T1,"daily","mean");
The values of TDay.Cool is no longer the cooling difference between the new TDay.C1 and C2 variables. I.e. If Tday.C1 =100 and Tday.C2 = 90, Tday.Cooling shows as 9% rather than the actual cooling which is 10%.
What is happening in retime to get such behaviour and how can I correct it?
5 Comments
Peter Perkins
on 2 Sep 2021
Oliver, are you computing
mean(100*((T1.C1 - T1.C2) ./ T1.C1))
and expecting that to be the same as
100*((mean(TDay.C1) - mean(TDay.C2)) ./ mean(TDay.C1))
? Those are not the same thing.
Answers (0)
See Also
Categories
Find more on Matrices and Arrays in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!