Big Data Analysis

Academic Year $2023-2024$

Excel Application $3-$K$-$Means

The file competitiveness data.xlsx contains data from $2015-2016$ Global Competitiveness Report. The report assesses the competitiveness landscape of $140$ economies, providing insight into the drivers of their productivity and prosperity. For more details, see World Economic Forum Website. In your Excel file you can see the values of $12$ main variables used for evaluating competitiveness of the countries by measuring the global competitiveness index rank of countries.

Download the kmeans.xlsm file to run the K$-$means analysis. Take the data $($only the $12$ variables with column names$)$ from the competitiveness data.xlsx file and copy it to the "Data" sheet in kmeans.xlsm $($starting from cell B$2)$ to start the analysis. The values should start from B$3.$

You need to provide all the parameters in "Start" sheet of the kmeans.xlsm file in order to run the Kmeans algorithm. The detailed explanation of each of the inputs is the following:

Max Iterations: the maximum number of iterations that you want the algorithm to perform.

Data sheet: the name of the sheet where data is stored. You can add the names of the countries in the column N: the name of the variable "Country" is at cell N$2,$ and country names start at N$3.$

Data range: the range of cells where your data is$,$ starting from the cell B$3.$

Output sheet: the sheet where the algorithm will provide cluster numbers for each country: "Data"

Output Location: the cell in "Data" sheet, starting from which the algorithm should provide the cluster number for each row.

Clusters: the number of clusters you wish to have.

In this sheet you also can see the "Distance" cell: This measures the overall within$-$cluster variation used for evaluating the performance of the algorithm. The lower the distance, the more accurate results.

After you run the $K-$means algorithm, you can see the cluster number of each country in the sheet that you specified. In the "Result" sheet you can see the number of countries in each cluster, as well as the centroid values of all variables for each cluster. You can add the column names in the "Result" starting from the cell B$8,$ by copying from the original data file.

$\frac{1}{5}$

HOW TO SUBMIT YOUR WORK

For your assignment you need to upload the kmeans.xlsm file with all the operations, as well as a Word file with answers to the questions.

Provide the names and the last names of all the group members in the "Group" sheet in Excel and in the beginning of the Word file.

Give correct naming to vour email, excel, and word files. The file should include the TD number, the number of your TD group, your group number and last name of one of the group members.

Example: TD$3\_$Group$2.$xlsx