Need to fit a trendline to a Negative Exponential set of data

Excel 2007
Added Data Analysis (Regression)
and more.
http://www.mediafire.com/file/jx2zaj...06_12_09c.xlsx

Herbert,

Thanks once more.

I see what you have done. Now I need to learn how to do this without
bothering you.

Too bad I can not send you the data that we have since Dec. 30, 2008.
What we are looking at is data that showed her in remission for a
while. Then the drug regimen she was on loosing its effectiveness
which resulted in a relapse and now a new treatment plan which is
getting the disease under control. After looking at the real data
for her disease we are hoping that the flat portion of the curve from
your model will truly extend. Should that be the case then we would
have a new situation where the readings vary randomly within the
normal range until this set of drugs loose their effectiveness.

Returning to your analyses for sheet 2 how did you compute Ao, t1/2,
k, and the b offset?

For the regression model the results are quite significant. I assume
you are fitting to the model from sheet2. Here again I need to figure
out what you setup and how you did it.

All help is really appreciated.

Paul


On Sun, 14 Jun 2009 12:05:48 -0700 (PDT), Herbert Seidenberg
> wrote:

>Excel 2007
>Added Data Analysis (Regression)
>and more.
>http://www.mediafire.com/file/jx2zaj...06_12_09c.xlsx

On Sat, 13 Jun 2009 21:09:11 -0700 (PDT), Herbert Seidenberg
> wrote:

>Excel 2007
>Inserted your data into my tables.
>A second order rate equation with offset
>still gives the best fit.
>See Sheet2/Chart2.
>http://www.mediafire.com/file/kn4jey...06_12_09b.xlsx


That is the exact same curve I got, except mine was over 11 days (0
through 10) and yours is 80 days in ten day increments. Same exact plot
though.

On Sat, 13 Jun 2009 21:09:11 -0700 (PDT), Herbert Seidenberg
> wrote:

>Excel 2007
>Inserted your data into my tables.
>A second order rate equation with offset
>still gives the best fit.
>See Sheet2/Chart2.
>http://www.mediafire.com/file/kn4jey...06_12_09b.xlsx


I fooled with your axis formatting...

http://download234.mediafire.com/ly3...eEquation.xlsx

Herbert,

Thanks once more.

A few more questions:

1- What happens when I get actual data beyond day 70? Every Tuesday
there is a blood test to measure Free Kappa Lite chains to see if the
treatment protocol is still working. This Friday we will get the real
value of Kappa for day 35.

2- What is the effect of additional data on the coefficients Ao, t1/2,
k and the offset b. I changed the value for day 35 to see what would
change and so far it only changed the value r4c7.

Paul




On Sun, 14 Jun 2009 18:48:04 -0700, Archimedes' Lever
> wrote:

>On Sat, 13 Jun 2009 21:09:11 -0700 (PDT), Herbert Seidenberg
> wrote:
>
>>Excel 2007
>>Inserted your data into my tables.
>>A second order rate equation with offset
>>still gives the best fit.
>>See Sheet2/Chart2.
>>http://www.mediafire.com/file/kn4jey...06_12_09b.xlsx
>
>
>I fooled with your axis formatting...
>
>http://download234.mediafire.com/ly3...eEquation.xlsx