Hi,
I have a dataset with a variable versus depth (see below example). I want to calculate a weighted average of a calculated subset of these data, for example, the weighted average from 3.2 to, say, 8.7. I know how to calculate the weighted average of the full dataset, but not a subset, which will be determined by other parameters where the output will be the depth range (in this example 3.2 and 8.7). Any one have any ideas?
<tbody>
</tbody>
I have a dataset with a variable versus depth (see below example). I want to calculate a weighted average of a calculated subset of these data, for example, the weighted average from 3.2 to, say, 8.7. I know how to calculate the weighted average of the full dataset, but not a subset, which will be determined by other parameters where the output will be the depth range (in this example 3.2 and 8.7). Any one have any ideas?
1 | 15 |
2 | 2 |
3 | 169 |
4 | 7 |
5 | 4 |
6 | 123 |
7 | 0.1 |
8 | 0.25 |
9 | 30 |
10 | 20 |
<tbody>
</tbody>