Pareto cum. distribution function

[Guest]

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

 

[Ron Coderre]

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)