# best curve fitting

1. ## best curve fitting

Hi,
Maybe someone out there can help me!
I have a list of 500 experimental values. I also have a list of 500
predicted values which I predicted with an excel mathematical model I
generated. The excel model lets me change certain variable values which in
turn regenerates and gives me a new set of 500 numbers each time a variable
is changed. I wish to figure out which set of variables genertates a data set
which most closely matches my experimental data. At the moment I have the
data on numerous line graphs to visualise and some sets of variables look
very similar. How would I statistically evaluate these data sets to reveal
which is in fact the best fit?
Many thanks for reading this. I hope I've made it clear and understandable.

2. ## Re: best curve fitting

One approach is to go to groups.google.com and search for "excel solver
curve fit" (without the quotes).

Please do not post in multiple newsgroups (without letting us know).

- Mike
www.mikemiddleton.com

++++++++++++++++++++++++++++++++++

news:76BCF509-4A5B-421F-861B-9880F9938A7D@microsoft.com...
> Hi,
> Maybe someone out there can help me!
> I have a list of 500 experimental values. I also have a list of 500
> predicted values which I predicted with an excel mathematical model I
> generated. The excel model lets me change certain variable values which in
> turn regenerates and gives me a new set of 500 numbers each time a
> variable
> is changed. I wish to figure out which set of variables genertates a data
> set
> which most closely matches my experimental data. At the moment I have the
> data on numerous line graphs to visualise and some sets of variables look
> very similar. How would I statistically evaluate these data sets to reveal
> which is in fact the best fit?
> Many thanks for reading this. I hope I've made it clear and
> understandable.
>

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1