Im trying to solve a problem where I have to use Eulers meth
I\'m trying to solve a problem where I have to use Euler\'s method.
So I got
Y1=Y0+0.01(0+1)
Y2=Y1+0.01(0.01^2+Y1^2)
Y3=Y2+0.01(0.02^2+Y2^2)
Y4=Y3+0.01(0.03^2+Y3^2)
and so on..
I just don\'t know how to use excel...
What is Y80 and Y100?
Solution
Here we use the related formula in EXCEL that if the formula for Y0 is filled in cell A1 and formula related to term Y1 is entered in cell A2, then the related formula that will compute any corresponding value of Y will be given as :
A3=A1+0.01((0.03)^2+A1)
where A3 is the cell where you will fill value of Y80 or Y100.
So in short, you just form a formula, based on given formula, to calculate any of Y0, or Y1 or Y2 and copy this cell`s formula in any of the cells ,where you want to put the values of Y80 and Y100 and these two values will be reflected in that cell itself, based on that copied formula.
Answer
