If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 Need to fit a trendline to a Negative Exponential set of data
 Author Name Remember Me? Password
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

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

 Thread Tools Display Modes
#11
June 14th 09, 08:05 PM posted to microsoft.public.excel.charting
 Herbert Seidenberg external usenet poster Posts: 1,180
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

 Ads
#12
June 14th 09, 08:55 PM posted to microsoft.public.excel.charting
 external usenet poster Posts: 10
Need to fit a trendline to a Negative Exponential set of data

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

#13
June 15th 09, 02:48 AM posted to microsoft.public.excel.charting
 Archimedes' Lever external usenet poster Posts: 63
Need to fit a trendline to a Negative Exponential set of data

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.
#14
June 15th 09, 02:48 AM posted to microsoft.public.excel.charting
 Archimedes' Lever external usenet poster Posts: 63
Need to fit a trendline to a Negative Exponential set of data

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
#15
June 16th 09, 12:07 AM posted to microsoft.public.excel.charting
 external usenet poster Posts: 10
Need to fit a trendline to a Negative Exponential set of data

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

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 Similar Threads Thread Thread Starter Forum Replies Last Post Fitting data with a negative exponential [email protected] Excel Worksheet Functions 0 June 11th 09 02:22 AM Exponential trendline offset drjulianof Charts and Charting in Excel 1 January 20th 06 08:50 PM Exponential trendline offset drjulianof Charts and Charting in Excel 0 January 20th 06 07:59 PM Solver vs. Exponential Trendline jcoleman52 Excel Discussion (Misc queries) 2 December 21st 05 08:39 PM saving exponential to text data PTL Setting up and Configuration of Excel 1 February 15th 05 01:53 AM

All times are GMT +1. The time now is 08:38 AM.

 - Contact Us - ExcelBanter forum home - FAQ - Links - Privacy Statement - Top

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright ©2004-2013 ExcelBanter.
The comments are property of their posters.