Use Excel and the training dataset below to classify (predict) the records in the test dataset below. What is the error rate? Use k- nearest neighbors, Euclidian distance, K = 1 and method = unweighted vote. Make sure you normalize the data. (Hint, you can copy and paste the tables into Excel).

Training data set

Sepal length	Sepal width	Petal length	Petal Width	Species
5.4	3.7	1.5	0.2	Setosa
5	3	1.6	0.2	Setosa
5	3.5	1.3	0.3	Setosa
5.7	2.8	4.5	1.3	Versicolor
5.9	3.2	4.8	1.8	Versicolor
6	3.4	4.5	1.6	Versicolor
6.3	3.3	6	2.5	virginica
6.4	3.2	5.3	2.3	virginica
7.4	2.8	6.1	1.9	virginica
6.7	3	5.2	2.3	virginica

	Sepal length	Sepal width	petal length	petal width
Min	4.3	2.0	1.0	0.1
Max	7.9	4.4	6.9	2.5

Test data

Sepal Length	Sepal width	petal length	petal width	species
5.9	3.2	4.8	1.8	versicolor
5.5	2.4	3.8	1.1	versicolor
6.3	3.3	6	2.5	virginica
4.8	3	1.4	0.3	setosa