I am trying to make a histogram and I used =FREQUENCY(B1:B200;D9:D19) to get the frequency but it seems that there is something wrong with my formula because
1. for the 108.25-11.28 it shows more than 100 and i only have 100 data (should exclude zeros)
2. I double check the data by making it in ascending order and it does not match
Bookmarks