Mathematics Question about Power Trend lines?

snowbeard

New Member
Joined
Mar 13, 2012
Messages
7
hello all, I am trying to fit a cooling graph with a trendline and I have found the power line to fit the best, as well as corresponding with Newton's law of cooling. However, I am not savvy enough to discuss how similar or dissimilar the two equations are! :confused:

the resulting equations from two different curves are as follows:

y=4305 x^-0.87733

y=4025 x^-0.91004


both fits have an R^2 of 0.996.

I am analyzing two scenarios of cooling the same object with three variables, one intended (the extraction of energy using water flow in one case, and no extraction in the other) and the others not under my control: different starting temperatures and different ambient temperatures. I need to understand if these are generally the same curve, or how very different are they? is there any statistical way to represent their relationship?



Thanks in advance for any help deciphering this!!!
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
Well, they are both power functions, so they are the same in that sense. You could calculate and plot the ratio between them:

y1 = a * x^b

y2 = b * x^c

y1/y2 = a/b * x^(b-c)

A​
B​
C​
D​
1​
T​
y1​
y2​
y1/y2​
2​
100​
75.7​
60.9​
1.24​
3​
200​
41.2​
32.4​
1.27​
4​
300​
28.9​
22.4​
1.29​
5​
400​
22.4​
17.2​
1.30​
6​
500​
18.5​
14.1​
1.31​
7​
600​
15.7​
11.9​
1.32​
 
Upvote 0
hmmm, that makes about as much sense to me as what I had before.. but I appreciate the help!! ;)

What I really want to know is if the two curves are significantly different from each other, or are they basically (statistically) the same? I want them to both be the same type of fit, but my real question is is the "slope" or "rate of cooling" different between the two?

Could you explain how I can use the ratio plot to assess my question?

Thanks tons for the help!!
 
Upvote 0
In my example, I used the variable b in both equations; it should have been just in the first (a and b for the first, c and d for the second).

I'm still not sure what you're asking. You can differentiate both equations to compare cooling rates.
 
Upvote 0
well, I'm a dunce at math, I made it thru my algebra courses years ago, but calculus kicked me in the head... I did very well in trig and geometry, but the laniguistics of advanced mathematics have escaped me. How would I differentiate the equations? :confused:
 
Upvote 0
If y = a*t^b, then dy/dt = a*b*t^(b-1). So,

A​
B​
C​
D​
E​
F​
G​
1​
T​
y1​
y2​
dy1/dt​
dy2/dt​
2​
100​
75.7​
60.9​
-0.66​
-0.55​
B2: =4305 * A2 ^ -0.87733
3​
200​
41.2​
32.4​
-0.18​
-0.15​
C2: =4025 * A2 ^ -0.91004
4​
300​
28.9​
22.4​
-0.08​
-0.07​
D2: =4305 * (-0.87733) * A2 ^ (-0.87733 - 1)
5​
400​
22.4​
17.2​
-0.05​
-0.04​
E2: =4025 * (-0.91004) * A2 ^ (-0.91004 - 1)
6​
500​
18.5​
14.1​
-0.03​
-0.03​
7​
600​
15.7​
11.9​
-0.02​
-0.02​
 
Upvote 0

Forum statistics

Threads
1,214,790
Messages
6,121,608
Members
449,038
Latest member
apwr

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top