Trendline to an asymptote

Mike Milligan
Guest
Posts: n/a

 13th Dec 2006
I am looking for an exponential falloff trendline tool. I have a chart that
is plotting temperature data of a part that is cooling down (or heating up)
and will eventually arrive at a stable temperature. I'd like to use a
trendline to predict that stable temperature. Anyone have one, or know how
to use Excel built-in to the same end?

Mike

Bernard Liengme
Guest
Posts: n/a

 13th Dec 2006
Newton's Law of Cooling may be written as
T(t) =S + (T0 - S)e -kt, where k is a constant that depends on the shape of the object, wind speed, etc., T0 is initial temperature of the object at time =0, S is constant temperature of the surroundings, and T(t) is the temperature of the object after t minutes.
Excel has no trendline model to fit this. But Solver can do a fine job. If you are interested I can send you a file showing how. Reply to my private email address (not the group)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Mike Milligan" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
>I am looking for an exponential falloff trendline tool. I have a chart that
> is plotting temperature data of a part that is cooling down (or heating up)
> and will eventually arrive at a stable temperature. I'd like to use a
> trendline to predict that stable temperature. Anyone have one, or know how
> to use Excel built-in to the same end?
>
> Mike
>
>

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post =?Utf-8?B?Y3N1c2JnaXJsMDc=?= Microsoft Excel Charting 1 22nd Jan 2006 03:24 PM =?Utf-8?B?VG9ueUBXYXNoaW5ndG9u?= Microsoft Excel Misc 1 4th Jan 2006 02:49 AM =?Utf-8?B?TGVlZGVy?= Microsoft Powerpoint 2 22nd Mar 2005 04:13 PM =?Utf-8?B?V2lsbGlhbXM=?= Microsoft Powerpoint 0 8th Feb 2005 05:41 PM =?Utf-8?B?U2hlcnJ5?= Microsoft Powerpoint 5 11th Nov 2004 04:35 AM

Features