shg,

I spent the better part of last night and this morning exploring your suggestion, and I am intrigued by this approach. I know how to create a CDF (which will obviously be impacted by how I striate the buckets, but that is a separate matter), but I am getting hung up on what the procedure is, in plain language, once I have the CDF of my initial distribution.

Say I have a cumulative value column created now using the histogram function in the Data Analysis toolpak, and my data is binned in 1% increments. I am now getting stuck on how to mathematically perform the transform that is being described in the link (and many others I have searched). Everyone seems to be implementing this sort of approach in R, but there doesn't seem to be anything about this that Excel can't handle (for smaller distributions, anyhow). Any way you could provide detail?

Thanks. Also, while I haven't posted much until recently, I have to say that I have benefited greatly from the solutions you have provided to others as an anonymous chronic Googler of VBA solutions over the years. Many thanks in advance.

LBF