Getting Mode from data range which is not Normalized

[thisisrahul]

I have a data range e.g. 1.15, 2.05, 2.1, 2.15, 1.95, 3.05, 4.15, 0.5
I want to know the MODE of this data in such a way that it captures x% of deviation.

For the above data range Mode should be 2 and the frequency would be 3 (2.05,2.1,1.95 to be considered).

any help is welcome.


__________
Rahul

 

[Aladin Akyurek]

Try to be more elaborate...

 

[thisisrahul]

let me try with the following example.
i have the following data set:-

1.15, 2.05, 1.95, 3.05, 4.15, 0.5, 2.05, 5.15, 2.05, 3.0, 3.05, 2.95, 3.0

the result of mode is 2.05 for the above data set, whereas i need to get 3 as mode.
logic being, there are more data points nearest to 3 than 2.05.

Instead, if i use round function to get nearest integer, i'll get my answer.
Is there a way getting the same answer without using round function.


let me know your thoughts...

 

[Aladin Akyurek]

let me try with the following example.
i have the following data set:-

1.15, 2.05, 1.95, 3.05, 4.15, 0.5, 2.05, 5.15, 2.05, 3.0, 3.05, 2.95, 3.0

the result of mode is 2.05 for the above data set, whereas i need to get 3 as mode.
logic being, there are more data points nearest to 3 than 2.05.

Instead, if i use round function to get nearest integer, i'll get my answer.
Is there a way getting the same answer without using round function.


let me know your thoughts...

Control+shift+enter, not just enter:

=MODE(ROUND(A2:M2,0))

 

[thisisrahul]

thanks Aladin,
i just figure that out with same formula of array post some trials.

gr8, it works perfectly.

 

[Aladin Akyurek]

thanks Aladin,
i just figure that out with same formula of array post some trials.

gr8, it works perfectly.

You are welcome.