How can I do a lowess fit in Excel?
 

Are there any free addins or macros for excel that will do a lowess fit?

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?

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?

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?