The Trek BBS statistics

Posts: 5,945,200
Members: 26,482
Currently online: 462

STO Community Supports Chase Masterson Charity
By: T'Bonz on Nov 26

By: T'Bonz on Nov 26

Shatner In Hallmark Christmas Movie
By: T'Bonz on Nov 26

Abrams On Star Trek Into Darkness Flaws
By: T'Bonz on Nov 25

Star Trek Beyond In IMAX
By: T'Bonz on Nov 25

Red Shirt Diaries: The Return of The Archons
By: T'Bonz on Nov 23

Abrams Loves His Lens Flares
By: T'Bonz on Nov 23

Elba Star Trek Beyond Character Speculation
By: T'Bonz on Nov 23

Retro Review: Meld
By: Michelle Erica Green on Nov 20

Borg Cube Paper Lantern
By: T'Bonz on Nov 20

 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