If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Form's datasheet view - sort order problem | Simon Wong | Using Forms | 7 | October 18th, 2004 02:28 PM |
Adding a Record to the Database Out of Sequential Order | Lisa | General Discussion | 3 | September 29th, 2004 04:59 PM |
Adding a Record to a Form Out of Order | Lisa | Using Forms | 3 | September 29th, 2004 04:46 PM |
Inhereting the sort order | Dan St.John | Setting Up & Running Reports | 1 | July 9th, 2004 03:30 AM |
X Axis Sort Order | Jason | Charts and Charting | 2 | October 9th, 2003 04:12 PM |