a) Create a process that does the following:

-Filters out rows with missing values -Normalizes the data set using a 0-1 range transformation -Applies k-means clustering to split the apartments into clusters.

Show a screenshot of the Process panel. You do not need to include the Parameters panel.

You might get a warning about the k-means operator not being able to handle missing values. As long as the missing values are filtered out earlier in the process, the operator will still work correctly.

b) In the k-means clustering parameters, set k equal to 3, check the determine good start values box, and use a local random seed of 12345. Then run the process from part a, and show a screenshot of the centroid table.

c) What are the three different types of apartments revealed by the results of part b? (Do not simply recite the values. To get credit for this question, you need to summarize the information in the centroid table into a concise description of each cluster.)

d) Change the value of k to 4, and run the process again. Two of the four clusters should contain large apartments. Explain briefly (1-2

what do i put into excel to do this