applying k-nn algorithm in excel

[sozib]

Hi i have two set of data,one for training and another set is testing. Can i use this data for k-nn algorithm on this?If yes , can u let me know how to do this??


training data

timestamp	c1	c2	c3	c4	c5	c6
1.52E+12	-35	-37	-36	-26	-28	-38
1.52E+12	-37	-38	-35	-26	-29	-37
1.52E+12	-38	-38	-34	-26	-29	-38
1.52E+12	-38	-38	-34	-26	-29	-38
1.52E+12	-38	-38	-34	-26	-29	-38
1.52E+12	-38	-38	-34	-26	-29	-38
1.52E+12	-38	-38	-34	-26	-29	-38
1.52E+12	-38	-38	-34	-26	-29	-38
1.52E+12	-38	-38	-34	-26	-29	-38
1.52E+12	-38	-38	-34	-26	-29	-38
1.52E+12	-38	-38	-34	-26	-29	-38
1.52E+12	-38	-38	-34	-26	-29	-38
1.52E+12	-38	-38	-34	-26	-29	-38
1.52E+12	-38	-38	-34	-26	-29	-38
1.52E+12	-38	-38	-34	-26	-29	-38
1.52E+12	-38	-38	-34	-26	-29	-38
1.52E+12	-38	-38	-34	-26	-29	-38
1.52E+12	-38	-38	-34	-26	-29	-38
1.52E+12	-38	-38	-34	-26	-29	-38
1.52E+12	-38	-38	-34	-26	-29	-38
1.52E+12	-38	-38	-34	-26	-29	-38
1.52E+12	-38	-38	-34	-26	-29	-38
1.52E+12	-38	-38	-34	-26	-29	-38
1.52E+12	-38	-38	-34	-26	-29	-38
1.52E+12	-38	-38	-34	-26	-29	-38
1.52E+12	-38	-38	-34	-26	-29	-38
1.52E+12	-38	-38	-34	-26	-29	-38
1.52E+12	-38	-38	-34	-26	-29	-38
1.52E+12	-38	-38	-34	-26	-29	-38
1.52E+12	-38	-38	-34	-26	-29	-38

<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>
</tbody>

testing data

timestamp	c1	c2	c3	c4	c5	c6
1.52E+12	-34	-37	-36	-27	-32	-37
1.52E+12	-32	-37	-36	-26	-32	-39
1.52E+12	-32	-37	-36	-26	-32	-39
1.52E+12	-32	-37	-36	-26	-32	-39
1.52E+12	-32	-37	-36	-26	-32	-39

<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>
</tbody>

any helps will be really appreciated..

Thanks

 

[Peter_SSs]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules. Be sure to follow & read the link at the end of the rule too!

Cross posted at: https://www.excelforum.com/excel-programming-vba-macros/1229476-k-nn-algorithm-for-excel.html

If you do cross-post in the future and also provide a link, then there shouldn’t be a problem.

 

[sozib]

As i have post here earlier , buthave not received any reply from anyone, then i post in different forum, but do i need to put the link in bot forum

 

[Peter_SSs]

As i have post here earlier , buthave not received any reply from anyone, then i post in different forum, but do i need to put the link in bot forum

Yes, normally all forums prefer you post links to cross-posts. To understand why, follow the link at the end of our rule #13 and read that page.

You do not need to do it in this thread though as I have done it for you.