Use Excel functions and features to compute your answers for 7(a)-(c). Answer 7(d) in two cells: (1) small or large K? and (2) your reasoning. Organize and highlight your answers to each item.

7. The table below provides a training data set containing six observa tions, three predictors, and one qualitative response variable. 0 3 ed 2 0 0 Red 0 1 3 Reod 0 1 2 Green 2 3 5 -1 0Gren 6 1 ed Suppose we wish to use this data set to make a prediction for Y when Xi-X2 = X3-0 using K-nearest neighbors. a) Compute the Euclidean distance between each observation and the test point, X, = X2 = 3-0