Metode Interpolasi Newton dengan Selisih Terbagi Menggunakan Python dan Excel: Studi Efisiensi dan Visualisasi
Abstract
Interpolation is one of the numerical methods used to estimate the value of a function between known data points. One commonly used technique is Newton's divided difference method. This study aims to explore the implementation of this method using two applications, namely Microsoft Excel and Python, and to compare their accuracy, efficiency, and ease of use. The method employed is a descriptive quantitative case study with data consisting of four points (x, f(x)), and it calculates the approximate function value at the point x=2.5. The calculations were performed manually in Excel and automatically through a Python script. The results show that both applications produced the same interpolation value, f(2.5) = 13.3125, with zero error. The graphical visualization in both applications also aids in understanding the function's approximation. Excel is rated superior in ease of use and initial visualization, while Python is more flexible for processing large-scale data and automation. This study recommends the complementary use of both learning and advanced numerical analysis.
References
Abdullah, D., Millenia, D., Nusfiana, D., Ariance, E., & Krisnawati, F. (2016). Persamaan dan Perbedaan Microsoft Excel.
Almira, Z., Yundari, & Im’roah, N. (2023). Implementasi Metode Polinomial Newton Gregory untuk Mengestimasi Produksi Tanaman Biofarmaka di Kalimantan Barat. Jurnal EurekaMatika, 11(1), 69–78. https://ejournal.upi.edu/index.php/JEM
Arvi, S., Triadi, I. S., Putri, Z., & Lubis, R. A. (2024). Penggunaan Python dalam Pengerjaan Induksi Matematika. Bilangan : Jurnal Ilmiah Matematika, Kebumian Dan Angkasa, 2(5). https://doi.org/https://doi.org/10.62383/bilangan.v2i5.251
Astuti, L. W., & Ambarwati, L. (2015). Perbandingan Metode Lagrange dan Metode Newton pada Interpolasi Polinomial dalam Mengestimasi Harga Saham.
Bashier, E. B. M. (2020). Practical Numerical and Scientific Computing With MATLAB and Python. Taylor & Francis Group. http://www.taylorandfrancis.com
Cheong, T. H., & Gaik, T. K. (2016). Newton ’s Divided Difference Interpolation Using Scientific Calculator. Engineering and Industrial Applications 2016 (ICoMEIA2016), November. https://doi.org/10.1063/1.4965222
Clinton, M. R., & Sengkey, R. (2019). Purwarupa Sistem Daftar Pelanggaran Lalulintas Berbasis Mini-Komputer Raspberry Pi. Teknik Elektro Dan Komputer, 8(3), 181–192.
Das, B., & Chakrabarty, D. (2016). Newton ’s Divided Difference Interpolation Formula : Representation of Numerical Data by a Polynomial Curve. International Journal of Mathematics Trends and Technology (IJMTT), 35(3), 197–203. https://doi.org/10.14445/22315373/IJMTT-V35P528
Fuhg, J. N., Fau, A., & Nackenhorst, U. (2021). State ‑ of ‑ the ‑ Art and Comparative Review of Adaptive Sampling Methods for Kriging. Archives of Computational Methods in Engineering, 28(4), 2689–2747. https://doi.org/10.1007/s11831-020-09474-6
Heinold, B. (2019). An Intuitive Guide to Numerical Methods. Department of Mathematics and Computer Science Mount St. Mary’s University.
Hizburohmah, S. F., & Puspitasari, T. (2023). Implementasi Google Collabs pada Metode Numerik (E. Setiawan (ed.)). Eureka Media Aksara.
J, M. V., & A, S. (2018). Newton ’ s Divided Difference Interpolating Polynomial Approach for Multi-choice Indefinite Quadratic Transportation Problem. International Journal of Pure and Applied Mathematics, 118(6), 243–251.
Maharani, S., Nusantara, T., Asari, A. R., & Qohar, A. (2020). Computational thinking (Pemecahan Masalah di Abad ke-21). In A. Septyawan, Iin Susilowati, E. F. Subeqi, & E. Melasevix (Eds.), Katalog Dalam Terbitan (KDT) (Issue January 2021). Wade Group. https://www.researchgate.net/publication/347646698
Mansyur, N. N. (2024). Penerapan Metode Interpolasi Lagrage dalam Meramalkan Jumlah Pendapatan pada Percetakan (Studi Kasus: Gevira Advertising). Jurnal Matematika, Komputasi Dan Statistika, 4(April), 540–546. http://jmks.uho.ac.id/index.php/journa
Parjaman, T., & Akhmad, D. (2019). Pendekatan Penelitian Kombinasi: Sebagai “Jalan Tengan” atas Dikotomi Kualitatif-Kuantitatif. Moderat, 5(November), 530–548. https://jurnal.unigal.ac.id/index.php/moderat
Putra, H. D., Laisouw, R., Sultan, M. H., & Usman, H. (2024). Application of Newton Polynomial Interpolation Method in Determining the Continuity of Functions Represented by Tabulated Discrete Points. Biosaintek, 6(2), 53–63. https://doi.org/DOI: https://doi.org/10.52046/biosainstek.v6i2.53-63
Rianti, W., & Harahap, E. (2021). Pengolahan Data Hasil Penjualan Online Menggunakan Aplikasi Microsoft Excel. Matematika: Jurnal Teori Dan Terapan Matematika, 20(2), 69–76.
Rizky, A. F., Toyyibah, & Maulida, R. (2024). Implementasi Python pada Metode Numerik (1st ed.). Eureka Media Aksara.
Rozi, S., & Rarasati, N. (2022). Template Metode Numerik pada Excel untuk Menemukan Solusi dari Persamaan NonLinear. AXIOM: Jurnal Pendidikan Matematika, 11(1), 33–47. https://doi.org/https://doi.org/10.30821/axiom.v.11i1.11254
Salim, D., Wu, B., Salim, O. R., & Gunadi, R. B. (2022). Penggunaan Python Untuk Menganalisis Pola Penyebaran Covid-19 Di Masa Pandemi. Journal of Student Development Information System (JoSDIS), 2, 120–133.
Shamloo, A. S., & Hajagharezalou, P. (2015). Interval Interpolation by Newton’s Divided Differences. Journal of Mathematics and Computer Science, 13(December 2014). https://doi.org/10.22436/jmcs.013.03.05
Shokri, A., Khalsarael, M. mehdizadeh, Noeiaghdam, S., & Juraev, D. A. (2022). a New Divided Difference Interpolation Method for Two-Variable Functions. Global and Stochastic Analysis, 9(2), 19–26. https://www.researchgate.net/publication/359760081
Sihombing, S. C., Marmaini, & Dahlia, A. (2020). Interpolasi Polinom Newton untuk Mengestimasi Fungsi Polinomial dari Suatu Benda Putar. Jurnal Penelitian Fisika Dan Terapannya (Jupiter), 1(2). https://doi.org/10.31851/jupiter.v1i2.4994 Interpolasi
Siregar, T. (2021). The Use of Visual Basic for Applications ( VBA ) Excel to Improve Reasoning Skills and Learning Activeness through the Implementation of the Problem-Based Learning Model in Class VII-B at MTs Negeri 4 Sinunukan.
Talia, A., Angelica, Tumanggor, A. A., Hasibuan, F., Sianaga, R. K., & Sigalingging, H. (2024). Implementasi Metode Numerik dan Simbolik dengan Python untuk Penentuan Nilai Limit Fungsi. Pentagon : Jurnal Matematika Dan Ilmu Pengetahuan Alam, 4. https://doi.org/https://doi.org/10.62383/pentagon.v2i4.279
Tampubolon, B., Vista, F., Tarigan, K., Daulay, N. H., & Hani, A. (2024). Efficiency of Newton Polynomial Interpolation Method in Determining Stock Price Movements in a Certain Time. Jurnal Nasional Holistic Science, 4(3), 421–427. https://jurnal.larisma.or.id/index.php/HS
Zakaria, L., & Muharramah, U. (2023). Pengantar Metode Numerik. Aura (Agung Utama Raharja).
