Originally Posted by
bflorez
Hey MWE,
First of all, thanks again for all your help so far - it's aboslutely great to have people like you who are both incredibly knowledgable AND willing to help (a rare combination). I apologize for taken so long to get back to you, but I was on vacation.
The last file you send, ptile.zip, was great....you said you're pulling more together? I can't wait to see what else you have! The two most immediate modifications on what you've already sent me would be to have Sheet 1 automatically adjust the range to look at all the data I paste in (the other sheets DO do that, but I think b/c you were just using a basic 'countif()' on Sheet1, I have to manually resize the range everytime I paste data), and to allow me to add as many buckets as I want automatically. The other modification is also on Sheet1, to be able to specify the ranges inclusively, e.g.
1 to 5
6 to 10
11 to 35
16 to 99, etc.
Where I could put in '1' and '5', and then 6, 11, 16, etc would be automatically generated, allowing me to put in the high end ranges.
I didn't really understand what the stats were that you had on Sheet2, but a summary like that would be great (if I knew what it meant). Sheet3 obviously rocks the house, and is almost exactly what I was talking about - the only thing that would make it better would be not have to put in culumative percentages, but percentages for that particular bucket.
The ideal scenario would be to be able to drop data in, see a 'natural' distribution of the data, and be able to graphically slide the bucket boundaries, while watching another distribution that reflects the distribution of the data as I have it bucketed, while displaying the bucket edges, counts and percentages in each bucket. Much of the data we look at ISN't going to be normally distributed, but we like looking for data that is. You seem like you have a very good grasp of this stuff, so anything else you think might be useful definitely shoot back.
Thanks a lot. Talk to you soon,
Brendan