![]() ![]() Just a little disclaimer, I know that some people post homework questions or something trying to get an answer. Unfortunately, I can't do this in Matlab because it needs to be accessible by my colleagues on various computer too. Then maybe input those counts into a new array that can be used for the histogram?įrankly, any method is appreciated, efficiency isn't too important, I just need it to work. What I was thinking, or trying to do is have the countif go over the input column in a loop, from the lowest number to the highest number. ![]() I am familiar with the =countif function. The histogram could have anywhere from 100 individual bars of single frequency to one bar of 100 instances, or anywhere in-between. What makes this histogram more difficult than others is the varying possibilities of instances. From there I don't really know how to carry on. I've used =min and =max to define the bounds and made a box set equal to 1 called interval. I'm going to be inputting 100 numbers into a column (Say B2:B101) and need to make a histogram out of that at intervals of 1 from the lower bound to the upper bound of those 100 numbers. Hey everyone, I have what should be a fairly simple problem that has been taking me forever to figure out. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |