See if my Pareto Plotter gets you pointed in the right direction
http://www.contextures.com/excelfilesRon.html#RF00010
Note:
That file DOES contain macros.
Unhide sheets to see the inner workings.
Does that help?
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
"Jason Morin" wrote in message
...
I need to create Y values given a set of X values (18000 of them) that
follow
a basic Pareto cum. distribution curve. Essentially I'm looking for an
equation I can use, as if I applied a trendline and Excel provided the
equation.
I've read all the sites on the basic cum. dist. function, but I need help
in
the actual application to my set of values.
Thank you.
Jason
XL2000, Win XP