How do you set up the spreadsheet to compute y-values for the second-order differential equation y'' = xy' + y according to the chapter?
To set up the spreadsheet for computing y-values for the differential equation y'' = xy' + y, you need to create several columns: iteration numbers, x-values, computed y-values, y'-values, y''-values, exact values, and percentage errors. Enter the initial values and formulas as specified in the source, and fill down the columns to compute the values iteratively.
Begin by entering the iteration numbers in column A, starting from 0. In column B, enter the initial x-value (0) and use a formula to increment by the step length (0.2) for subsequent cells. In column C, input the initial y-value (1) and use the formula for y-values based on the differential equation. Column D will contain the initial y'-value (0) and a formula to compute the new y'-values. Column E is for y''-values calculated from the differential equation. Column F will have the exact solution values, and column G will compute the percentage errors based on the exact and computed y-values. Make sure to copy the formulas down the respective columns to fill in the values for each iteration.
Key points
- Set up columns for iteration numbers, x-values, y-values, y'-values, y''-values, exact values, and errors.
- Enter initial values and formulas as specified in the source.
- Use the increment value for x to fill down the x-values column.
- Compute y-values using the specified formula for the differential equation.
- Calculate y'-values and y''-values based on previous results.
- Include exact values for comparison and calculate percentage errors.
Related questions
Advanced Engineering Mathematics
Stroud, K. A, Booth, Dexter J Stroud etc.
4th ed. · Industrial Press, Inc.