I have an Excel table with two rows.
One header row with positive integers representing different event properties and another row with the frequency of events with said property number.
Here’s a snippet of said table (ignore the second column):
I want to create a histogram where the top row is aggregated into different bins and then have each bin’s corresponding frequency. For example, bin [0,5] would have the frequency 1+75+1284+1943+1632+377 = 5312.
How would I go about achieving this?