Need help in solving this in microsoft Excel

Question

Predict the concentration of y₁ & y₂ from 0 to 0.5 with step size of 0.1. Initial conditions

y₁(0)=52.29 and y₂(0)=83.82

𝑑𝑦₁/𝑑𝑡= -5y₁+ 3y₂

𝑑𝑦₂/𝑑𝑡= y₁ - 3y₂

Solve using:

a) Euler’s method (Excel) and plot

b) RK 4th order method (Excel) and plot

Fill the table

Euler (Excel) RK4th (Excel)

t y1 y2 y₁ y₂

0 52.2900 83.8200 52.2900 83.8200

0.1

0.2

0.3

0.4

0.5

Answer 1

For problems like these there are few ways to handle it. You could write a VBA code to embed the functions for you. You can google how to do that. But sometimes its easier to just do these things one step at a time. Here are two links that walk you through each method:

Euler: http://www.mathcs.richmond.edu/~caudill/localhome_links/m232/Excel/Euler_Lab1.pdf

RK4: https://www.youtube.com/watch?v=xKaQ_ESSLSM