Forum Discussion
Trying to Group a Range of Numbers in Excel
I have an array of numbers below and I want to see groupings if I were to group into 4 bins/buckets or if I were to group them into 5 bins/buckets or 6 bins/buckets and so forth. For each scenario, what would be the range and median for each bin/bucket? I'm trying to group the numbers most like each other together and look at a couple examples based on various numbers of bins/buckets.
| 92.9 |
| 96.5 |
| 96.7 |
| 97.3 |
| 97.6 |
| 98.0 |
| 98.1 |
| 98.1 |
| 98.4 |
| 98.4 |
| 99.2 |
| 101.0 |
| 102.0 |
| 102.1 |
| 102.1 |
| 102.2 |
| 102.5 |
| 103.1 |
| 103.2 |
| 104.0 |
| 104.6 |
| 105.0 |
| 105.2 |
| 105.7 |
| 107.2 |
| 107.3 |
| 108.9 |
| 109.1 |
| 109.2 |
| 110.0 |
| 111.1 |
| 112.8 |
| 115.8 |
| 116.0 |
| 116.2 |
| 118.0 |
| 121.6 |
| 125.5 |
| 128.4 |
| 130.2 |
1 Reply
KellyRosenthal I attached an example. There are many questions that I could ask to clarify but hope I made OK assumptions. A couple key ones include that by x bins you want them = based on the range of the data. i also assumed you have excel365 but then had to do a fill down any how.
