« previous next »

Author Question: How do I calculate a derivative in excel when having x and y values? (Read 978 times)

Jones

  • Full Member
  • ***
  • Posts: 145
on: Jun 19, 2013
I have two columns in Excel, one column being x values and the other being y values. How can I calculate the derivative and second derivative based on this information? Ultimately, I am looking to find the point on my graph at which the line is increasing and a decreasing rate.


Joesy

  • Guest
Reply #1 on: Jun 19, 2013
How far apart are your x values?  You can approximate the derivative by using the limit definition (i.e. (f(x+h) - f(x))/h as h goes to 0), which is basically the slope formula for a really small delta-x.  So say you have x's in column A and y's in column B.  Make a 3rd column for the first derivative and set the first value to be =(B2-B1)/(A2-A1) and drag that all the way down.  Then make a fourth column for the second derivative and use the formula (C2-C1)/(A2-A1), and drag that down.

Again this only works if your x values are close together!  The closer they are, the better.
« Last Edit: Jun 18, 2018 by Celeste »


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

Pregnant women usually experience a heightened sense of smell beginning late in the first trimester. Some experts call this the body's way of protecting a pregnant woman from foods that are unsafe for the fetus.

Did you know?

Increased intake of vitamin D has been shown to reduce fractures up to 25% in older people.

Did you know?

After a vasectomy, it takes about 12 ejaculations to clear out sperm that were already beyond the blocked area.

Did you know?

Cytomegalovirus affects nearly the same amount of newborns every year as Down syndrome.

Did you know?

Urine turns bright yellow if larger than normal amounts of certain substances are consumed; one of these substances is asparagus.

Single-dose drug administration: pharmacokinetic values for this drug are as follows: onset of actio Single-dose drug administration: pharmacokinetic values for this drug are as follows: onset of actio
Baseline Pulse, Respiration, and Blood Pressure Values from Birth to Adolescence Baseline Pulse, Respiration, and Blood Pressure Values from Birth to Adolescence
How to determine an exponential relation from a table of values How to determine an exponential relation from a table of values
Derivative using delta method Derivative using delta method
Use the power rule to find derivative Use the power rule to find derivative
Probability Values of Chi-Square Analysis Probability Values of Chi-Square Analysis
Video: Introduction to Sleep Apnea

For a complete list of videos, visit our video library