Grouping days with similar distribution pattern

[kdp]

Hello,

I have data by 15min intervals which indicates the percentage of demand that occurred during that 15min of the day. For ex:

06/11/09 8:00 - 2%
06/11/09 8:15 - 1.5%
06/11/09 8:30 - 5%
........
........

The percentages of all timestamps throughout the day add up to 100%. I have this data for one year.

What I want to do is group days with similar distribution patterns according to number of peaks and when those peaks occur.

The reason I want to do this is to figure out what driver is responsible for the different patterns.

Any ideas or thughts on how to approach the groupings?

Thanks!

[DLing]

How about clustering the days using the measurements as variables. This can put days with similar patterns together. Looking at the outcome clusters may give more insight on next step.

[kdp]

Thanks for the idea DLing!

I will try it out in Enterprise Miner and post my results.

[kdp]

DLing - your idea worked perfectly - Thank you once again!

I used one year of data as an input and the cluster node created four different clusters. Then I used the Segment Profile node to look at each cluster and see what driver values are represented in each cluster.

Although the clusters made sense, I wish it was more sensitive. It should have created anywhere from 10-20 clusters. Maybe there is some setting I need to adjust, so it becomes more sensitive and in turn creates more clusters.

kdp