Results 1 to 5 of 5

Math Help - eulers method with excel...

  1. #1
    Senior Member
    Joined
    Aug 2009
    Posts
    349

    eulers method with excel...

    ok i have to do a bunch of problems on excel using Euler's method, modified Euler's and fourth order Runge kutta method? i was wondering if anyone knew of a good tutorial.

    thanks
    Follow Math Help Forum on Facebook and Google+

  2. #2
    Grand Panjandrum
    Joined
    Nov 2005
    From
    someplace
    Posts
    14,972
    Thanks
    4
    Quote Originally Posted by slapmaxwell1 View Post
    ok i have to do a bunch of problems on excel using Euler's method, modified Euler's and fourth order Runge kutta method? i was wondering if anyone knew of a good tutorial.

    thanks
    This hardly needs a tutorial does it? You need one row per epoc, the first row containing the initial conditions. The first column should contain the times corresponding to the epocs, there should be a named variable containing the nominal step size h.There should be columns for the derivatives and estimates at the computationall nodes to give in the last column the estimate of the solution at the time corresponding to the epoc.

    CB
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Senior Member
    Joined
    Aug 2009
    Posts
    349
    it probably doesnt, i was just having a hard time getting excel to back up what i was doing on paper. i solved the differential equation using bernouli, but as i went from euler's method to runge kutta my numbers were getting worse. ok so my equation was y'=2y-y^2.

    using bernouli or even separation of variables, i found....



    so Y(1) was approximately 1.29757....

    euler method was ok, i found Y(1) was 1.27 something....

    my problem came when i tried using improved euler and runge kutta
    Follow Math Help Forum on Facebook and Google+

  4. #4
    Grand Panjandrum
    Joined
    Nov 2005
    From
    someplace
    Posts
    14,972
    Thanks
    4
    Quote Originally Posted by slapmaxwell1 View Post
    it probably doesnt, i was just having a hard time getting excel to back up what i was doing on paper. i solved the differential equation using bernouli, but as i went from euler's method to runge kutta my numbers were getting worse. ok so my equation was y'=2y-y^2.

    using bernouli or even separation of variables, i found....



    so Y(1) was approximately 1.29757....

    euler method was ok, i found Y(1) was 1.27 something....

    my problem came when i tried using improved euler and runge kutta
    This is fairly simple to do, and to demonstrate face to face, but over a text interface almost impossible, have you tried searching on youTube for a demo/tutorial?

    I have checked what you call improved Euler and with a time step of 0.1, and initial condition f(0)=2/5 get f(1)~=1.285 (see attachment).

    CB
    Attached Files Attached Files
    Last edited by CaptainBlack; May 19th 2011 at 02:52 AM.
    Follow Math Help Forum on Facebook and Google+

  5. #5
    Senior Member
    Joined
    Aug 2009
    Posts
    349
    Quote Originally Posted by CaptainBlack View Post
    This is fairly simple to do, and to demonstrate face to face, but over a text interface almost impossible, have you tried searching on youTube for a demo/tutorial?

    I have checked what you call improved Euler and with a time step of 0.1, and initial condition f(0)=2/5 get f(1)~=1.285 (see attachment).

    CB

    i haven't checked you tube, but i will take a look at it as well as the attachment.
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Eulers Method
    Posted in the Calculus Forum
    Replies: 4
    Last Post: November 12th 2011, 02:36 AM
  2. Eulers Method Question
    Posted in the Differential Equations Forum
    Replies: 1
    Last Post: January 27th 2010, 10:53 PM
  3. [SOLVED] Eulers Method
    Posted in the Calculus Forum
    Replies: 3
    Last Post: October 29th 2009, 04:18 AM
  4. eulers method...
    Posted in the Differential Equations Forum
    Replies: 1
    Last Post: March 4th 2009, 05:09 PM
  5. Eulers method fo dif eq..
    Posted in the Calculus Forum
    Replies: 1
    Last Post: March 7th 2008, 08:03 AM

Search Tags


/mathhelpforum @mathhelpforum