Home
World Journal of Biology Pharmacy and Health Sciences
ISSN Approved | International, Peer reviewed, Referred, Open access Journal

Main navigation

  • Home
    • Journal Information
    • Abstracting and Indexing
    • Editorial Board Members
    • Reviewer Panel
    • Journal Policies
    • WJBPHS CrossMark Policy
    • Publication Ethics
    • Current Issue
    • Issue in Progress
    • Past Issues
    • Instructions for Authors
    • Article processing fee
    • Track Manuscript Status
    • Get Publication Certificate
    • Become a Reviewer panel member
    • Join as Editorial Board Member
  • Contact us
  • Downloads

ISSN Approved Journal | | IMPACT FACTOR 8.16 | | eISSN: 2582-5542 | |  Free Crossref DOI 

Fast Publication within 2 days | | Low Article Processing Charges | | Peer Reviewed and Referred Journal

Research and review articles are invited for publication in September 2026 (Volume 27, Issue 3) Submit Paper

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

Breadcrumb

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

Tapan Kumar Mahato *

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
DOI url: https://doi.org/10.30574/wjbphs.2023.13.3.0128

Received on 04 February 2023; revised on 15 March 2023; accepted on 17 March 2023

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.

Mean; Median; Dispersion; Standard deviation; Central tendency; Karl pearson’s coefficient of correlation

https://wjbphs.com/sites/default/files/fulltext_pdf/WJBPHS-2023-0128.pdf

Get Your e Certificate of Publication using below link

Download Certificate

Preview Article PDF

Tapan Kumar Mahato. 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, 2023, 13(03), 150–155. Article DOI: https://doi.org/10.30574/wjbphs.2023.13.3.0128

Get Certificates

Get Publication Certificate

Download LoA

Check Corssref DOI details

Issue details

Issue Cover Page

Editorial Board

Table of content


Copyright © Author(s). All rights reserved. This article is published under the terms of the Creative Commons Attribution 4.0 International License (CC BY 4.0), which permits use, sharing, adaptation, distribution, and reproduction in any medium or format, as long as appropriate credit is given to the original author(s) and source, a link to the license is provided, and any changes made are indicated.


Copyright © 2026 World Journal of Biology Pharmacy and Health Sciences (WJBPHS) - All rights reserved

Developed & Designed by VS Infosolution