Feb 012016

Teaching notes for this activity

This activity is based around a free Excel template for quickly and easily running cluster analysis that is available at Cluster Analysis for Marketing (a related website).

One of the challenges of cluster analysis that it appears quite complex and, usually, it needs to be run using special statistical software (such as SPSS).

However, using the free template on the above website – students will be able to run cluster analysis simply by entering the data and then viewing the automatic output and graphs.

It is a good task to get students working with simple data and seeing how market segments can be formed – obviously students will need access to Excel to undertake this activity – therefore, it could be a good homework task.

Please see this page for instructions on how to use the template.

Also please see a related activity on this website.

Student Task

clustering 5 market segments examplePlease visit Cluster Analysis for Marketing (www.clusteranalysis4marketing.com) and download the free Excel template to run cluster analysis.

On this website you will also find instructions and video on how to use the template – it is very easy to use and does not require any real spreadsheet skills.

cluster analysis output cluster analysis final graphYour task to enter some hypothetical (or real if you have it) data for consumers. Enter data for at least ten consumers and at least two marketing variables (please see the list below for ideas on variables).

Then review the output – some examples are shown here – for the main graphs and tables automatically produced by the spreadsheet. (Please note that these examples are from different segmentation approaches – that is, they use different data).

Get a sense of the various market segments and their “needs” – based upon the marketing variables that you gave chosen to use.


Play around with the marketing (input) variables – change, add, delete and review the changes – and then answer:

  1. How do the variables change the segments?
  2. Which types of marketing variables seem to work best – provide more effective segments?
  3. Which is your best market segmentation approach from your various “tests”? Why?
  4. How do you think that cluster analysis works?
  5. What do you think are the pros and cons of this type of approach to market segmentation?

Ideas for marketing variables to use

  • Level of customer satisfaction
  • Brand awareness levels
  • Loyalty – switching behavior
  • Various attitudes to brand/s (you could incorporate results from an image survey)
  • Various attitudes (agree/disagree) to general life issues (measuring their values)
  • Degree of high/low purchase involvement in decisions
  • Heavy – light usage levels
  • Recency and frequency of purchase
  • Importance of price in the purchase decision
  • Importance of advertising to the consumer (degree of influence)
  • Level of media consumption
  • Use of opinion leaders and word-of-mouth for information


Sorry, the comment form is closed at this time.