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
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