Stats Grouping...

[ThunderAeroI]

Say I have a data set and I want to know how many groups to make of that sample. Like 1-20, 20-40, 40-80, etc.

How do I do that in Excel?

 

[Robert Maxwell]

I think you have to know what you want your groups to be. Or are you talking about normal distributions, or what? Needs more info!

 

[ThunderAeroI]

I think you have to know what you want your groups to be. Or are you talking about normal distributions, or what? Needs more info!

I'm just looking for a way to combine like datasets that isn't just me abstractly combining like ones.

For example;
I have the following data and I want to classify it into groups that are 'close' together. How do I establish those 'close' enough groups?

756
1,080
1,200
1,302
1,326
1,400
1,472
1,665
1,680
1,849
1,880
2,000
2,025
2,209
2,250
2,368
2,496
2,500
2,583
2,700
2,728
2,772
2,867
2,900
3,008
3,150
3,420
3,828
4,071
4,080
4,080
4,140
4,200
4,514
4,640
4,836
5,576
5,607
5,760
5,800
6,120
6,600
6,880
10,201
10,206
10,807
12,200
12,920
13,860
15,400
15,840
17,160
17,538
17,956
23,400
31,200
38,416
41,209
43,681
57,600
59,049
60,025
75,625
129,574

 

[CorporalCaptain]

It's called clustering. That'll get you started.