Weighted Average for a certain depth

Weighted Average for a certain depth

Answer 1

[Sulaymon Eshkabilov]

For the weighted mean calcution - see this MATLAB submission -

Answer 2

[Peter Perkins]

At one point you say "weighted soil moisture average to a given depth" and at another you say "soil moisture depth average". You don't say anything about what weights you are talking about. The only sense I can make out of this is that you mean the soil moisture *interpolated* at a specified depth, given multiple measurements on each day at fixed depths, averaged within day at each depth.

Maker a timetable TT of the raw moisture measurements, with five variables, one for each depth. Then

TTdaily = retime(TT,"daily","mean");
moisture = TT.Variables
depth = [5 15 30 50 75];
depths = [21.50 32.48];
interpMoisture = interp1(moisture,depth,depths)

If you mean something other than that, you need to be a lot more forthcoming.

[tqou37]

Thanks for the advice. I added more info to not be so vague.

[Peter Perkins]

You need to be a lot more clear. You keep saying "average", but you've never said "interpolate", which is what I think you want. You've said "three soil moisure tables" but only shown one. I'm guessing what you want is very similar to what I already suggested, but I'm guessing.

Show a worked example of exactly what you are starting with, the calculations, and what you want to end up with.