# How to estimate a function that fit well with a curve

#### gibnem

hello
somme one know how to get the function that fit well with a curve
following is my curve:
[PLAIN]http://img814.imageshack.us/img814/5885/tempdepth.png [Broken]

thx..

Last edited by a moderator:

#### pmsrw3

http://en.wikipedia.org/wiki/LOESS" [Broken]?

Last edited by a moderator:

#### gibnem

yeh it could be...

i could create a function that fit very well withe that graph just in excel with a fourth polynomiale and i get the numerical expresion
but withe some other graphe with more variation the polynomiale function don't fit very good so i'm looking if i can found a softwar thar use other methodes (moving average, exp, or a mix of this methodes) to get a better curve fitting)

#### pmsrw3

A polynomial is not going to deal well with either the nearly vertical part at high depths, or the nearly horizontal part at low depths. You might be able to fix that with an appropriate coordinate transformation, but a generic method like LOESS will likely produce better results with less effort.

#### hotvette

Homework Helper
Here is a link to an Excel add-in that claims to have LOESS capability.

If I were doing this I'd consider some form of parametric cubic polynomials (e.g. Bezier) because they can handle vertical slopes.

Last edited:

#### gibnem

oooh thank you hotvette
that give a really a very very good fitting

### Physics Forums Values

We Value Quality
• Topics based on mainstream science
• Proper English grammar and spelling
We Value Civility
• Positive and compassionate attitudes
• Patience while debating
We Value Productivity
• Disciplined to remain on-topic
• Recognition of own weaknesses
• Solo and co-op problem solving