SIMPSON'S RULE WITH EXCEL, Study notes of Organic Chemistry

Download SIMPSON'S RULE WITH EXCEL and more Study notes Organic Chemistry in PDF only on Docsity!

SIMPSON’S RULE WITH

EXCEL

John Patterson

Faculty Sponsor: Gail Illich, M.S.

ABSTRACT

• Simpsons rule is a numerical method in calculus.
• It approximates the integral of a function between two limits of ‘a’ and ‘b’.
• It helps find the area under a parabola but above the x axis.

THE INTEGRAL WE ARE EVALUATING

DECIDING X VALUES USING N. In order to decide which values of X we need for our Simpson's rule equation we need to look at the lower limit a and upper limit b values. In our case we will be using zero to twelve with the N(terval) value being four intervals {3, 6, 9, and 12}. Calculate delta x

• Input our equation as shown below 1/(1+x^2).
• Let X = the box that Zero is in.
• In this case that will be E2.

• GRAB THE BLACK DOT ON THE BOTTOM CORNER OF THE BOX AND DRAG DOWN TO AUTOFILL THE EQUATION AND ITS CORRESPONDING BOXES IN THE COLUMN TO THEIR LEFT.

• Let G10 = B4/3 multiplied by the sum of the values in H2 through H

• Some of this work is cited Directly from Gail Illich specifically how to do the Simpson’s rule on Excel.
• The Organic Chemistry Tutor. “Simpson’s Rule & Numerical Integration.” YouTube , uploaded by The Organic Chemistry Tutor, 13 Mar. 2018, www.youtube.com/watch?v=7EqRRuh-5Lk&t=183s.
• “Numerical Integration Utility.” Zweigmedia , www.zweigmedia.com/RealWorld/integral/integral.html. Accessed 20 Apr. 2021.
• Gifs were created by me using the IMGPlay app via Android.
• Line Graph was created by me via Microsoft Paint application.