Data Editing and Imputation in Business Surveys Using “R”
Journal Title: Revista Romana de Statistica - Year 2014, Vol 62, Issue 2
Abstract
Purpose – Missing data are a recurring problem that can cause bias or lead to inefficient analyses. The objective of this paper is a direct comparison between the two statistical software features R and SPSS, in order to take full advantage of the existing automated methods for data editing process and imputation in business surveys (with a proper design of consistency rules) as a partial alternative to the manual editing of data. Approach – The comparison of different methods on editing surveys data, in R with the ‘editrules’ and ‘survey’ packages because inside those, exist commonly used transformations in official statistics, as visualization of missing values pattern using ‘Amelia’ and ‘VIM’ packages, imputation approaches for longitudinal data using ‘VIMGUI’ and a comparison of another statistical software performance on the same features, such as SPSS. Findings – Data on business statistics received by NIS’s (National Institute of Statistics) are not ready to be used for direct analysis due to in-record inconsistencies, errors and missing values from the collected data sets. The appropriate automatic methods from R packages, offers the ability to set the erroneous fields in edit-violating records, to verify the results after the imputation of missing values providing for users a flexible, less time consuming approach and easy to perform automation in R than in SPSS Macros syntax situations, when macros are very handy.
Authors and Affiliations
Elena Romascanu
Impact of EU funds absorption in ensuring macro stability
Vienna Initiative aims to ensure that the process of deleveraging to be controlled and successful one, to minimize systemic risks of emerging Europe. Strengthening cooperation between countries of origin and host countri...
A NEW APPROACH OF TIME USE IN NATIONAL ECONOMY
The importance of research in this area is that modern economies seek new value, while the time incorporates a significant economic value. The interest to investigate time use has increased in recent decades, refocusing...
RURAL COOPERATIVE A CHANCE FOR ROMANIAN VILLAGE REBIRTH
Cooperation movement has its roots in English locality Rochdale, where in December 1844 was created „Rochdale Society of Equitable Pioneers. Intuiting further economic and social changes, as well as social antagonisms t...
Componentele mediului de afaceri
Business environment refers to the conditions under which European companies operate, involving a number of forces that shape this framework, and based on which companies base their strategy, tactics and daily activities...
Rolul băncilor în absorbţia fondurilor europene pentru menţinerea macrostabilităţii
Unul din obiectivele Iniţiativei de la Viena consta în menținerea de către instituţiile de credit din ţările mai dezvoltate ale Uniunii Europene a unor niveluri de expunere financiară în țările care fac obiectul inițiati...