K
Klara
Are there any free addins or macros for excel that will do a lowess fit?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bernard Liengme
Tell us what is a 'lowess fit'
G
Gary''s Student
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
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
K
Klara
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
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