Implementation of Multiple Linear Regression Methods as Prediction of Village Spending on Village Financial Management System
DOI:
https://doi.org/10.21107/kursor.v10i2.216Keywords:
Multiple Linear Regression, Planning, Prediction, Village ExpenditureAbstract
The realization of village welfare and improvement of Village development can be started from the financial management aspects of the village. The village government has authority ranging from planning, implementation, reporting to accountability. There are two important variables as the financial aspects, there is village income, and village expenditure. The village budget process is a plan that will be compiled systematically. Planning has an association with predictions which is an indication of what is supposed to happen and predictions relating to what will happen. To provide a good village budget planning the village budget prediction feature is required. This prediction feature is done using data mining which is modeled i.e. multiple linear regression algorithm. The variable is selected using a purposive sampling technique and the sample count is 29 villages. Dependent variables are village Expenditure as Y, and independent variables i.e. village funds as X1 and village funding allocation as X2. The best values as validation were gained in the 3rd fold with a correlation coefficient of 0.8907, Mean Absolute Error value of 87209395.37, the value of Root Mean Squared Error of 114867675.6, Roll Absolute Error (RAE) Percentage was 42 %, and Root Relative Squared Error was 44 %.
Downloads
References
[2] I. Ibrahim, S. Rejeki, And S. Sawaludin, “Persepsi Masyarakat Desa Bajur Kecamatan Labuapi Kabupaten Lombok Barat Terhadap Undang-Undang No 6 Tahun 2014 Tentang Desa,†Civ. Pendidikan-Penelitian-Pengabdian Pendidik. Pancasila Dan Kewarganegaraan, Vol. 5, No. 2, Pp. 1–9, 2017.
[3] S. Suharto, “Pemberdayaan Masyarakat Desa Dalam Implementasi Uu Desa (Analisis Implementasi Uu No. 6 Tahun 2014 Tentang Desa),†Pros. Senaspolhi, Vol. 1, No. 1, 2018.
[4] A. Riyanto, A. Suherman, And D. Prayudi, “Akuntansi Dalam Perspektif Pengelolaan Keuangan Desa,†In Seminar Nasional Ilmu Pengetahuan Dan Teknologi Komputer, 2016, Pp. 71--Ekm.
[5] S. Hanifa And A. Wibowo, “Faktor Yang Memengaruhi Kemiskinan Di Provinsi Jawa Timur Tahun 2014,†J. Biometrika Dan Kependud., Vol. 6, No. 2, Pp. 136–143, 2018.
[6] M. I. Walukow, L. Kalangi, And S. Pinatik, “Analisis Perencanaan Pengelolaan Keuangan Desa Sesuai Dengan Peraturan Menteri Dalam Negeri Nomor 113 Tahun 2014 Di Desa Kauneran I Kecamatan Sonder Kabupaten Minahasa,†J. Ris. Akunt. Going Concern, Vol. 12, No. 2, 2017.
[7] M. Tahir, A. Anwar, And S. Dinakhir, “Analisis Pengelolaan Keuangan Dana Desa Di Desa Bululoe Kecamatan Turatea Kabupaten Jeneponto,†Universitas Negeri Makassar, 2019.
[8] U. Nain, “Relasi Pemerintah Desa Dan Supradesa Dalam Perencanaan Dan Penganggaran Desa.†Pustaka Pelajar, 2017.
[9] Y. Wu, M. Lan, S. Sun, Q. Zhang, And X. Huang, “A Learning Error Analysis For Structured Prediction With Approximate Inference,†In Advances In Neural Information Processing Systems, 2017, Pp. 6129–6139.
[10] J. B. Darmayasa, T. Mulyana, And Others, “Ethnomathematics: The Use Of Multiple Linier Regression Y= B 1 X 1+ B 2 X 2+ E In Traditional House Construction Saka Roras In Songan Village,†In Journal Of Physics: Conference Series, 2018, Vol. 948, No. 1, P. 12076.
[11] D. A. Rokhmawan And D. Wahyono, “Analisis Pengaruh Pendapatan Asli Desa (Padesa), Dana Desa (Dd), Alokasi Dana Desa (Add), Dan Bagi Hasil Pajak Dan Retribusi Terhadap Belanja Desa Bidang Pertanian Tahun 2017 (Studi Empiris Di Seluruh Desa Se-Kabupaten Sragen),†Universitas Muhammadiyah Surakarta, 2018.
[12] M. Iqbal, “Pengaruh Kepemimpinan, Dokumen Perencanaan, Dam Kompetensi Sdm Terhadap Realisasi Anggran Pendapatan Dan Belanja Desa (Apb-Desa) Pada Pemerintah Desa Di Kabupaten Maros,†In Seminar Nasional Hasil Penelitian & Pengabdian Kepada Masyarakat (Snp2m), 2018.
[13] F. Schäfer, C. Zeiselmair, J. Becker, And H. Otten, “Synthesizing Crisp-Dm And Quality Management: A Data Mining Approach For Production Processes,†In 2018 Ieee International Conference On Technology Management, Operations And Decisions (Ictmod), 2018, Pp. 190–195.
[14] I. Etikan, S. A. Musa, And R. S. Alkassim, “Comparison Of Convenience Sampling And Purposive Sampling,†Am. J. Theor. Appl. Stat., Vol. 5, No. 1, Pp. 1–4, 2016.
[15] M. Syafruddin, L. Hakim, And D. Despa, “Metode Regresi Linier Untuk Prediksi Kebutuhan energi Listrik Jangka Panjang ( Studi Kasus Provinsi Lampung ),†No. 1.
[16] J. L. Garcia-Balboa, M. V Alba-Fernandez, F. J. Ariza-López, And J. Rodriguez-Avi, “Homogeneity Test For Confusion Matrices: A Method And An Example,†In Igarss 2018 - 2018 Ieee International Geoscience And Remote Sensing Symposium, 2018, Pp. 1203–1205.
[17] A. Fadholi, “Persamaan Regresi Prediksi Curah Hujan Bulanan Menggunakan Data Suhu Dan Kelembapan Udara Di Ternate,†Stat. J. Theor. Stat. Its Appl., Vol. 13, No. 1, 2013.
[18] F. E. Harrell Jr, Regression Modeling Strategies: With Applications To Linear Models, Logistic And Ordinal Regression, And Survival Analysis. Springer, 2015.
[19] T. A. Munandar And S. Sumiati, “Implementasi Linier Regresi Untuk Prediksi Curah Hujan Bulanan,†In Prosiding Seminar Nasional Riset Terapan| Senasset, 2017, Pp. 63–66.
[20] S. Y. Fraticasari, D. E. Ratnawati, And R. C. Wihandika, “Optimasi Pemodelan Regresi Linier Berganda Pada Prediksi Jumlah Kecelakaan Sepeda Motor Dengan Algoritme Genetika,†J. Pengemb. Teknol. Inf. Dan Ilmu Komput. E-Issn, Vol. 2548, P. 964x, 2018.
[21] S. Yadav, “Analysis Of K-Fold Cross-Validation Over Hold-Out Validation On Colossal Datasets For Quality Classification,†No. Cv, 2016.
+62-858-5000-1918
