![]() then the first row of your results will show the frequency of a value between 20-21, the next 21-22 etc. Your bins array will contain the lower bounds of the bin, for example if the first couple of cells are 20,21,22. You can use the FREQUENCY function to bin your data into whatever chunks you need to, with the syntax being =FREQUENCY(data_array, bins_array). I appreciate this is a very old thread, but for the benefit of others looking for a solution to this:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |