« previous next »

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

The first successful kidney transplant was performed in 1954 and occurred in Boston. A kidney from an identical twin was transplanted into his dying brother's body and was not rejected because it did not appear foreign to his body.

Did you know?

Over time, chronic hepatitis B virus and hepatitis C virus infections can progress to advanced liver disease, liver failure, and hepatocellular carcinoma. Unlike other forms, more than 80% of hepatitis C infections become chronic and lead to liver disease. When combined with hepatitis B, hepatitis C now accounts for 75% percent of all cases of liver disease around the world. Liver failure caused by hepatitis C is now leading cause of liver transplants in the United States.

Did you know?

The Centers for Disease Control and Prevention (CDC) was originally known as the Communicable Disease Center, which was formed to fight malaria. It was originally headquartered in Atlanta, Georgia, since the Southern states faced the worst threat from malaria.

Did you know?

The human body's pharmacokinetics are quite varied. Our hair holds onto drugs longer than our urine, blood, or saliva. For example, alcohol can be detected in the hair for up to 90 days after it was consumed. The same is true for marijuana, cocaine, ecstasy, heroin, methamphetamine, and nicotine.

Did you know?

Hippocrates noted that blood separates into four differently colored liquids when removed from the body and examined: a pure red liquid mixed with white liquid material with a yellow-colored froth at the top and a black substance that settles underneath; he named these the four humors (for blood, phlegm, yellow bile, and black bile).

Lab values Lab values
How to calculate simple interest (Part 2) How to calculate simple interest (Part 2)
Calculate the magnitude and direction of the resultant for Calculate the magnitude and direction of the resultant for
Calculate the net field at the location of q 3 Calculate the net field at the location of q 3
Find the derivative by using the chain rule - Solution Help Find the derivative by using the chain rule - Solution Help
Use the power rule to find derivative Use the power rule to find derivative
Video: Inflammation and Fever

For a complete list of videos, visit our video library