« previous next »

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

For pediatric patients, intravenous fluids are the most commonly cited products involved in medication errors that are reported to the USP.

Did you know?

Once thought to have neurofibromatosis, Joseph Merrick (also known as "the elephant man") is now, in retrospect, thought by clinical experts to have had Proteus syndrome. This endocrine disease causes continued and abnormal growth of the bones, muscles, skin, and so on and can become completely debilitating with severe deformities occurring anywhere on the body.

Did you know?

Drug-induced pharmacodynamic effects manifested in older adults include drug-induced renal toxicity, which can be a major factor when these adults are experiencing other kidney problems.

Did you know?

Giardia is one of the most common intestinal parasites worldwide, and infects up to 20% of the world population, mostly in poorer countries with inadequate sanitation. Infections are most common in children, though chronic Giardia is more common in adults.

Did you know?

Sperm cells are so tiny that 400 to 500 million (400,000,000–500,000,000) of them fit onto 1 tsp.

How to calculate present value (Question 4) How to calculate present value (Question 4)
Derivative of a function Derivative of a function
Calculate the magnitude and direction of the resultant for Calculate the magnitude and direction of the resultant for
Find the derivative by using the chain rule - Solution Help Find the derivative by using the chain rule - Solution Help
Calculate the electron affinity for the formation of the hydride ion from the following ... Calculate the electron affinity for the formation of the hydride ion from the following ...
How to calculate the gain and loss gene numbers with low bootstrap of phylogenetic tree? How to calculate the gain and loss gene numbers with low bootstrap of phylogenetic tree?
Video: Introduction to Sleep Apnea

For a complete list of videos, visit our video library