RSS iconTwitter iconFacebook icon

The Trek BBS title image

The Trek BBS statistics

Threads: 143,167
Posts: 5,597,691
Members: 25,397
Currently online: 676
Newest member: mastercheif

TrekToday headlines

Retro Review: When It Rains…
By: Michelle on Feb 27

Nimoy Dead At Eighty-Three
By: T'Bonz on Feb 27

Breaking news: Leonard Nimoy – ‘Mr Spock’ – dies aged 83
By: AntonyF on Feb 27

Hurley Passes
By: T'Bonz on Feb 26

USS Excelsior Model Coming Soon
By: T'Bonz on Feb 25

Hemsworth To Host SNL
By: T'Bonz on Feb 25

Quinto To Guest Star On HBO Comedy
By: T'Bonz on Feb 25

Wheaton To Voice Firefly Game
By: T'Bonz on Feb 24

Nimoy Health Scare
By: T'Bonz on Feb 24

Star Trek #42 Preview
By: T'Bonz on Feb 23


Welcome! The Trek BBS is the number one place to chat about Star Trek with like-minded fans. Please login to see our full range of forums as well as the ability to send and receive private messages, track your favourite topics and of course join in the discussions.

If you are a new visitor, join us for free. If you are an existing member please login below. Note: for members who joined under our old messageboard system, please login with your display name not your login name.


Go Back   The Trek BBS > Entertainment & Interests > Science and Technology

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

Reply
 
Thread Tools
Old February 13 2014, 09:12 PM   #1
ThunderAeroI
Rear Admiral
 
ThunderAeroI's Avatar
 
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.
ThunderAeroI is offline   Reply With Quote
Old February 13 2014, 09:28 PM   #2
Robert Maxwell
Knives Out, 24/7/365
 
Robert Maxwell's Avatar
 
Location: NJ Chapter
View Robert Maxwell's Twitter Profile Send a message via ICQ to Robert Maxwell Send a message via AIM to Robert Maxwell Send a message via Windows Live Messenger to Robert Maxwell Send a message via Yahoo to Robert Maxwell
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!
__________________
Not affiliated with those other white knights. I'm the good kind.
I has a blag.
Robert Maxwell is offline   Reply With Quote
Old February 13 2014, 09:55 PM   #3
ThunderAeroI
Rear Admiral
 
ThunderAeroI's Avatar
 
Location: Perpetually being chased by airplanes
Re: Stats Grouping...

Robert Maxwell wrote: View Post
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.
ThunderAeroI is offline   Reply With Quote
Old February 13 2014, 10:10 PM   #4
CorporalCaptain
Admiral
 
CorporalCaptain's Avatar
 
Location: North America
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 is offline   Reply With Quote
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



All times are GMT +1. The time now is 09:00 PM.

Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2015, Jelsoft Enterprises Ltd.
FireFox 2+ or Internet Explorer 7+ highly recommended.