Please provide me with the FINAL Result of the excel screenshot: Below is a table consisting of $6$ automobiles information:

$\backslash$table$[[$mpg$,$cylinders displacement horsepower,weight,acceleration,$\backslash$table$[[$Model$],[$year$]],,],[14,8,350,165,4209,12,71],[26,4,96,69,2189,18,72],[18,6,232,100,2945,16,73],[19,4,121,112,2868,15\mathrm{.}5,73],[17,8,260,110,4060,19,77],[27,4,97,88,2130,14\mathrm{.}5,70]]$

Use K Nearest Neighbor method with $K=3,$ and apply min$-$max normalization to predict the value of $mpg$ for the following car:

$\backslash$table$[[$mpg$,$cylinders displacement,horsepower,weight,acceleration,$\backslash$table$[[$model$],[$Year$]],],[?,4,120,97,2506,14\mathrm{.}5,72]]$

Notes: You are not expected to use python to complete this part of the assignment, instead you can use excel to conduct the calculation. Please explain clearly your steps, together with the screen shots from your excel and prepare a Word or PDF as a submission on Canvas.