The Chartered Financial Analyst (CFA) designation is the de facto professional certification for the financial industry. Employers
Question:
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 SolidRock 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 1 exam last year, including the employee's success on the exam (1 for pass, 0 for fail), the employee's college GPA, and years of work experience.
The CFA_Data worksheet:
Pass | GPA | Experience |
---|---|---|
1 | 3.20 | 11 |
1 | 3.75 | 15 |
0 | 3.65 | 3 |
0 | 3.30 | 4 |
1 | 3.64 | 12 |
0 | 3.16 | 5 |
1 | 3.01 | 11 |
0 | 2.66 | 17 |
1 | 2.84 | 15 |
1 | 2.94 | 8 |
1 | 3.40 | 8 |
1 | 3.04 | 13 |
0 | 3.16 | 15 |
0 | 3.45 | 18 |
0 | 2.73 | 4 |
0 | 2.52 | 7 |
1 | 3.88 | 17 |
1 | 2.76 | 17 |
0 | 2.71 | 8 |
1 | 3.99 | 2 |
1 | 3.06 | 9 |
1 | 3.31 | 4 |
0 | 2.77 | 9 |
0 | 3.59 | 4 |
0 | 3.18 | 8 |
1 | 3.21 | 11 |
1 | 3.50 | 14 |
1 | 2.98 | 12 |
1 | 3.76 | 11 |
0 | 2.64 | 4 |
0 | 3.02 | 3 |
1 | 3.00 | 9 |
0 | 2.66 | 17 |
1 | 2.99 | 11 |
1 | 2.94 | 8 |
1 | 3.20 | 7 |
0 | 3.04 | 6 |
0 | 3.16 | 3 |
1 | 3.80 | 18 |
0 | 3.21 | 5 |
0 | 2.52 | 3 |
1 | 3.80 | 11 |
1 | 3.75 | 12 |
0 | 3.05 | 3 |
0 | 2.70 | 4 |
1 | 3.89 | 15 |
1 | 2.76 | 18 |
0 | 2.71 | 2 |
1 | 3.99 | 1 |
1 | 3.06 | 10 |
1 | 3.81 | 4 |
0 | 3.11 | 1 |
1 | 3.30 | 12 |
1 | 3.28 | 13 |
0 | 2.98 | 2 |
1 | 3.77 | 8 |
0 | 2.50 | 3 |
0 | 3.01 | 1 |
1 | 2.99 | 10 |
0 | 2.56 | 15 |
1 | 3.02 | 16 |
1 | 3.03 | 9 |
1 | 3.21 | 6 |
Q1: 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.
Use 70% of the data for Training and 30% for Validation with 12345 as the random seed.
Use 12345 as random seed when building the KNN model.