Table of Content

Open Access iconOpen Access

ARTICLE

Comparative Variance and Multiple Imputation Used for Missing Values in Land Price DataSet

Longqing Zhang1, Liping Bai1,*, Xinwei Zhang2, Yanghong Zhang2, Feng Sun2, Changcheng Chen2

1 Macau University of Science and Technology, Macau.
2 Guangdong University of Science and Technology, Dongguan, 523083, China.
* Corresponding Author: Liping Bai. Email: lipbai@must.edu.mo.

Computers, Materials & Continua 2019, 61(3), 1175-1187. https://doi.org/10.32604/cmc.2019.06075

Abstract

Based on the two-dimensional relation table, this paper studies the missing values in the sample data of land price of Shunde District of Foshan City. GeoDa software was used to eliminate the insignificant factors by stepwise regression analysis; NORM software was adopted to construct the multiple imputation models; EM algorithm and the augmentation algorithm were applied to fit multiple linear regression equations to construct five different filling datasets. Statistical analysis is performed on the imputation data set in order to calculate the mean and variance of each data set, and the weight is determined according to the differences. Finally, comprehensive integration is implemented to achieve the imputation expression of missing values. The results showed that in the three missing cases where the PRICE variable was missing and the deletion rate was 5%, the PRICE variable was missing and the deletion rate was 10%, and the PRICE variable and the CBD variable were both missing. The new method compared to the traditional multiple filling methods of true value closer ratio is 75% to 25%, 62.5% to 37.5%, 100% to 0%. Therefore, the new method is obviously better than the traditional multiple imputation methods, and the missing value data estimated by the new method bears certain reference value.

Keywords


Cite This Article

L. Zhang, L. Bai, X. Zhang, Y. Zhang, F. Sun et al., "Comparative variance and multiple imputation used for missing values in land price dataset," Computers, Materials & Continua, vol. 61, no.3, pp. 1175–1187, 2019.

Citations




cc This work is licensed under a Creative Commons Attribution 4.0 International License , which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.
  • 2442

    View

  • 964

    Download

  • 0

    Like

Share Link