How to Solve by Simpson's Rule With Excel

••• Hero Images/Hero Images/GettyImages

Simpson's rule is a method for evaluating definite integrals. Simpson's rule uses quadratic polynomials. It often provides more accurate estimates than the trapezoidal rule. If the function you are integrating can be evaluated in Excel, then you can implement Simpson's rule in Excel.

    Subtract the lower endpoint from the upper endpoint and divide by 2. For example, if you want to find the definite integral of cos(x) between 0 and pi/2 radians, subtract 0 from pi/2 and divide by 2 to get pi/4. (Radians are the usual method of measuring angles in calculus; Excel also assumes that angles are measured in radians).

    Enter column headers in Excel. Enter "value" in cell A1 and "function" in cell B1, where "function" is the function you are evaluating. In the example, put cos(x) in cell B1.

    Enter the lower endpoint, the midpoint and the upper endpoint of the integral in cells A2, A3 and A4 respectively. In the example, put 0 in cell A2, =PI/4 in cell A3 and =PI()/2 in cell A4.

    Use Excel to evaluate the function at these three points. In cell B2, enter =function(A2). In the example, put =COS(A2) in cell B2 and copy this to cells B3 and B4.

    Evaluate Simpson's rule. In cell A5, enter =(A3-A2)_(B2+4_B3+B4)/3. The result is the approximation of the integral by Simpson's rule.

Related Articles

How to Find Zeros of Functions in Excel
How to Draw an Array in Math
How to Do Sixth Grade Math Ratio Tables
How to Determine the Lattice Parameter of Zinc-Blende
How to Draw a Normal Distribution in Excel
How to Calculate Correlation Coefficient Between Two...
How to Find Lattice Constant
How to Subtract Matrices on Excel
How to Convert CM to Inches in Excel
How to Calculate Nernst Equations
How to Graph a Distribution for a T-Test
How to Calculate the Correlation Between Two Variables
How to Solve Linear Programming in Excel
How to Decrease Digits in Excel
How to Express "Divisible By" in Excel
How to Find the Area of a Parallelogram With Vertices
How to Do Algebra in Excel
How to Find the Vertices of an Ellipse
How to Solve for a Variable in a Trig Function
How to Find the X Intercept of a Function