Help with solving this problem with excel formulas please

Table is sorted by Distance to the New Observation \begin{tabular}{|c|c|c|c|c|} \hline Observation & Average Balance & Age & NumberofChidren & Distancestoneighbors \\ \hline 2 & $1,837 & 38 & 1 & 2.83 \\ \hline 7 & $1,326 & 42 & 1 & 2.83 \\ \hline 9 & $546 & 45 & 2 & 5.10 \\ \hline 8 & $1,746 & 35 & 0 & 5.83 \\ \hline 3 & $515 & 46 & 2 & 6.08 \\ \hline 4 & $200 & 31 & 1 & 9.22 \\ \hline 6 & $0 & 50 & 3 & 10.00 \\ \hline 10 & $1,788 & 29 & 1 & 11.18 \\ \hline 5 & $1,947 & 28 & 0 & 12.37 \\ \hline 1 & $1,041 & 61 & 4 & 21.02 \\ \hline New Obsrvation & & 40 & 3 & \\ \hline \end{tabular} \begin{tabular}{|c|l|c|} \hline k & \multicolumn{1}{|c|}{ k-Nearest Neighbors } & AverageofkNN \\ \hline 1 & {2} & $1,837 \\ \hline 2 & {2,7} & $1,582 \\ \hline 3 & {2,7,9} & $1,236 \\ \hline 4 & {2,7,9,8} & $1,364 \\ \hline 5 & {2,7,9,8,3} & $1,194 \\ \hline 6 & {2,7,9,8,3,4} & $1,028 \\ \hline 7 & {2.7.9.83.4.6} & $881 \\ \hline \end{tabular}