1 In this question we will use a spreadsheet to approximate

Last updated: 11/25/2023

1 In this question we will use a spreadsheet to approximate the value y 1 The picture below shows a spreadsheet being usec 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 234 56 789 10 dy dt y 6t A 5 B 0 y 0 5 C Now using a spreadsheet or otherwise make the following approximations of y 1 for decreasing step sizes At Give your answers correct to at least 3 decimal places a Using Euler s method with 1 step t 1 starting at y 0 5 we find y 1 ANSWER b Using Euler s method with 2 steps t 1 2 starting at y 0 5 we find y 1 ANSWER c Using Euler s method with 10 steps t 1 10 starting at y 0 5 we find y 1 Answer