# Weighted average for depth intervals

• Jul 26th 2011, 01:43 PM
MotzTots
Weighted average for depth intervals
I have a data set and am making vertical profiles (depth on y axis)
I am averaging freshwater fractions for different water layers. Instead of doing a straight average, I need a weighted one in relation to the depth intervals.
For example:
Depth fAltantic
0 1
25 2
50 3
75 4
125 6
If I take a straight average it is 3.2. But it should be 3.5 (assume a linear relationship and add a point of (100,5) My data is not this "perfect" what equation can I apply to obtain averages over depths?
• Jul 27th 2011, 02:42 AM
SpringFan25
Re: Weighted average for depth intervals
Quote:

I have a data set and am making vertical profiles (depth on y axis)
I am averaging freshwater fractions for different water layers. Instead of doing a straight average, I need a weighted one in relation to the depth intervals.
For example:
Depth fAltantic
0 1
25 2
50 3
75 4
125 6
If I take a straight average it is 3.2. But it should be 3.5 (assume a linear relationship and add a point of (100,5) My data is not this "perfect" what equation can I apply to obtain averages over depths?
Please explain exactly what your are trying to average and what you want your weights to be. 3.2 is not the average of either column of your table. How did you get that figure?
• Jul 27th 2011, 02:47 AM
anonimnystefy
Re: Weighted average for depth intervals
actually (1+2+3+4+6)/5=16/5=3,2

MotzTots i think you skipped a value for 5 because (1+2+3+4+5+6)/6=21/6=3,5