How would I go at finding the Binned of the data set
5 Exercise 9-24 Algo (Using Analytic Solver) For Analytic Solver, partition data sets into 60% training and 40% validation and use 12345 as the default random seed. 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. 0.75 points Skipped The accompanying data set contains three predictor variables (x1, x2, and x3) and the target variable ()). ExpictureClick here for the Excel Data File a. Bin predictor variables x1, x2, and x3. Choose the Equal count option and 3 bins for each of the three variables. What are the bin Book numbers for the variables of the first two observations? Binned_X1 Binned_X2 Binned_X3 Hint Observation 1 Observation 2 Print References b. Partition the data to develop a naive Bayes classification model where "1' denotes the positive or success class for y. Report the accuracy, specificity, sensitivity, and precision rates for the validation data set. (Enter your answers as decimals and round them to 2 decimal places.) Accuracy Specificity Sensitivity PrecisionAutoSave . Off H Ch9_Q24_V18_Data_File (2) - Excel Search Roman, Jacob J RJ X File Home Insert Page Layout Formulas Data Review View Help Data Mining Analytic Solver Share Comments A1 X v fx x1 A B C D E F G H K L M N O P Q R S T U V W x1 X2 x3 y 2 4.93 15 2.3 0 3 1.32 12.5 1.53 OH 4 2.46 7.5 4.11 19.58 12.5 4.93 6 10.59 10 3.4 2.18 17.5 2.35 3 18.1 60 4.17 4.93 15 3.88 10 19.58 12.5 8.85 11 19.58 12.5 8.38 HOOO 12 3.54 10 2.84 13 6.5 20 1.53 14 18.1 60 4.9 15 25.65 5 5.49 16 2.97 2.5 2.45 17 8.14 10 4.58 18 10.59 10 3.43 19 3.97 12.5 3.52 20 13.92 10 4.95 21 1.52 12.5 1.5 22 10.51 15 4.55 23 5.64 10 2.63 24 5.19 .2.5 2.5 25 2.53 0.97 26 18.1 60 7.18 27 7.87 12.5 6.39 28 18.1 60 5.5 O 29 18.1 60 4.49 O 30 10.59 10 9.53 31 10.51 15 4.8 32 6.91 7.5 1.82 33 4.93 15 1.62 o O 34 19.58 12.5 9.53 Exercise_9.24 +) + 100% Type here to search x 4:18 PM 2/24/2021 E