Question: Solve the question by using Excel Show the Excel Equation and sheets. I post the question on chegg i got the Excel sheet, but with
0.5 2) Use EXCEL to evaluate the approximate value of the above integral using trapezoidal rule with:n-2 4, 8 and 16. The true solution is: 0.478306. Compute the percentage error, where E l(analytical - numerical) 100 /analytical solution).Demonstrate convergence, which shows that the error decreases when you used more trapezoids. 3) Use EXCEL to compute value of the above (problem 2) integral using the Simpson's rule with n- 2, 4,8 and 16: compute the error and demonstrate convergence )Compare the error values estimated using n-2,4,8, 16 in problems 2 &3 and comment on the results
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
