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

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Watch MrExcel Video

Forum statistics

Threads
1,113,824
Messages
5,544,539
Members
410,619
Latest member
gregor222
Top