Regression (I think) of Newton's Law of Cooling

[HalcyonStorm]

Homework Statement

Using a data logger, I have collected data for two cooling cups: the temperature (c) at 1 second intervals. My task was to model this data using two methods.

"METHOD 1: Use EXCEL or the regression analysis capability of your graphic calculator"
"METHOD 2: Find the constants in the model (A0 and k) by constructing a linear function relating lny and t."

I chose to use Excel for method 1. I have attached the spreadsheet.

Homework Equations

Newton's Law of Cooling: y=A0*e^kt

The Attempt at a Solution

I have attached the graphs that I have been able to produce (method 1) in a word document. I am unable to do method 2, as I'm really stuck for ideas.

Thank-you! Any help is much appreciated :)

 

[Mark44]

Homework Statement

Using a data logger, I have collected data for two cooling cups: the temperature (c) at 1 second intervals. My task was to model this data using two methods.

"METHOD 1: Use EXCEL or the regression analysis capability of your graphic calculator"
"METHOD 2: Find the constants in the model (A0 and k) by constructing a linear function relating lny and t."

I chose to use Excel for method 1. I have attached the spreadsheet.

Homework Equations

Newton's Law of Cooling: y=A0*e^kt

The Attempt at a Solution

I have attached the graphs that I have been able to produce (method 1) in a word document. I am unable to do method 2, as I'm really stuck for ideas.

Thank-you! Any help is much appreciated :)

For method 2, the idea is to find constants A₀ and k for which lny = kt + A₀. If you plot lny versus t, this equation represents a straight line.

 

[HalcyonStorm]

Thanks for your response!

Would it be safe for me to assume that (from y= mx + c), k is equal to m and A0 is equal to c?

 

[Mark44]

Thanks for your response!

Would it be safe for me to assume that (from y= mx + c), k is equal to m and A0 is equal to c?

Yes.

 

[TheoMcCloskey]

Be careful! - Its really "c = ln(A0)"

 

[Mark44]

Be careful! - Its really "c = ln(A0)"

No, not if the OP is working with the equation lny = kt + A₀.

 

[TheoMcCloskey]

No, not if the OP is working with the equation lny = kt + A0.

Yes, that is is correct, and I stand corrected. I was assumming the OP's original equation was, as he stated in "Relevant equations", of the form y = A_0 \cdot e^{kt}.