Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
First Derivative
I wish to know, how do we find out "First Derivative" in MS Excel?
Well there is any inbuilt function is available for MS Excel?? if any please let me know |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
First Derivative
Chetan wrote...
I wish to know, how do we find out "First Derivative" in MS Excel? Well there is any inbuilt function is available for MS Excel?? if any please let me know No, there's no general derivative function. If you had a polynomial with coefficents in a range named COEF, and the polynomial were evaluatedd as (x<0) =SUMPRODUCT(COEF,x^(ROWS(COEF)-MIN(ROW(COEF)))) you could calculate the derivative at x using =SUMPRODUCT(COEF,(ROWS(COEF)-MIN(ROW(COEF)), x^(ROWS(COEF)-MIN(ROW(COEF))-1)) If you had a table of x and f(x) values (in X and Y columns, respectively) with the x values uniformly graduated, you could calculate the numerical derivative for, say, X99 using the formula =(Y97-Y101-8*(Y98-Y100))/12/(X99-X98) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
First Derivative
Hi harlan!
Thank you for the post, i have x and f (x) data, i will try for numerical differenciation. Thank you very much. chetan "Harlan Grove" wrote: Chetan wrote... I wish to know, how do we find out "First Derivative" in MS Excel? Well there is any inbuilt function is available for MS Excel?? if any please let me know No, there's no general derivative function. If you had a polynomial with coefficents in a range named COEF, and the polynomial were evaluatedd as (x<0) =SUMPRODUCT(COEF,x^(ROWS(COEF)-MIN(ROW(COEF)))) you could calculate the derivative at x using =SUMPRODUCT(COEF,(ROWS(COEF)-MIN(ROW(COEF)), x^(ROWS(COEF)-MIN(ROW(COEF))-1)) If you had a table of x and f(x) values (in X and Y columns, respectively) with the x values uniformly graduated, you could calculate the numerical derivative for, say, X99 using the formula =(Y97-Y101-8*(Y98-Y100))/12/(X99-X98) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
First Derivative
Why not use LINEST to find the polynomial of best fit ( see
http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm) then follow Harlan's idea. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Chetan" wrote in message ... Hi harlan! Thank you for the post, i have x and f (x) data, i will try for numerical differenciation. Thank you very much. chetan "Harlan Grove" wrote: Chetan wrote... I wish to know, how do we find out "First Derivative" in MS Excel? Well there is any inbuilt function is available for MS Excel?? if any please let me know No, there's no general derivative function. If you had a polynomial with coefficents in a range named COEF, and the polynomial were evaluatedd as (x<0) =SUMPRODUCT(COEF,x^(ROWS(COEF)-MIN(ROW(COEF)))) you could calculate the derivative at x using =SUMPRODUCT(COEF,(ROWS(COEF)-MIN(ROW(COEF)), x^(ROWS(COEF)-MIN(ROW(COEF))-1)) If you had a table of x and f(x) values (in X and Y columns, respectively) with the x values uniformly graduated, you could calculate the numerical derivative for, say, X99 using the formula =(Y97-Y101-8*(Y98-Y100))/12/(X99-X98) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
First Derivative
Thank you Bernard!
I will encorporate your words of wisdom to my calculations tabk you both again chetan "Bernard Liengme" wrote: Why not use LINEST to find the polynomial of best fit ( see http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm) then follow Harlan's idea. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Chetan" wrote in message ... Hi harlan! Thank you for the post, i have x and f (x) data, i will try for numerical differenciation. Thank you very much. chetan "Harlan Grove" wrote: Chetan wrote... I wish to know, how do we find out "First Derivative" in MS Excel? Well there is any inbuilt function is available for MS Excel?? if any please let me know No, there's no general derivative function. If you had a polynomial with coefficents in a range named COEF, and the polynomial were evaluatedd as (x<0) =SUMPRODUCT(COEF,x^(ROWS(COEF)-MIN(ROW(COEF)))) you could calculate the derivative at x using =SUMPRODUCT(COEF,(ROWS(COEF)-MIN(ROW(COEF)), x^(ROWS(COEF)-MIN(ROW(COEF))-1)) If you had a table of x and f(x) values (in X and Y columns, respectively) with the x values uniformly graduated, you could calculate the numerical derivative for, say, X99 using the formula =(Y97-Y101-8*(Y98-Y100))/12/(X99-X98) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
derivative plot | Charts and Charting in Excel | |||
How do I plot the derivative of a curve in Excel? | Excel Worksheet Functions |