First, my background is not math.
My objective is to find the value that occurs most frequently in a sample data OR the value that is most likely to have.
Lets say my sample data is [1,5,6,6,7,10]. To find mode for this sample is simple(the mode is 6).
But if lets say i change the sample data to [1,5,6,7,10], i dont know how to find mode. The results that i expected is 6 since 6 is the most probable data that i will get.
Problem is, i dont even know what to google(tried for hours), and even if i find something that MAYBE the answer(kernel density estimation,Continuous probability distribution), i dont understand what the hell they talking about.
The actual situation consist of hundreds of data(in floats) that i save in excel. i appreciate it if someone could demo it in excel.