Estimating Missing Panel Data with Regression and Multivariate Imputation by Chained Equations (MICE)

Abstract

Missing data may occur in various types of research. Regression and multiple imputation by chained equations (MICE) are two methods that can be used to estimate missing data in panel data types. This study aims to compare the accuracy of the missing panel data estimation using the regression and the MICE methods. The data used in this study are 161 random samples of senior high schools and vocational schools in DKI province for the year 2016-2020. Based on the results of the Chow test, Hausman test, and Lagrange Multiplier test on panel data regression, it shows that the appropriate model for the student-teacher ratio (X5) is random, the percentage of teachers who have an educator certificate (X6) is a fixed model with the specific effect of individual school and time, while the percentage of teachers who hold a bachelor degree (X7) is a fixed model with the specific effect of individual. Based on this model, the estimation of missing data is then carried out. The accuracy of the missing data estimation was carried out by comparing the MAPE, MAE, and RMSE values. The results show that the MICE method is quite good for estimating missing data at X5, quite feasible for estimating X6, and very good for estimating missing data at X7. In general, MICE is more accurate than panel data regression