I have 30 years of time series data for which I would like to obtain approximate median dates for. The data looks like this:
<tbody>
</tbody>
Looking for an elegant way in Excel to return the date once the median (cumulative total for live)/2 is reached. I have tried using dget but since more than one record exceeds the median threshold, this returns an error. Does anyone have a suggestion for achieving this?
Date | Live |
12/27/1976 | 1 |
1/9/1977 | 1 |
2/22/1977 | 1 |
2/23/1977 | 1 |
2/24/1977 | 1 |
2/27/1977 | 1 |
3/1/1977 | 2 |
3/2/1977 | 2 |
3/3/1977 | 8 |
3/6/1977 | 1 |
3/7/1977 | 3 |
3/8/1977 | 24 |
3/9/1977 | 5 |
3/10/1977 | 5 |
3/11/1977 | 2 |
3/13/1977 | 1 |
3/21/1977 | 1 |
3/23/1977 | 1 |
4/12/1977 | 2 |
4/13/1977 | 1 |
4/22/1977 | 3 |
4/23/1977 | 1 |
<tbody>
</tbody>
Looking for an elegant way in Excel to return the date once the median (cumulative total for live)/2 is reached. I have tried using dget but since more than one record exceeds the median threshold, this returns an error. Does anyone have a suggestion for achieving this?