The Trek BBS statistics

Posts: 5,946,184
Members: 26,484
Currently online: 483

 The Trek BBS Stats Grouping...

 Science and Technology "Somewhere, something incredible is waiting to be known." - Carl Sagan.

 February 13 2014, 09:12 PM #1 ThunderAeroI Rear Admiral     Location: Perpetually being chased by airplanes Stats Grouping... 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? __________________ No Where to be found, but everywhere you are - I'll be there looking for ways to save your life.
 February 13 2014, 09:28 PM #2 Robert Maxwell Swiped Re: Stats Grouping... 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! __________________ BOYCOTT THE NEW STAR TREK
February 13 2014, 09:55 PM   #3
ThunderAeroI

Location: Perpetually being chased by airplanes
Re: Stats Grouping...

 Robert Maxwell wrote: 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
__________________
No Where to be found, but everywhere you are - I'll be there looking for ways to save your life.

 February 13 2014, 10:10 PM #4 CorporalCaptain Admiral     Location: "Who are you?" Re: Stats Grouping... It's called clustering. That'll get you started. __________________ “A life is like a garden. Perfect moments can be had, but not preserved, except in memory. LLAP” — Leonard Nimoy (1931-2015) CorporalCaptain

 Bookmarks