Universities often rely on a high school student’s grade point average (GPA) and scores on the SAT or ACT for the college admission decisions. Consider the data for 120 applicants on college admission (Admit equals 1 if admitted, 0 otherwise) along with the student’s GPA and SAT scores. A portion of the Admit_Data worksheet is shown in the accompanying table 

a. Perform KNN analysis to estimate a classification model for college admission decisions in the Admit_Data worksheet and score new applications in the Admit_ Score worksheet. What is the optimal value of k? 

b. Report and interpret the overall accuracy, specificity, sensitivity, and precision rates for the test data set (for Analytic Solver) or validation data set (for R). 

c. What is the area under the ROC curve (or the AUC value)? Comment on the performance of the KNN classification model. 

d. What is the predicted admission outcome for the first new application?

Transcribed Image Text:

Admit 1 0 # 1 GPA 3.10 2.70 4.40 SAT 1550 1360 1 1320