Question $2$

Excel worksheet W$3$Q$2$ contains a set of baseball statistics for different players and an indicator if they hit more than $22$ home runs that season. Additionally, there are new $5$ players listed with an unknown total of home runs.

Perform k$-$Nearest Neighbor classification analysis on this data for all of the included data columns to predict if the new players will have more than $22$ home runs. Specifically, partition the data into training and validation data, use that partition to determine the best value of k$,$ and use that value of k to classify the new data.

IMPORTANT: When prompt, choose to $$Search $1..$K$$ and specify the $$# Neighbors $($K$)=10.$

Answer the following questions listed below using the k which fits this requirement. Also upload the completed workbook which shows your classification analysis and any work you completed to answer the questions.

What are the predicted classifications for the $5$ new players?

What is the best value of k to use based on your analysis? What is the second best value?

Which classification are you most confident with? Which classification are you least confident with?