« previous next »

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

According to the American College of Allergy, Asthma & Immunology, more than 50 million Americans have some kind of food allergy. Food allergies affect between 4 and 6% of children, and 4% of adults, according to the CDC. The most common food allergies include shellfish, peanuts, walnuts, fish, eggs, milk, and soy.

Did you know?

Human neurons are so small that they require a microscope in order to be seen. However, some neurons can be up to 3 feet long, such as those that extend from the spinal cord to the toes.

Did you know?

In 1844, Charles Goodyear obtained the first patent for a rubber condom.

Did you know?

By definition, when a medication is administered intravenously, its bioavailability is 100%.

Did you know?

In inpatient settings, adverse drug events account for an estimated one in three of all hospital adverse events. They affect approximately 2 million hospital stays every year, and prolong hospital stays by between one and five days.

Each subculture provides its members with values and distinctive ways of viewing the world. What ... Each subculture provides its members with values and distinctive ways of viewing the world. What ...
How to find the second derivative of a function How to find the second derivative of a function
. Calculate the net electric field at point B . Calculate the net electric field at point B
Find the derivative by using the quotient rule. Find the derivative by using the quotient rule.
To find the derivative use product rule To find the derivative use product rule
Gray Morris's Calculate with Confidence, Canadian Edition, 2nd Edition Gray Morris's Calculate with Confidence, Canadian Edition, 2nd Edition
Video: Origin of organelles Animation

For a complete list of videos, visit our video library