clustering in excel

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: clustering in excel

  1. #1
    New Member
    Join Date
    Mar 2013
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default clustering in excel

     
    Is there a way to cluster data in excel? using k-means for example?

    this data for example

    ID SPEED DELTA TIME
    56000472 10 2 6.7
    56000751 12 1.5 0.5
    55994383 11 1.8 35.4
    56030288 14 1.6 4.6
    56030705 19 1.7 31.6
    56091493 10 1.7 0.5
    56098106 16 1.3 0.7
    56110385 11 2.1 2.3
    56137646 21 1.8 19.6
    56178301 10 1.9 36.3
    56226556 11 1.7 5.9
    56272706 13 1.4 3.8
    56364857 20 1.2 0.3
    56429227 17 1.8 5.7
    56003301 10 1.8 4.4
    56008566 15 1.6 2.6
    56016117 17 1.7 18.2
    56523288 15 1.9 1.5
    55994440 11 1.6 33.2
    55994441 15 1.3 30
    56002912 11 1.7 52.4
    56007309 10 1.8 13.3
    56025831 18 1.9 0.6

  2. #2
    MrExcel MVP
    Join Date
    May 2002
    Posts
    14,178
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: clustering in excel

    Hi. You shouldn't assume everyone knows what you mean by k-means

    That said - a quick search turned up this

    k-Means Cluster Analysis in Microsoft Excel | Neilson

    ..which has some code for implementing k-mean algorithm
    Two plus two equals five for large values of two.

  3. #3
    Board Regular
    Join Date
    Feb 2013
    Posts
    146
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: clustering in excel

    What are you really trying to achieve?
    What for these data sets are, and to cluster what with what, and why?

  4. #4
    Board Regular
    Join Date
    Oct 2011
    Posts
    3,470
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    1 Thread(s)

    Default Re: clustering in excel

      
    Another option may be R an opensource (free) statistical computing software. It can handle k-mean, hierarchical clustering with ease.
    However depending on your background it can also have a steep learning curve.
    See attached for info and to download.


    The R Project for Statistical Computing

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com