Cluster variables work in a manner that is similar to cluster observations. Here, we are interested in the columns and variables in the worksheet rather than grouping the observations and rows.
We will look at the dataset for car fuel efficiency to identify groups of variables, or rather identify the columns that are similar to each other.
This dataset was collected from manufacturer-stated specifications.
Open the
mpg.MTW
worksheet.Go to the Stat menu, click on Multivariate, and select Cluster Variables….
Enter the columns for
CO2
,Cylinders
,Weight
,Combined mpg
,Max hp
, andCapacity
into the Variables or distance matrix: section.Check the Show dendrogram option.
Click on OK to create the results.
Inspect the dendrogram to identify groups in the result. The higher the value of similarity along the the y axis, the greater the similarity between columns, as shown in the following figure: