Article,
Biostatistics: Simple practical way to use Microsoft excel to find mean, median, mode, standard deviation and correlation
World Journal of Biology Pharmacy and Health Sciences, 13 (3): 150–155 (March 2023)
DOI: 10.30574/wjbphs.2023.13.3.0128
Abstract
India is among the top five countries in the pharmaceutical sector. Software is used more frequently because it completes the work in very short time in terms of analyzing data, calculations etc. Computers and cutting-edge software are increasingly used in research. Application of mathematics to biological systems is known as biostatistics (living things). Because biostatistics is employed in both experimental and observational investigations, it is a subject worth studying in the pharmaceutical sector, medical and paramedical (nursing, pharmacy, etc.) schools. Use of Pen and paper for measurements and calculations take far too long to complete. Software is the option to reduce the time. There is a wide variety of statistical software available today that produces findings quickly. Some examples of statistical software are Minitab, SPSS, R online, and Microsoft Excel. Microsoft excel is free and widely accessible software to calculate central tendency, dispersion and correlation. In this article we will discuss the use of Microsoft excel to find mean, median, mode, standard deviation and correlation of the given data.
