Suchergebnisse

Purpose
– An alarming number of spreadsheet faults have been reported in the literature, indicating that effective and easy-to-apply spreadsheet testing techniques are not available for "non-technical," end-user programmers. The purpose of this paper is to alleviate the problem by introducing a metamorphic testing (MT) technique for spreadsheets.


Design/methodology/approach
– The paper discussed four common challenges encountered by end-user programmers when testing a spreadsheet. The MT technique was then discussed and how it could be used to solve the common challenges was explained. An experiment involving several "real-world" spreadsheets was performed to determine the viability and effectiveness of MT.


Findings
– The experiment confirmed that MT is highly effective in spreadsheet fault detection, and yet MT is a general technique that can be easily used by end-user programmers to test a large variety of spreadsheet applications.


Originality/value
– The paper provides a detailed discussion of some common challenges of spreadsheet testing encountered by end-user programmers. To the best of the authors knowledge, the paper is the first that includes an empirical study of how effective MT is in spreadsheet fault detection from an end-user programmer's perspective.

Abstract
Background
Bacterial drug resistance represents a significant global concern, with vancomycin-resistant Enterococcus faecalis posing a particularly grave threat to contemporary healthcare systems. This study aims to reveal the reasons for the prevalence of VRE in China.

Methods
This study collected data from the China Antimicrobial Resistance Detection System, China Statistical Yearbook, and China Meteorological Network. The collected data are meticulously organized and subjected to both single-factor and multi-factor analyses. An accurate multiple linear regression model was developed by utilizing this comprehensive dataset.

Results
Single-factor analysis revealed significant regional variations in the resistance rate of vancomycin-resistant Enterococcus faecalis (P = 0.003). Specifically, there were noteworthy disparities observed between regions experiencing temperate and monsoon climates (P = 0.029; P = 0.005). Furthermore, multi-factor regression analysis demonstrated a negative correlation between the drug resistance rate and both rainfall and rGDP, while a positive correlation was observed with nPI.

Conclusion
We successfully established a prediction model for the VRE and found that the resistance rate was low in areas with high rainfall and high per capita economic income, but high in areas with many specialized public health institutions. This is critical for public health strategies and helps policymakers and healthcare practitioners tailor antibiotic resistance approaches to local geography, meteorology, economic conditions.