« previous next »

Author Question: How do I calculate a derivative in excel when having x and y values? (Read 1378 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?

When taking monoamine oxidase inhibitors, people should avoid a variety of foods, which include alcoholic beverages, bean curd, broad (fava) bean pods, cheese, fish, ginseng, protein extracts, meat, sauerkraut, shrimp paste, soups, and yeast.

Did you know?

It is believed that the Incas used anesthesia. Evidence supports the theory that shamans chewed cocoa leaves and drilled holes into the heads of patients (letting evil spirits escape), spitting into the wounds they made. The mixture of cocaine, saliva, and resin numbed the site enough to allow hours of drilling.

Did you know?

Drying your hands with a paper towel will reduce the bacterial count on your hands by 45–60%.

Did you know?

In women, pharmacodynamic differences include increased sensitivity to (and increased effectiveness of) beta-blockers, opioids, selective serotonin reuptake inhibitors, and typical antipsychotics.

Did you know?

The horizontal fraction bar was introduced by the Arabs.

Single-dose drug administration. Pharmacokinetic values for this drug are as follows: onset of ... Single-dose drug administration. Pharmacokinetic values for this drug are as follows: onset of ...
How to find the constant (C) after finding the anti-derivative How to find the constant (C) after finding the anti-derivative
How to calculate theoretical probability How to calculate theoretical probability
Excel Interpretation Excel Interpretation
Calculate the net field at the location of q 3 Calculate the net field at the location of q 3
Find the derivative using the product rule Find the derivative using the product rule
Video: Protein catabolism - deamination

For a complete list of videos, visit our video library