I have a set of data that I would like to create bins. For example, 45, 23, and 10 will fall in the 0-49 bin. I created the histogram but am struggling in changing the ranges to display as the bins as the ranges below.
Data:
45
23
897
456
123
10
Bins
0 - 49
50 - 99
100 - 175
176 - 299
300 - 999
1000 - 4999
<tbody>
</tbody>
Data:
45
23
897
456
123
10
Bins
0 - 49
50 - 99
100 - 175
176 - 299
300 - 999
1000 - 4999
Data | | Bins | | | |
45 | | 0 | | | |
23 | | 49 | | | Frequency |
897 | | 50 | | 49 | 3 |
456 | | 99 | | 50 | 0 |
123 | | 100 | | 99 | 0 |
10 | | 175 | | 100 | 0 |
| | 176 | | 175 | 1 |
| | 299 | | 176 | 0 |
| | 300 | | 299 | 0 |
| | 999 | | 300 | 0 |
| | 1000 | | 999 | 2 |
| | 4999 | | 1000 | 0 |
| | | | 4999 | 0 |
| | | | More | 0 |
<tbody>
</tbody>