dy dt y 6t y 0 5 In this question we will use a spreadsheet to approximate the value y 1 The picture below shows a spreadsheet

Question

dy dt y 6t y 0 5 In this question we will use a spreadsheet to approximate the value y 1 The picture below shows a spreadsheet being used to implement a linear approximation scheme ie Euler s method with initial value y0 y 0 5 and a step size of 0 1 to make such an approximation in 10 steps A downwards arrow indicates that the contents from the cell above will be dragged down Column B holds values of t Column A holds approximations of y t and Column C holds approximations of y t a Which entry should go in cell C1 A B1 0 1 B B1 1 C A1 5 B1 D A1 0 1 6 B1 E A1 B1 F A1 6 B1 c Which entry should go in cell B2 A 0 B 1 C B1 0 1 D A1 6 C1 E A1 6 B1 F C1 0 1 b Which entry should go in cell A2 A A1 0 1 B A1 0 1 B1 C 0 1 D B1 0 1 C1 E A1 0 1 C1 F A1 6 B1 1 2 3 4 5 67892 10 A 5 B 0 C

Kunduz · Accepted Answer

Click to see the answer