Using data from Pharmaceuticals.xlsx , run K-means clustering for k values 1-9. Using the elbow method, select the best value for k. Export the output to an Excel file, run a heat map, and name your

 Using data from Pharmaceuticals.xlsx , run K-means clustering for k values 1-9. Using the elbow method, select the best value for k. Export the output to an Excel file, run a heat map, and name your clusters accordingly. Submit an Excel files that includes the heatmap and cluster names, your code, your elbow chart, and the selected k value. You need to drop the first two nominal fields, normalize the numeric fields, and binarize the last 3 categorical features. Since you deal with calculation of distance in this case, keep all n dummy variables resulting from binarization of a categorical variable with n categories (rather than going with n-1 used in regression analysis).