Feb 012016

Teaching notes for this activity

This activity introduces marketing students to the concept of forming market segments using consumer data. It is a very helpful technique for reinforcing that segments need to be similar in needs (homogeneous), yet distinctive from other market segments.

Because the activity is essentially visual in nature, it appeals to a broad range of students – and it is generally fun and engaging to run. With wrap-up class discussion, it should run around 20 to 30 minutes.

Additional resources

All the graphs have been produced from a free Excel cluster analysis template available at Cluster Analysis for Marketing (a related website).

Student task

Below are a series of scatter charts showing customers’ “customer satisfaction” (CSAT) and “loyalty” scores that we have obtained from our customer database (for the loyalty measure) and associated market research information (for CSAT). Each variable is scaled on a 1 to 5 basis – with 1 being very low and 5 being very high.

cluster analysis data set graph grouped

An example of the task

There are a number of different charts shown below – from different firms. Your task is to review each one and try identify and circle possible market segments (sets of similar data points) in each one and then answer the questions at the end.

An example has been provided for you here, where four market segments have been identified. You do not need to pick four – you can anywhere from two to six segments – and you can even use more than one approach for each graph.

The 20 consumer data points are represented by the red squares and the average for all the consumers is shown by the larger red circle.


cluster analysis and segment quiz

Market 1

cluster analysis and segment quiz3

Market 2

cluster analysis and segment quiz4

Market 3

cluster analysis and segment quiz5

Market 4

Student Questions

  1. Did you have the same number of segments each time?
  2. Were there charts were you could have constructed a different number of segments?
  3. Pick one of the charts and try to “describe” the segment – based on the limited information that we have?
  4. Are there any segments that don’t appear to make sense (from Q3)?
  5. Do you think that you would get more value from understanding the “obvious” segments – such as high CSAT and high loyalty, or is there more value in identifying “unexpected” segments?
  6. We only have two marketing variables used here – what other variables could be used as well to generate other market segments of value?
  7. What is a quick for/against of segmenting a market in this manner – that is, two variables on a chart?



Sorry, the comment form is closed at this time.