Pareto cum. distribution function
 

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

Pareto cum. distribution function
 

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