PLEASE HELP WITH STEP-BY-STEP. SCREEN SHOT OF EXCEL SHEET ATTACHED.

• Download the data in excel formator in .csv formatand open it in a statistics package, Excel, RStudio, or Python
• Run a cluster analysis by following the prompts below.
• Repeat this step to fill in center2 as well.
• This will update the distances for column 1 and 2 the table on the right as well, although you must then adjust the Cluster labelings by reassigning which center had the minimum value, based on the updated distances.

1. Open the excel file. Randomly select k rows. Label these rows are center1 and center2.

1. make new table to the right that has each entry name as the first column, center1 and center2 as the next two columns, and cluster as the 4th. fill in center1, calculate the linear distance between the two vectors by adding the absolute value of the difference between every variable.

• Copy and paste the table on the right below so that the information is not lost . Remember to select paste special and the "values" so just the numbers are copied, not the formulas.
• next step is to adjust our original center1 and center2 values.
• Next, compare the current cluster assignments to the ones at the end of Step 2. If they are not identical, repeat Step 3 and Step 4 until the assignment labels no longer differ between the preceding labels and updated labels.
• Once the assignment labels do not differ, go ahead and officially assign each name to a cluster.

AutoSave O OFF , 6 . 5 5 DA = my_data-2.xIs - Compatibility Mode Q ~ Search Sheet " v Home Insert Draw Page Layout Formulas Data Review View Share Comments Calibri (Body) v 12 A 2 Wrap Text v General ZY AP - O. 4 E Merge & Center v $ ~ % " 100 -20 Conditional Format Cell Insert Delete Format Sort & Find 8 Ideas Paste BIUV Formatting as Table Styles X v Filter Select A1 X V fx First Name B D E F G H K L M N 0 P Q R S T U 1 First Name Last Name I have strong I have a stroi I have strong I have strong I have strong I have strong I have heard I know how to use R. Samantha Baker 4 Sammy Gonzales 4 Rivera 5 Brandon Chandler 6 ljeoma Chukwunyelu 7 Vicente Gonzalez 8 Catherine Reber Madison Range 10 Chopra 11 leffers 12 Madison Gerig 13 Charles Allen 14 jason dominguez U AAPOAUUIAUIAN . V O V U V V O O MI U V A V V V V V V V V V V U V O A P N N W A W U V AW NUT HHHVAU H A PNP HHHHHUHAPPPP 15 16 18 my_data + Count: 14 + 100%