The clustering tools look for similarities or distances in the data to form groups of results. Cluster observations find groups among the rows of the data, while variables look to find groups among the columns.
For both Cluster Observations and Variables, we will investigate a dataset on car fuel efficiency. Cars are listed as observations and we will look to find groups among the different vehicles.
The following steps will cluster vehicle types together to identify similar vehicles that are identified by rows and then label the dendrogram with a column of vehicle and fuel type:
Open the
mpg.mtw
worksheet .Go to the Calc menu and select Calculator….
In Store result in variable:, enter the name of the new column as
Group
.In Expression:, enter the values as shown in the following screenshot. Then click on OK to create the
Group
column.Go to the Stat menu, click on Multivariate, and select Cluster Observations….
Enter...