Biostatistics: Simple practical way to use Microsoft excel to find mean, median, mode, standard deviation and correlation
Department of Pharmaceutical Chemistry, B. Pharmacy College Rampura, At Rampura, PO Kakanpur, Taluka Godhra, District: Panchmahal, Gujarat 388713, India.
Short Communication
World Journal of Biology Pharmacy and Health Sciences, 2023, 13(03), 150–155.
Article DOI: 10.30574/wjbphs.2023.13.3.0128
Publication history:
Received on 04 February 2023; revised on 15 March 2023; accepted on 17 March 2023
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.
Keywords:
Mean; Median; Dispersion; Standard deviation; Central tendency; Karl pearson’s coefficient of correlation
Full text article in PDF:
Copyright information:
Copyright © 2023 Author(s) retain the copyright of this article. This article is published under the terms of the Creative Commons Attribution Liscense 4.0