Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I do a lowess fit in Excel?
Are there any free addins or macros for excel that will do a lowess fit? |
#2
|
|||
|
|||
Tell us what is a 'lowess fit'
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Klara" wrote in message ... Are there any free addins or macros for excel that will do a lowess fit? |
#3
|
|||
|
|||
If you mean weighted fitting as per
Cleveland, W.S. and Devlin, S.J. (1988) "Locally Weighted Regression: An Approach to Regression Analysis by Local Fitting," Journal of the American Statistical Association, Vol. 83, pp. 596-610. This can be accomplished by multiple passes through sub-sets of the data with the standard polynomial regresion -- Gary''s Student "Bernard Liengme" wrote: Tell us what is a 'lowess fit' -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Klara" wrote in message ... Are there any free addins or macros for excel that will do a lowess fit? |
#4
|
|||
|
|||
Yes, I do mean this sort of weighted fitting. Thanks for digging out the
reference. Can you give me any pointers as to exactly how you apply your method please? Do you just do it manually, or have you written a macro? I appreciate that you might not want to go round giving your code to all and sundry but if you were able to send me an example xls file that would really help...? If anyone is interested, there is fortran code for this type of fit at http://nhsbig.inhs.uiuc.edu/general_stats/lowess.for thanks, Klara "Gary''s Student" wrote: If you mean weighted fitting as per Cleveland, W.S. and Devlin, S.J. (1988) "Locally Weighted Regression: An Approach to Regression Analysis by Local Fitting," Journal of the American Statistical Association, Vol. 83, pp. 596-610. This can be accomplished by multiple passes through sub-sets of the data with the standard polynomial regresion -- Gary''s Student "Bernard Liengme" wrote: Tell us what is a 'lowess fit' -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Klara" wrote in message ... Are there any free addins or macros for excel that will do a lowess fit? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |