Part II$.$ Descriptive Data Mining $-$ Cluster Analysis

Answer the following Questions$/$Requirements for Cluster Analysis:

$1.$ Set up the number of clusters $($K$)$ based on the cluster chart created $(2$ marks$)$

$2.$ For the initial center points$/$vectors$/$centroids$,$ use randomly assigned observation nos. to you. $($See the list posted below$)(2$ marks$)$

$3.$ Determine the similarities $($distance relationships$)$ between the variables$$ values to the initial center points by calculating the sum of the differences between the dataset values and the initial center values using the formula Euclidian Distance. $(5$ marks$)$

$4.$ Perform the required number of iterations $($rounds$)$ until complete or final clustering is achieved. $(8$ marks$)$

$5.$ Copy$/$Maintain separately every set of initial$/$derived center points used $($vectors$)$ for every iteration $($round$)$ as references.

$6.$ Copy the derived clustering table of every round $($use values only when pasting it$)$ to the free area below the established center values.

$7.$ Write your analysis based on the derived final clustering results. $(3$ marks$)$

$8.$ Write or a make a screenshot for each requirement and paste in the Assessment Output area. Properly label each according to the questions.

$9.$ Attached$/$Upload dataset with clustering analysis output$/$solutions$.$

Please Solve this in excel and give all the formulas