$3.$Using the training data provided in the $\text{'}$BP$-$Num$\_$train$$ sheet of the $\text{'}$BP$\_$train$\_$test' Excel file, use Excel to build a knn model and score the $$BP$\_$Num$\_$test$$ using the features $$Gender$,$Age$,$height$$ and $$weight$$ as predictors and $$BP$\_$Status' as the target variable. Use: K$=2,$ weighted, Euclidian distance. $(20$ points$)$

$$ Min Max

Age $($years$)2565$

Weight $($lb$)50300$

Height $($inch$)5080$