Search for question
Question

Part 2: You are a business analytics analyst, and your director has given you the task of analyzing automobile data. Using the attached "Automobiles" dataset, perform a K-Means cluster analysis on these variables. It is recommended that you perform a cluster analysis for 2, 3, 4, and 5 clusters and select the optimal model based on the results. In a 300-word summary, provide the requested screenshots and address the following: 1. Explain your approach to the problem. 2. State the optimal number of clusters and the cluster sizes, and discuss the most logical cluster characteristics. Include discussion of how you would explain the attributes of each cluster group and justify your explanation. 3. Provide at least three scatterplots of selected input variables of your choice that help explain the cluster categories. 4. Provide a line chart of the silhouette coefficients for each cluster and the overall silhouette coefficient for the model. 5. Export the cluster assignment for each record to an Excel file. Name the file "Clusters.xlsx." Provide overall conclusion based upon the results of the K-Means analysis. Note that you are required to submit the completed KNIME *.knwf file to your instructor. Specifically, export your KNIME model to a KNIME workflow file. To perform this task in KNIME, ensure that your KNIME model is active (i.e., displayed). Then, go to File - >Export KNIME Workflow. In the "Destination workflow file name (.knwf)" area, browse to a specific location on your computer. Click "Save" and then click "Finish."

Fig: 1