Hi everyone,
I am facing the following challenge.
I have a series of values ranging from 100.000 to 1.000
100.000
87.000
86.000
85.400
70.000
.
.
2.500
1.000
I am interested to summarize into bins only values from 20.000 to 1.000.
I need 100 bins to assign my values in and calculate their mean and median.
The challenge for me is that the bins won’t have the same width.
Each bin’s width is already known.
etc
for the first bin is from 21.000 to 19.000
the second 19.000 to 17.550
the third 17.550 to 12.210 etc
Any ideas???