How can I do a lowess fit in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top