Formula to return in which range of values most nbrs fall !??

Hi all ,

If A1= 2
A2= 3
A3= 5
A4= 8
A5= 2.5
A6= 4.3

1) First,I need a formula in A7 to group the availabe numbers into ranges of whatever increment i need for example in this case if i choose increment 1 the formula should return (2;3) (4;5)and 8 . the nbr 2.5 is in between 2 and 3 while the nbr 4.3 is between 4 & 5 and nbr 8 is alone

2) A formula to return the most frequent range number whether it is (2;3)(4;5) or 8

Joining all in one formula the result should be (2;3) cause the numbers in the range A1:A6 mostly fall between that range.

Million thanks for your support

The formula worked good for the data given but it could not be applied to other given data such as

B1=425 ; B2= 426.5; B3= 430; B4= 438; B5= 435; B6= 427; B7= 431

Thanks for the help !

In your formula there are numbers that do not refer to cells in the range A1:A6 and that because you wanted to create a range of value for ex nr 4 isnt in the given data though exists in the formula so i couldnt adjust it manually ,any way to be solved by formulas no matter if the data is sorted or whatever numbers it includes ???