On 2/26/2009 1:39:32 AM, pleitch wrote:
>Latest Additions/Revisions:
>Cleaned up some of the
>variables and text.
>
>Cleaned up Null distance to be
>zero (should have been this
>from the start).
>
>
>Added more methods:
>Single Linkage (Nearest
>Neighbour)
>Clomplete Linkage (Furthest
>Neighbour)
>Centroid Method (Average)
Excellent 🙂
>Updated Bar graph is set to
>match the length shown on the
>web site (which is different
>to my book):
>http://www.wessa.net/rwasp_agg
>lomerativehierarchicalclusteri
>ng.wasp#output
>
>However, the order of the bar
>graph is still out. The order
>is based on both distance and
>join path (New_Labels variable
>later in the worksheet) - but
>I don't have the time/care
>factor to do that right now.
I also noticed the differences in the graphs. If you compare the one on the web site to the dendogram on the web site you'll notice they contain exactly the same information though. The bar graph is a sort of "filled in" dendogram. If I find time while I'm in Asia I might see if I can modify the dendogram routine to also return the correct data for the banner plot (a.k.a bar graph :-)). I also intend to convert the AC and dendogram calculations to functions. Ideally, it should be possible to call all of these routines multiple times without having to copy code. Finally, a lot of stuff needs to be dropped into collapsed areas so it's easier to scroll up and down the worksheet. and of course we need list boxes, etc to pick methods. I'll see what I can get done, but for sure nothing for the next week or so (until I get to Beijing).
Richard