Biostatistics: Simple practical way to use Microsoft excel to find mean, median, mode, standard deviation and correlation

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