OPPORTUNITIES OF MICROSOFT EXCEL IN VISUALIZING ELECTRONIC HEALTH RECORDS AND CALCULATING MEDICAL DATA CORRELATION IN CLINICAL PRACTICE

Authors

  • Abdullayev Yusufbek Fayzulla ugli,Istamova Durdona Rustam kizi,Ibragimova Dildora Uktamjon kizi,Shamatov Faxriddin Uralovich,Turdimuratov Baxtiyor Kurbonovich 2nd-year student, Faculty of Medicine,2nd-year student, Faculty of Medicine,Tashkent State Medical University, Termez Branch Assistant at the Department of Social and Humanitarian Sciences,Tashkent State Medical University, Termez Branch Assistant at the Department of Social and Humanitarian Sciences,Tashkent State Medical University, Termez Branch Assistant at the Department of Social and Humanitarian Sciences Author

DOI:

https://doi.org/10.5281/zenodo.20321035

Keywords:

medical informatics, electronic health record, Microsoft Excel, Pearson correlation, data visualization, scatter plot, clinical statistics.

Abstract

This study investigates the practical capabilities of Microsoft Excel for primary data processing, visualization, and the determination of correlation links between parametric indicators from large-scale medical datasets obtained from Electronic Health Records (EHR) and Hospital Information Systems (HIS). Using clinical variables (patient age and systolic blood pressure) as a model, this paper demonstrates the algorithm for calculating the Pearson correlation coefficient ($r$) and creating correlation matrices within the Excel environment, as well as the methodology for visualizing these datasets using scatter plots and trendlines.

References

1.Ganiyev, A. K., & Mamatqulova, N. X. (2024). Textbook on Information Technologies in Medicine and Clinical Statistics. Tashkent.

2.Fletcher, R. H., Fletcher, S. W., & Fletcher, G. S. (2014). Clinical Epidemiology: The Essentials. Lippincott Williams & Wilkins.

3.Microsoft Corporation. (2023). Advanced Statistical Functions in Excel. Retrieved from Microsoft Support.

4.Altman, D. G. (1991). Practical Statistics for Medical Research. London: Chapman & Hall.

5.Kurbonovich, T. B. et al. (2025). Digital Technologies in Medicine. Telemedicine. IMRAS, 8(12), 39-41.

6.Kurbonovich, T. B. et al. (2026). Problems in Modern Culture: Socio-Spiritual Analysis in the Context of Globalization and Digital Transformation. Global Science Review, 18(1), 183-188.

7.Panji o‘g‘li, C. O. et al. (2026). Regenerative Properties and Modern Histological Analysis of Connective Tissue in the Morphofunctional System of the Organism. American Journal of Applied Medical Science, 4(2), 230-235.

8.Turdimuratov, B. K. (2022). Teaching Medical Sciences Using Innovative Methods and ICT. Tashkent: Uzbekistan Medical Publishing House.

9.Kurbonovich, T. B., & Bahodirovich, B. B. (2026). Step-by-step acquisition of practical skills in studying information technologies in medicine. Global Science Review, 17(1), 203–209.

10.Kurbonovich, T. B., & Nurhayat, M. (2026). Compilation and steps of the medical situational issues algorithm. American Journal of Applied Medical Science, 4(2), 59–63.

11.Turdimurodov, B. K., et al. The essence of electronic textbooks in medical education. European Journal of Humanities and Educational Advancements, 3(4), 48–50.

12.Kurbonovich T. B. et al. USE OF ICT AND SOFTWARE IN TEACHING PRACTICAL MEDICAL EXERCISES //AMERICAN JOURNAL OF APPLIED MEDICAL SCIENCE. – 2025. – Т. 3. – №. 11. – С. 1-6.

Downloads

Published

2026-05-21