MM4XL Tools: Cluster Analysis

   

Marketing Manager for Excel
MM4XL Software

Comprehensive Analysis Toolbox for Marketers & Business Analysis.
 
Cluster Analysis – Data Segmentation

Cluster Analysis is used to segment items or people into homogeneous groups. In marketing, segmentation often results from the need to differentiate based on positioning, and requires data relating to behavior and attitude. But it is also often used when analyzing performance, for instance of affiliate companies, points of sale, distributors, etc.; for clustering satisfaction of internal and external customers; and also for treating profiles of products, companies, geographic regions, and so on.

The many available clustering methods can be divided into two main groups:

  • Hierarchical methods, which group data row by row and do not require specifying in advance the desired number of clusters.
  • Partitioning methods, which assign items to a user defined number of clusters.
MM4XL makes available the most popular type of each method: Ward's hierarchical clustering method and the Centroid (or K-means) partitioning clustering method. The former is typically run first, to get an understanding of the data structure, and the latter method is used for refining the clusters.



 
 
 

 

We proudly serve:


    Website by DRA  
(C) MarketingStat GmbH 2007 Home | Download trial copy | Buy MM4XL | Sitemap | Links | Contact us