How would I go at using an analytic solver for a file set and find the answers below

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 0.75 variable. points Skipped The accompanying file contains 1,000 observations with the binary target variable y along with the predictor variables x1, x2, and x3. ExpictureClick here for the Excel Data File eBook a. Perform KNN analysis on the data set. What is the optimal value of k. Enter the optimal k in the box below: Optimal k Hint Print b. What is the misclassification rate for the optimal k? (Report your answer in percentage. Round your answer to 2 decimal places.) References Misclassification ratec-1. Report the accuracy, specificity, sensitivity, precision rates, and the AUC value for the test data set. (Enter your answers as decimals and round them to 2 decimal places.) 0.75 Accuracy points Specificity Skipped Sensitivity Precision eBook Hint c-2. Which of the following statements is most accurate? O A. The error rate of the KNN model is 85%. Print O B. The KNN model is able to correctly classify 74% of the Class 1 cases. O C. The KNN model is able to correctly classify 74% of the Class 0 cases. References O D. Overall, the KNN model is able to correctly classify 85% of the cases. d-1. What is the accuracy rate of the naive rule (classifying all cases into the predominant class) for the test data set? (Report your answer in percentage. Round your answer to 2 decimal places.) Accuracy rate of the naive rule %