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

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 %AutoSave . Off) H Ch9_Q5_V19_Data_File (5) - Protected View O Search Roman, Jacob J RJ X File Home Insert Page Layout Formulas Data Review View Help Data Mining Analytic Solver Share Comments i PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X A1 X D E F G H K L M N O P Q R S T U V W x1 X2 X3 N CO 97700 P 142 18 3900 70 O 15 124500 33 15 114800 54 1 108500 64 18 191000 88 360600 49 151300 90 144400 66 39400 57 391200 43 146400 74 109800 50 1099200 92 110600 59 93400 56 273200 38 154400 102 15 277400 62 18 396000 46 OHOHOHPOP 57500 99 180200 37 12 233500 43 12 155000 72 20 86100 60 18 291200 37 o co 118500 48 29 12 93200 34 30 15 454800 72 31 20 64600 106 32 18 216400 40 Exercise 9.5 (+) Ready + 100% 4:14 PM Type here to search X 2/24/2021 E