Abstract

The processing and reporting of results, when large amounts of data are handled, requires the use of computational tools that facilitate some repetitive tasks but also help improve results delivery times. In this sense, the use of programming languages has revolutionized the way in which these activities are carried out since, in addition to calculation capabilities, they also facilitate the generation of graphics.

In particular, for the generation of relevant information with data from surveys, the use of the R programming language is of great importance since it is an open source, flexible, expressive and object-oriented language, which facilitates the creation of functions and custom packages. Among other capabilities, R has hundreds of packages and libraries that offer solutions for all types of problems and needs, from basic statistics to artificial intelligence. It is also compatible with other platforms and operating systems and can be integrated with different tools such as Python, Excel, LaTex, etc.

This workshop will cover some data science tools that use R to generate indicators with complex surveys data. In addition to how the results can be imported into a spreadsheet using the “openxlsx” package. This resource is convenient for data analysis because it offers several advantages to improve the time and quality of the reports in Excel. Some of these advantages are:
* It allows you to create, read, write and edit .xlsx files easily and quickly, without depending on Java or Perl .
*It provides a high-level interface to apply styles, formats, formulas, charts, tables and filters to the spreadsheets .
*It is compatible with most of the functions and features of Excel, including sheet protection, data validation, comments, hyperlinks, images and headers and footers .
*It facilitates the integration of the results of statistical analysis and graphics made in R with the reports in Excel, by using specific functions to export R objects such as data.frames, matrices, lists, contingency tables and ggplot2 graphics .

These advantages can help to save time and effort when generating reports in Excel, as well as improve the presentation and management of the data. (Basic programming knowledge is required for the workshop).