Histograms with dynamic Bins

Originally Posted by MrShorty

I'm not sure I understand the problem. You are already calculating "dynamic" bins, and your FREQUENCY() function looks like it working just fine. The histogram in your sample looks correct, except for the N/A's for the top two bins. It is not clear to me if this is the error you are seeing or if there is something else. What exactly seems to be the problem with the sample spreadsheet?

MrShortly,

In my code, I hard code the increment between bins of .0001" The problem is not all data is fourth decimal places.

And I was wondering if there is any other has better idea to calculate bins besides using standard deviation.

Thanks for your reply

1.JPG