9 FILE CFA. The Chartered Financial Analyst (CFA) designation is the de facto professional certification for the financial industry. Employers encourage their prospective employees to complete the CFA exam. Daniella Campos, an HR manager at Solid Rock Investment, is reviewing 10 job applications. Given the low pass rate for CFA Level 1, Daniella wants to know whether or not the 10 prospective employees will be able to pass the CFA Level 1 exam. Historically, the pass rate is higher for those with work experience and a good GPA in college. With this insight, she compiles the Information on 63 current employees who took the CFA Level I exam last year, including the employee's success on the exam (1 for pass, O for fait), the employee's college GPA, and years of work experience. A portion of the CFA_Data worksheet is shown in the accompanying table. Puss GPA Experience 3.20 11 1 1 3.75 15 1 : ! 1 3.21 6 Data set A) Perform KNN analysis to estimate a classification model for the CFA Level 1 exam using the CFA_Data worksheet and score the 10 job applications in the CFA_Score worksheet. What are the misclassification rates for k = 3, 4, and 5 in the validation dataset? Use 70-30 Training and Validation split with 12345 as the random seed. A) Perform KNN analysis to estimate a classification model for the CFA Level 1 exam using the CFA_Data worksheet and score the 10 job applications in the CFA_Score worksheet. What are the misclassification rates for k = 3, 4, and 5 in the validation dataset? Use 70-30 Training and Validation split with 12345 as the random seed. k = 3: k = 4: k = 5: B) What is the optimal value of k in the validation dataset? optimal value of k: C) What is the predicted CFA Level 1 outcome for the first job applicant in the score dataset? 12 17 Pass 1 1 0 0 1 0 1 0 1 1 1 1 0 0 0 0 1 1 0 1 1 1 0 0 0 1 1 1 1 GPA Experience 3.20 11 3.75 15 3.65 3 3.30 4 3.64 3.16 5 3.01 11 2.66 2.84 15 2.94 8 3.40 8 3.04 13 3.16 15 3.45 18 2.73 4 2.52 7 3.88 17 2.76 17 2.718 3.99 2 3.06 9 3.31 4 2.77 9 3.59 4 3.18 8 3.21 11 3.50 14 2.98 12 3.76 11 2.64 4 3.02 3 O o 9 17 11 8 7 6 3 18 1 0 1 1 1 0 0 1 0 0 1 1 0 0 1 1 0 1 1 1 0 533 11 12 3.00 2.66 2.99 2.94 3.20 3.04 3.16 3.80 3.21 2.52 3.80 3.75 3.05 2.70 3.89 2.76 2.71 3.99 3.06 3.81 3.11 3.30 3.28 2.98 3.77 2.50 3.01 2.99 2.56 3.02 3.03 3.21 1 0 1 0 0 1 0 4 15 18 2. 1 10 4 1 12 13 2. 8 3 1 10 15 16 9 6 1 1 P GPA 2.97 3.80 3.20 2.98 2.70 3.11 2.94 3.30 2.68 3.45 Experience 10 3 7 2 12 7 8 5 15 7 9 FILE CFA. The Chartered Financial Analyst (CFA) designation is the de facto professional certification for the financial industry. Employers encourage their prospective employees to complete the CFA exam. Daniella Campos, an HR manager at Solid Rock Investment, is reviewing 10 job applications. Given the low pass rate for CFA Level 1, Daniella wants to know whether or not the 10 prospective employees will be able to pass the CFA Level 1 exam. Historically, the pass rate is higher for those with work experience and a good GPA in college. With this insight, she compiles the Information on 63 current employees who took the CFA Level I exam last year, including the employee's success on the exam (1 for pass, O for fait), the employee's college GPA, and years of work experience. A portion of the CFA_Data worksheet is shown in the accompanying table. Puss GPA Experience 3.20 11 1 1 3.75 15 1 : ! 1 3.21 6 Data set A) Perform KNN analysis to estimate a classification model for the CFA Level 1 exam using the CFA_Data worksheet and score the 10 job applications in the CFA_Score worksheet. What are the misclassification rates for k = 3, 4, and 5 in the validation dataset? Use 70-30 Training and Validation split with 12345 as the random seed. A) Perform KNN analysis to estimate a classification model for the CFA Level 1 exam using the CFA_Data worksheet and score the 10 job applications in the CFA_Score worksheet. What are the misclassification rates for k = 3, 4, and 5 in the validation dataset? Use 70-30 Training and Validation split with 12345 as the random seed. k = 3: k = 4: k = 5: B) What is the optimal value of k in the validation dataset? optimal value of k: C) What is the predicted CFA Level 1 outcome for the first job applicant in the score dataset? 12 17 Pass 1 1 0 0 1 0 1 0 1 1 1 1 0 0 0 0 1 1 0 1 1 1 0 0 0 1 1 1 1 GPA Experience 3.20 11 3.75 15 3.65 3 3.30 4 3.64 3.16 5 3.01 11 2.66 2.84 15 2.94 8 3.40 8 3.04 13 3.16 15 3.45 18 2.73 4 2.52 7 3.88 17 2.76 17 2.718 3.99 2 3.06 9 3.31 4 2.77 9 3.59 4 3.18 8 3.21 11 3.50 14 2.98 12 3.76 11 2.64 4 3.02 3 O o 9 17 11 8 7 6 3 18 1 0 1 1 1 0 0 1 0 0 1 1 0 0 1 1 0 1 1 1 0 533 11 12 3.00 2.66 2.99 2.94 3.20 3.04 3.16 3.80 3.21 2.52 3.80 3.75 3.05 2.70 3.89 2.76 2.71 3.99 3.06 3.81 3.11 3.30 3.28 2.98 3.77 2.50 3.01 2.99 2.56 3.02 3.03 3.21 1 0 1 0 0 1 0 4 15 18 2. 1 10 4 1 12 13 2. 8 3 1 10 15 16 9 6 1 1 P GPA 2.97 3.80 3.20 2.98 2.70 3.11 2.94 3.30 2.68 3.45 Experience 10 3 7 2 12 7 8 5 15 7