Bracketing/Grouping Large Sets of Numbers

Atlas87

New Member
Joined
Jan 15, 2019
Messages
10
Hi everyone,

I recently did a survey where most questions had participants just give a number of times they did something. In any single question, the answers range from 0 to thousands.

I want excel to group down that data into statistically significant groups. I.e. i dont want to just tell excel to split them by quartiles etc....i'm really looking for a statistical test where excel will decide where the significant groups lie.

I guess this is more an SPSS style question but i only have Excel to use.

Any ideas on this would be great. Even conceptual answers which dont involve excel would be a good start for me to understand what to do with these.

Thanks
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Watch MrExcel Video

Forum statistics

Threads
1,114,506
Messages
5,548,471
Members
410,838
Latest member
naydeenmonzon
Top