Comparison of the methods to estimate missing values in monthly precipitation data

Wahidah Sanusi, Wan Zawiah Wan Zin @ Wan Ibrahim, Usman Mulbar, Muhammad Danial, Syafruddin Side

Research output: Contribution to journalArticle

Abstract

Estimation of missing data is essential in the meteorological, climatologically and hydrology analyses. This study employed the arithmetic mean method, normal ratio method, the modified normal ratio method, and correlation coefficient weighting method. The performance of these methods are then compared using correlation coefficient, the S-index, the root mean squared error and mean absolute error methods. The objective of this study is to determine the best estimation method for missing data for four precipitation stations in Makassar city. The results show that the modified usual ratio method is suitable to estimate the missing precipitation data in Makassar city. This study result could be useful information for climate research to complete the missing precipitation data, especially for rain gauge stations in Makassar city.

Original languageEnglish
Pages (from-to)2168-2174
Number of pages7
JournalInternational Journal on Advanced Science, Engineering and Information Technology
Volume7
Issue number6
Publication statusPublished - 1 Jan 2017

Fingerprint

Rain gages
Hydrology
methodology
rain gauges
Rain
Climate
hydrology
climate
Research

Keywords

  • Correlation coefficient
  • Missing values
  • Normal ratio method
  • Precipitation data
  • S-index

ASJC Scopus subject areas

  • Computer Science(all)
  • Agricultural and Biological Sciences(all)
  • Engineering(all)

Cite this

Comparison of the methods to estimate missing values in monthly precipitation data. / Sanusi, Wahidah; Wan Zin @ Wan Ibrahim, Wan Zawiah; Mulbar, Usman; Danial, Muhammad; Side, Syafruddin.

In: International Journal on Advanced Science, Engineering and Information Technology, Vol. 7, No. 6, 01.01.2017, p. 2168-2174.

Research output: Contribution to journalArticle

@article{03f773101cef4cb5a789cd234a540e07,
title = "Comparison of the methods to estimate missing values in monthly precipitation data",
abstract = "Estimation of missing data is essential in the meteorological, climatologically and hydrology analyses. This study employed the arithmetic mean method, normal ratio method, the modified normal ratio method, and correlation coefficient weighting method. The performance of these methods are then compared using correlation coefficient, the S-index, the root mean squared error and mean absolute error methods. The objective of this study is to determine the best estimation method for missing data for four precipitation stations in Makassar city. The results show that the modified usual ratio method is suitable to estimate the missing precipitation data in Makassar city. This study result could be useful information for climate research to complete the missing precipitation data, especially for rain gauge stations in Makassar city.",
keywords = "Correlation coefficient, Missing values, Normal ratio method, Precipitation data, S-index",
author = "Wahidah Sanusi and {Wan Zin @ Wan Ibrahim}, {Wan Zawiah} and Usman Mulbar and Muhammad Danial and Syafruddin Side",
year = "2017",
month = "1",
day = "1",
language = "English",
volume = "7",
pages = "2168--2174",
journal = "International Journal on Advanced Science, Engineering and Information Technology",
issn = "2088-5334",
publisher = "INSIGHT - Indonesian Society for Knowledge and Human Development",
number = "6",

}

TY - JOUR

T1 - Comparison of the methods to estimate missing values in monthly precipitation data

AU - Sanusi, Wahidah

AU - Wan Zin @ Wan Ibrahim, Wan Zawiah

AU - Mulbar, Usman

AU - Danial, Muhammad

AU - Side, Syafruddin

PY - 2017/1/1

Y1 - 2017/1/1

N2 - Estimation of missing data is essential in the meteorological, climatologically and hydrology analyses. This study employed the arithmetic mean method, normal ratio method, the modified normal ratio method, and correlation coefficient weighting method. The performance of these methods are then compared using correlation coefficient, the S-index, the root mean squared error and mean absolute error methods. The objective of this study is to determine the best estimation method for missing data for four precipitation stations in Makassar city. The results show that the modified usual ratio method is suitable to estimate the missing precipitation data in Makassar city. This study result could be useful information for climate research to complete the missing precipitation data, especially for rain gauge stations in Makassar city.

AB - Estimation of missing data is essential in the meteorological, climatologically and hydrology analyses. This study employed the arithmetic mean method, normal ratio method, the modified normal ratio method, and correlation coefficient weighting method. The performance of these methods are then compared using correlation coefficient, the S-index, the root mean squared error and mean absolute error methods. The objective of this study is to determine the best estimation method for missing data for four precipitation stations in Makassar city. The results show that the modified usual ratio method is suitable to estimate the missing precipitation data in Makassar city. This study result could be useful information for climate research to complete the missing precipitation data, especially for rain gauge stations in Makassar city.

KW - Correlation coefficient

KW - Missing values

KW - Normal ratio method

KW - Precipitation data

KW - S-index

UR - http://www.scopus.com/inward/record.url?scp=85040607954&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=85040607954&partnerID=8YFLogxK

M3 - Article

AN - SCOPUS:85040607954

VL - 7

SP - 2168

EP - 2174

JO - International Journal on Advanced Science, Engineering and Information Technology

JF - International Journal on Advanced Science, Engineering and Information Technology

SN - 2088-5334

IS - 6

ER -