https://www.instructables.com/id/Spreadsheet-Calculus-Derivatives-and-Integrals/

http://www.engineerexcel.comumerical-integration-of-tabular-data-in-excel/

As we discussed in class, when we Googled, "Numerical integration Excel" the first couple of results were https://www.instructables.com/id/Spreadsheet-Calculus-Derivatives-and-Integrals and, http://www.engineerexcel.comumerical-integration-of-tabular-data-in-excel/ The first website is based on the work from a student group at University of British Columbia They took a function (a simple one) and integrated it both analytically (plugged numbers into the closed form integral) and digitally The equation isY(x) 2x3 + 6x2 - 12x +4 Part a: Use your knowledge of the calculus to integrate this equation. Write this equation as text somewhere in your spreadsheet. Part b: Let's compare the standard integration to the trapezoidal method (which is shown in the second link above. Also, let's compute both the absolute error of the techniques as well as the percentage error. You should get something like this: A. y(x)dx = digital Digital integral integral y(x)dx % error Exact std, method (trapezoid error (std error %error trap (x)meth y(i-1) dela(x) method) meth) (trap)std meth meth -4.9 -4.8 36.0 -28.4 21.3 0.00 3.22 5.70 0.00 -3.60 6.44 0.00 3.22 5.71 0.00 0.0000 0.38 0.0040-10.61% -0.11% 0.74 0.0078-11.49% -0.12% As we discussed in class, when we Googled, "Numerical integration Excel" the first couple of results were https://www.instructables.com/id/Spreadsheet-Calculus-Derivatives-and-Integrals and, http://www.engineerexcel.comumerical-integration-of-tabular-data-in-excel/ The first website is based on the work from a student group at University of British Columbia They took a function (a simple one) and integrated it both analytically (plugged numbers into the closed form integral) and digitally The equation isY(x) 2x3 + 6x2 - 12x +4 Part a: Use your knowledge of the calculus to integrate this equation. Write this equation as text somewhere in your spreadsheet. Part b: Let's compare the standard integration to the trapezoidal method (which is shown in the second link above. Also, let's compute both the absolute error of the techniques as well as the percentage error. You should get something like this: A. y(x)dx = digital Digital integral integral y(x)dx % error Exact std, method (trapezoid error (std error %error trap (x)meth y(i-1) dela(x) method) meth) (trap)std meth meth -4.9 -4.8 36.0 -28.4 21.3 0.00 3.22 5.70 0.00 -3.60 6.44 0.00 3.22 5.71 0.00 0.0000 0.38 0.0040-10.61% -0.11% 0.74 0.0078-11.49% -0.12%