Hi all ,
In a row i have : A1= 450 B1=560 C1=500 D1=510 E1=445 F1=430 G1= 420
Those values represent several weights of a product prepared in this case 7 times, now that i want to decide what is the most relative weight to use on my list, i need a formula to tell me what is the most frequent bin scored given a difference of 50 grs maximum .
The formula should return the following answer : 400-450 which means that the most frequent weight bin is between 400 and 450 grs , now the 50 should be variable so if i change it somehow in the formula to 100 it should return 400-500 which means that the most frequent weight bin falls between 400 and 500 grs.
Any smart frequency formula can do that ?
i appreciate anyone's help, thank you much.