Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The file competitiveness data.sx contains data from 2 0 1 5 - 2 0 1 6 Global Competitiveness Report.The report assesses the competitiveness landscape of

The file competitiveness data.sx 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 means.xIsm 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.x/sm (starting from cell B2) to start the analysis. The values should start from B3.You need to provide all the parameters in "Start" sheet of the kmeans.xIsm file in order to run the K-means 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 N2, and country names start at N3. Data range: the range of cells where your data is, starting from the cell B3. 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 B8, by copying from the original data file.1/5HOW TO SUBMIT YOUR WORK1. 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.2. 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.3. Give correct naming to your 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: TD3_Group2.x/sx

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Temple Of Django Database Performance

Authors: Andrew Brookins

1st Edition

1734303700, 978-1734303704

More Books

Students also viewed these Databases questions

Question

5. Develop a self-management module for a training program.

Answered: 1 week ago

Question

b. Why were these values considered important?

Answered: 1 week ago