Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

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

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. ...

Typology: Study notes

2021/2022

Uploaded on 09/27/2022

madbovary
madbovary 🇬🇧

3.9

(13)

244 documents

1 / 11

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
SIMPSON’S RULE WITH
EXCEL
John Patterson
Faculty Sponsor: Gail Illich, M.S.
pf3
pf4
pf5
pf8
pf9
pfa

Partial preview of the text

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.