Analisis Perbandingan Metode Trapesium, Simpson 1/3, dan Simpson 3/8 Berbasis Spreadsheet menggunakan Microsoft Excel untuk Aproksimasi Integral Numerik

Rahma Qudsi; Alzaber; Muhammad Rasyid Ridho

doi:10.62383/algoritma.v4i1.896

Authors

Rahma Qudsi Universitas Islam Riau
Alzaber Universitas Islam Riau
Muhammad Rasyid Ridho Universitas Islam Riau

DOI:

https://doi.org/10.62383/algoritma.v4i1.896

Keywords:

Error Convergence, Microsoft Excel, Numerical Integration, Simpson Method, Trapezoidal Rule

Abstract

This study analyzes the comparison of the Trapezoidal, Simpson 1/3, and Simpson 3/8 to approximate numerical integration using Microsoft Excel, with the variation of the interval . The test function is on the interval . Because it is smooth and lacks an elementary antiderivative, the results indicate that the Simpson Method outperforms the Trapezoidal method in accuracy. The Trapezoidal method yields absolute errors on the order of to , while Simpson 1/3 and 3/8 achieve to , with Simpson 1/3 performing best across all . These findings confirm the higher convergence order of Simpson methods ) vs . Excel implementation proves effective as an accessible learning tool for numerical methods, supporting integral computation in higher education. This research contributes to simplifying computational approaches for engineering applications and education, and opens up opportunities for more effective implementation of numerical methods in practical teaching. The results of this research are expected to enrich understanding of numerical applications in engineering and science.

Downloads

Download data is not yet available.

References

Abramowitz, M., & Stegun, I. A. (1964). Handbook of Mathematical Functions. NBS.

Ali, A. J., & Abbas, A. F. (2022). Applications of numerical integrations on the trapezoidal and Simpson’s methods to analytical and MATLAB solutions. Mathematical Modelling of Engineering Problems, 9(5), 1352-1358. https://doi.org/10.18280/mmep.090525

Atkinson, K. E. (1989). AN INTRODUCTION TO NUMERICAL ANALYSIS (Second ed.). John Wiley & Sons, Inc.

Burden, R. L., & Faires, J. D. (2011). Numerical Analysis (9th ed.). Richard Stratton.

Chapra, S. C., & Canale, R. P. (2010). Numerical Methods for Engineering (6th ed.). McGraw-Hill.

Chapra, S. C., & Canale, R. P. (2021). Numerical Methods for Engineers (7th ed.). McGraw-Hill Education.

Haidar, S. R., & Johnson, R. L. (2023). Comparative analysis of numerical integration methods for solving differential equations in engineering applications. Journal of Computational Engineering, 45(3), 203-217. https://doi.org/10.1016/j.jce.2023.07.017

Hotimah, H., Fadilatunnisa, M. Wulida, W. Hidayat, & D. Indriana. (2025). Perbandingan efektivitas metode pembelajaran luring dan daring terhadap pemahaman siswa. Jurnal Multidisiplin Ilmu Akademik, 2(1), 441-448. https://doi.org/10.61722/jmia.v2i1.3415

Kreyszig, E. (2011). ADVANCED ENGINEERING MATHEMATICS (10th ed.). John Wiley & Sons.

Pardede, B. H. R., Kusfa, B. D., & Tamba, L. T. (2024). Penerapan metode Trapesium, metode Simpson 1/3, dan metode Simpson 3/8 dalam integrasi numerik menggunakan software Matlab. Pentagon: Jurnal Matematika Dan Ilmu Pengetahuan Alam, 2(4), 24-31. https://doi.org/10.62383/pentagon.v2i4.268

Rahmalia, N. F., Munawaroh, M. P., & Wibowo, A. (2025). Perbandingan Matlab dan Microsoft Excel pada penyelesaian integral numerik dengan metode Simpson 1/3 dan 3/8. Math Didactic: Jurnal Pendidikan Matematika, 11(2), 89-104. https://doi.org/10.33654/math.v11i2.147

Salih, A. A. (2025). A comparative study of numerical approximation methods for integration: The trapezoidal method and Simpson’s method as a model. Libyan Journal of Medical and Applied Sciences, 3(2), 1-15. https://doi.org/10.64943/ljmas.v3i2.46

Suhendra, M. A., Assegaf, S., Robiyana, I., & Nurizati. (2024). Computational study of numerical integration in physics applications using trapezoidal and Simpson’s methods. TIME in Physics, 2(2), 85-95. https://doi.org/10.11594/timeinphys.2024.v2i2p85-95

Supriyono. (2002). Perbandingan kinerja penyelesaian integrasi numerik menggunakan metode Newton-Cotes (Metode Trapesium, Simpson ⅓ dan Integrasi Romberg). Thesis, STMIK AKAKOM Yogyakarta, Yogyakarta.

Ullah, M. A. (2015). Numerical integration and a proposed rule. American Journal of Engineering Research (AJER), 4(9), 120-123.