The file Tester1.xls in column A contains 50,000 random numbers. (To generate the random number, Excel's RAND function was used and then "froze" them by copying and paster values only over the formulas).
I am trying to write a sub that creates an array called frequency of size 10. It will then populate the array by looping over the random numbers and putting them into "bins." Specifically, frequency(1) should contain the count of all random numbers from 0 to 0.1, frequency(2) should contain the count of all random number from 0.1 to 0.2, and so on. Because every random number has to be in one of these bins, the counts should add to 50,000. The final contents of the array should be reported in a message box. (How should you deal with the endpoints such as 0.1? It doesn't really matter, because there is virtually no chance that a random number will fall exactly on one of the breakpoints.)