How can I calculate instantaneous rate of change in excel?
I have a two columns of data in excel (x) and (y). I want to
calculate instantaneous rate of change for values in (y) with respect (x). How can I do this? X Y dy/dx 1 10 2 100 ? 3 1000 ? 4 10000 ? 5 100000 ? |
Answer: How can I calculate instantaneous rate of change in excel?
To calculate the instantaneous rate of change in Excel, you can use the slope function. Here are the steps:
That's it! You now have the instantaneous rate of change for each value in (y) with respect to (x). |
How can I calculate instantaneous rate of change in excel?
Hi,
Not exactly sure what your looking for but maybe: =IF(A2<0,B2/A2,"") copied down you need to check for a value in A2 because if A2 is empty then you get a #DIV/0! error. HTH Jean-Guy "nexxusvp" wrote: I have a two columns of data in excel (x) and (y). I want to calculate instantaneous rate of change for values in (y) with respect (x). How can I do this? X Y dy/dx 1 10 2 100 ? 3 1000 ? 4 10000 ? 5 100000 ? |
How can I calculate instantaneous rate of change in excel?
If I am not mistaken,
y=10^x Then... Dy/Dx =POWER(10,x)*LN(10) -- HTH :) Dana DeLouis Windows XP & Office 2003 "nexxusvp" wrote in message oups.com... I have a two columns of data in excel (x) and (y). I want to calculate instantaneous rate of change for values in (y) with respect (x). How can I do this? X Y dy/dx 1 10 2 100 ? 3 1000 ? 4 10000 ? 5 100000 ? |
How can I calculate instantaneous rate of change in excel?
Rather than B2/A2, the OP may have wanted =(B3-B2)/(A3-A2)
If the OP wants the gradient at a point, then the increments need to be made smaller. [dy/dx is the limit of (delta y/ delta x) as delta x tends to zero] -- David Biddulph "pinmaster" wrote in message ... Hi, Not exactly sure what your looking for but maybe: =IF(A2<0,B2/A2,"") copied down you need to check for a value in A2 because if A2 is empty then you get a #DIV/0! error. HTH Jean-Guy "nexxusvp" wrote: I have a two columns of data in excel (x) and (y). I want to calculate instantaneous rate of change for values in (y) with respect (x). How can I do this? X Y dy/dx 1 10 2 100 ? 3 1000 ? 4 10000 ? 5 100000 ? |
All times are GMT +1. The time now is 09:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com