Excel VBA-based death cause monitoring data analysis method

Abstract

The invention discloses an Excel VBA-based death cause monitoring data analysis method, which comprises the steps of constructing a data quality evaluation model; constructing a data analysis execution engine, converting all variables by adopting a unified coding rule and format based on Excel VBA, uniformly arranging and importing all data into Excel, and embedding ICD codes of different diseasetypes into the background; carrying out data analysis and arrangement by taking the data imported into Excel as an execution object in a transverse analysis or longitudinal analysis mode, wherein transverse analysis reflects the crowd death condition and the key index condition of a specific year, and longitudinal analysis reflects the change trend of the crowd death level or the key index betweenspans of different years. According to the Excel VBA-based death cause monitoring data analysis method, management and quality control are performed on death cause monitoring data, and full-crowd, full-process and integrated death cause data analysis and key index calculation are realized.

Description

technical field [0001] The invention belongs to the field of big data processing, and in particular relates to an analysis method of death cause monitoring data. Background technique [0002] Death cause monitoring is an important public health monitoring activity. It is of great significance to understand the level and order of death of residents, grasp the factors affecting residents' health, and provide a reliable basis for government decision-making. As a highly technical work, death monitoring involves many links, and the amount of data is huge every year. From the perspective of monitoring data management, it involves many aspects such as data collection, reporting, sorting, cleaning, analysis and reporting. link. With the application of the direct network reporting system for cause of death registration, the quality of data collection and reporting has been greatly improved. How to do a good job in subsequent data management, analysis and utilization has become an ur...

AI Technical Summary

Problems solved by technology

Due to the uneven level of data management, analysis and utilization of technicians in grassroots monitoring units, the utilization of monitoring data is limited

In addition, due to the real-time update of the cause of death monitoring data, and there are many key information items and a large amount of data, the processing and analysis of the data is heavy and time-consuming, prone to errors and omissions, and cannot meet the work requirements

Although there are currently many statistical software, such as SAS, R language, SPSS, Stata, etc., for the personnel of the majority of grassroots monitoring units, their high price and professional use methods are the biggest obstacles to the use of these statistical software, and some software It is very inconvenient to use, requires programming, and the visualization and interaction are not strong

Images