As a result of neural classification of the table, ClassifierXL marks the rows of the table with a cluster number to which this row belongs. For example you have a table with geographical data that you need to classify.

Step 1. You click on ClassifierXL from the menu in MS Excel

After the launch of the program, you will see the ClassifierXL dialog box.

Step 2. Using the mouse, choose the range of numerical data of the table that you want to classify (Source data), and indicate the cell number from which to start recording the cluster markers (Output).

3. Set output formatting parameters:

• Split to multiple columns: when selected, a column will be created for each cluster. For each item, if it belongs to that cluster, a "1" will be displayed in the cluster cell. Otherwise, the cell will contain a "0".
• To one column: when selected, a single column is created and for each item, a cluster number is inserted into the cell for that column.
• Set autofilter: with this selected, you will be able to review the table rows being filtered.
• Draw charts: creates charts for the output data.
• Calculate averages: provides the averages for each category of the data items used in the categorization. In most cases, this information is extremely important. By comparing the average of a category to the total average and averages of other categories, the key characteristics of a category can be determined.
• Calculate weighted average: calculates the relative importance of each quantity on the average.
• Calculate minimums: calculates the minimum data values for each category.
• Calculate maximums: calculates the maximum data values for each cluster.
• Calculate cluster weight: calculates the weight of each cluster, which represents the percentage of items belonging to the cluster.
• Set colors: checking this option highlights the data from each category in a different color.
• Sort table by clusters: sorts the original table by clusters.
• Convert table to range: converting table formatting to the data range.

Step 4. Click on the Classify button and get the following results:

We have three clusters with the following specific weights.

You can see that 26% of countries fall in Cluster 1, 21% in Cluster 2, and 52% in Cluster 3.

On the basis of Cluster Profile Chart analyses the following description could be made:

Cluster 1 is a category of countries with big populations, population growth rate below the average, big land and water areas, many irrigated lands, and growth in Gross Domestic Product over the average.

Cluster 2 is a category of countries with population above the average, population growth that is maximal, water and land areas are small but with irrigated land exceeding the average, and GDP growth somewhat below the average.

Cluster 3 is a category of countries with populations 6 times lower than the average, standard population growth, water area considerably lower than average, area of irrigated land far below the average, and real GDP far below the average rate.