How would I use a KNN Analysis to find the K VALUE of a data set that looks like this?

1 0.75 points Skipped eBook Exercise 9-5 Algo (Using Analytic Solver) For Analytic Solver, partition the data sets into 50% training, 30% validation, and 20% test and use 12345 as the default random seed. When searching for the optimal value of k, search within possible k values from 1 to 10. If the predictor variable values are in the character format, then treat the predictor variable as a categorical variable. Otherwise, treat the predictor variable as a numerical variable. The accompanying file contains 1,000 observations with the binary target variable y along with the predictor variables x1, x2, and x3. pictureClick here for the Excel Data File a. Perform KNN analysis on the data set. What is the optimal value of k. Enter the optimal k in the box below: 101 Optimal k Hint Print References b. What is the misclassification rate for the optimal k? (Report your answer in percentage. Round your answer to 2 decimal places.) Misclassification rate %