Trying to Group a Range of Numbers in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-3020778%22%20slang%3D%22en-US%22%3ETrying%20to%20Group%20a%20Range%20of%20Numbers%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3020778%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20array%20of%20numbers%20below%20and%20I%20want%20to%20see%20groupings%20if%20I%20were%20to%20group%20into%204%20bins%2Fbuckets%20or%20if%20I%20were%20to%20group%20them%20into%205%20bins%2Fbuckets%20or%206%20bins%2Fbuckets%20and%20so%20forth.%26nbsp%3B%20For%20each%20scenario%2C%20what%20would%20be%20the%20range%20and%20median%20for%20each%20bin%2Fbucket%3F%26nbsp%3B%20I'm%20trying%20to%20group%20the%20numbers%20most%20like%20each%20other%20together%20and%20look%20at%20a%20couple%20examples%20based%20on%20various%20numbers%20of%20bins%2Fbuckets.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20border%3D%220%22%20width%3D%2264%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2264%22%20height%3D%2220%22%3E92.9%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E96.5%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E96.7%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E97.3%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E97.6%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E98.0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E98.1%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E98.1%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E98.4%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E98.4%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E99.2%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E101.0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E102.0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E102.1%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E102.1%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E102.2%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E102.5%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E103.1%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E103.2%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E104.0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E104.6%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E105.0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E105.2%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E105.7%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E107.2%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E107.3%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E108.9%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E109.1%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E109.2%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E110.0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E111.1%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E112.8%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E115.8%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E116.0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E116.2%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E118.0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E121.6%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E125.5%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E128.4%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E130.2%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3020778%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3024759%22%20slang%3D%22en-US%22%3ERe%3A%20Trying%20to%20Group%20a%20Range%20of%20Numbers%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3024759%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1234247%22%20target%3D%22_blank%22%3E%40KellyRosenthal%3C%2FA%3E%26nbsp%3BI%20attached%20an%20example.%26nbsp%3B%20There%20are%20many%20questions%20that%20I%20could%20ask%20to%20clarify%20but%20hope%20I%20made%20OK%20assumptions.%26nbsp%3B%20A%20couple%20key%20ones%20include%20that%20by%20x%20bins%20you%20want%20them%20%3D%20based%20on%20the%20range%20of%20the%20data.%26nbsp%3B%20i%20also%20assumed%20you%20have%20excel365%20but%20then%20had%20to%20do%20a%20fill%20down%20any%20how.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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.