How to Solve by Simpson's Rule With Excel

By Peter Flom; Updated April 24, 2017

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.

About the Author

Peter Flom is a statistician and a learning-disabled adult. He has been writing for many years and has been published in many academic journals in fields such as psychology, drug addiction, epidemiology and others. He holds a Ph.D. in psychometrics from Fordham University.