Pass GPA Experience 11OCHON 3.20 11 3.75 15 0 3.65 3 3.30 4 3.64 12 3.16 5 3.01 11 ORTHOOOOHH 0 2.66 1 2.84 1 2.94 8 1 3.40 8 1 3.04 0 3.16 ° 3.45 0 2.73 4 0 2.52 7 1 3.88 1 2.76 0 2.71 8 1 3.99 2 1 3.06 9 1 3.31 0 2.77 0 3.59 4 0 3.18 1 3.21 1 3.50 1 2.98 1 3.76 OOHOOOHOONHOOL 2.64 3.02 3 1 3.00 9 2.66 1 2.99 1 2.94 8 1 3.20 7 ° 3.04 0 3.16 1 3.80 0 3.21 2.52 3 1 3.80 1 3.75 3.05 0 2.70 4 ∞ ∞ AF + 5 = ∞ - 6 m m 3 + 1 17 15 13 15 18 17 17 4 9 8 11 14 12 11 4 17 11 3 18 5 11 12 1 3.89 15 Experience GPA 2.97 3.80 3.20 2.98 2.70 12 3.11 2.94 8 3.30 2.68 15 3.45 7 237227052 10

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

For R, partition the data sets into 60% training and 40% validation and implement the 10-fold cross-validation. Use the statement set.seed(1) to specify the random seed for data partitioning and cross-validation. 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 variable.

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 accompanying data file with 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, 0 for fail), the employee’s college GPA, and years of work experience.

a. Perform KNN analysis to estimate a classification model for the CFA Level 1 exam using the second image attached and score the 10 job applicants in the first image attached . What are the misclassification rates for k = 3, 4, and 5?

Note: Round your answers to 4 decimal places.

 

b-1. What is the optimal value of k?

 

b-2. Report the overall accuracy, specificity, sensitivity, and precision rates for the validation data set.

Note: Round your answers to 2 decimal places.

 

b-3. Which of the following statements is most accurate?

  • A. The KNN model is likely to classify 100% of the employees into the correct classes.
  • B. The KNN model is likely to classify 100% of the employees who passed the CFA exam correctly.
  • C. The KNN model is likely to classify 79% of the employees who did not pass the CFA exam correctly.
  • D. The KNN model is likely to classify 88% of the employees into the correct classes.

c. Score the new consumer records in the CFA_Score worksheet. What is the predicted CFA Level 1 outcome for the first job applicant?

 
Pass
GPA
Experience
11OCHON
3.20
11
3.75
15
0
3.65
3
3.30
4
3.64
12
3.16
5
3.01
11
ORTHOOOOHH
0
2.66
1
2.84
1
2.94
8
1
3.40
8
1
3.04
0
3.16
°
3.45
0
2.73
4
0
2.52
7
1
3.88
1
2.76
0
2.71
8
1
3.99
2
1
3.06
9
1
3.31
0
2.77
0
3.59
4
0
3.18
1
3.21
1
3.50
1
2.98
1
3.76
OOHOOOHOONHOOL
2.64
3.02
3
1
3.00
9
2.66
1
2.99
1
2.94
8
1
3.20
7
°
3.04
0
3.16
1
3.80
0
3.21
2.52
3
1
3.80
1
3.75
3.05
0
2.70
4
∞ ∞ AF + 5 = ∞ - 6 m m 3 + 1
17
15
13
15
18
17
17
4
9
8
11
14
12
11
4
17
11
3
18
5
11
12
1
3.89
15
Transcribed Image Text:Pass GPA Experience 11OCHON 3.20 11 3.75 15 0 3.65 3 3.30 4 3.64 12 3.16 5 3.01 11 ORTHOOOOHH 0 2.66 1 2.84 1 2.94 8 1 3.40 8 1 3.04 0 3.16 ° 3.45 0 2.73 4 0 2.52 7 1 3.88 1 2.76 0 2.71 8 1 3.99 2 1 3.06 9 1 3.31 0 2.77 0 3.59 4 0 3.18 1 3.21 1 3.50 1 2.98 1 3.76 OOHOOOHOONHOOL 2.64 3.02 3 1 3.00 9 2.66 1 2.99 1 2.94 8 1 3.20 7 ° 3.04 0 3.16 1 3.80 0 3.21 2.52 3 1 3.80 1 3.75 3.05 0 2.70 4 ∞ ∞ AF + 5 = ∞ - 6 m m 3 + 1 17 15 13 15 18 17 17 4 9 8 11 14 12 11 4 17 11 3 18 5 11 12 1 3.89 15
Experience
GPA
2.97
3.80
3.20
2.98
2.70
12
3.11
2.94
8
3.30
2.68
15
3.45
7
237227052
10
Transcribed Image Text:Experience GPA 2.97 3.80 3.20 2.98 2.70 12 3.11 2.94 8 3.30 2.68 15 3.45 7 237227052 10
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.