View Single Post
  #11  
Old October 11th, 2004, 12:45 PM
Jerry W. Lewis
external usenet poster
 
Posts: n/a
Default

See the CRC book "Fitting Statistical Distributions: The Generalized
Lambda Distribution and Generalized Bootstrap Methods" by Zaven A.
Karian and Edward J. Dudewicz

It develops the math and provides Maple code for fitting. You will have
to adapt to Excel.

Jerry

Frank & Pam Hayes wrote:

David,

The Tukey-lambda fit looks like it has promise for my cumulative probability
curve, but a google search on Tukey-lambda and Excel was pretty sparse.
Searching on Tukey-lambda alone brought many more results, most of which
were beyond my statistical competance. The cumulative distribution function
shown at : http://www.itl.nist.gov/div898/handb...n3/eda366f.htm
looks to be exactly what I am trying to produce.

Can you point me in the right direction on how I would use Tukey-lambda in
Excel to calculate the cumulative probabilty curve?

Frank

"David J. Braden" wrote in message
...

Another idea:
Generalized inverse Tukey-lambda fit, which requires but 4 parameters, and
is very well behaved at endpoints. The fit is on the inverse cumulative,
and seems to be very stable wrt Excel.

"Jerry W. Lewis" wrote in message
...

And if the data can meaningfully be fitted to an 8th order polynomial, I
would still worry about numerical problems unless you were using Excel
2003 and no coefficients were estimated to be exactly zero
http://groups.google.com/groups?selm...0no_e-mail.com

Jerry

Bernard Liengme wrote:


Use LINEST to generate coefficients - see
www.stfx.ca/people/bliengme/ExcelTips
Use the coefficients to generate trendline data

Do your really have data that can meaningfully be fitted to 8th order?