« previous next »

Author Question: How do I calculate a derivative in excel when having x and y values? (Read 1281 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 use of salicylates dates back 2,500 years to Hippocrates’s recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

Did you know?

There are major differences in the metabolism of morphine and the illegal drug heroin. Morphine mostly produces its CNS effects through m-receptors, and at k- and d-receptors. Heroin has a slight affinity for opiate receptors. Most of its actions are due to metabolism to active metabolites (6-acetylmorphine, morphine, and morphine-6-glucuronide).

Did you know?

When blood is deoxygenated and flowing back to the heart through the veins, it is dark reddish-blue in color. Blood in the arteries that is oxygenated and flowing out to the body is bright red. Whereas arterial blood comes out in spurts, venous blood flows.

Did you know?

Hyperthyroidism leads to an increased rate of metabolism and affects about 1% of women but only 0.1% of men. For most people, this increased metabolic rate causes the thyroid gland to become enlarged (known as a goiter).

Did you know?

Fungal nail infections account for up to 30% of all skin infections. They affect 5% of the general population—mostly people over the age of 70.

Blue in a range of values Blue in a range of values
Congruence among values, beliefs, and role requirements supports the development of empowered ... Congruence among values, beliefs, and role requirements supports the development of empowered ...
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 regular payments or deposits using the annuity formula (Question 1) How to calculate regular payments or deposits using the annuity formula (Question 1)
How to calculate RRSP using the annuity formula How to calculate RRSP using the annuity formula
Derivative Help Derivative Help
Video: Embryonic development - Week 3

For a complete list of videos, visit our video library