• Users Online: 508
  • Home
  • Print this page
  • Email this page
Home About us Editorial board Search Ahead of print Current issue Archives Submit article Instructions Subscribe Contacts Login 
Year : 2016  |  Volume : 3  |  Issue : 4  |  Page : 180-189

Sample size calculation to data analysis of a correlation study in Microsoft Excel® : A hands-on guide with example

1 Department of Physiology, Maharaja Krishna Chandra Gajapati Medical College, Ganjam, Odisha, India
2 Department of Physiology, Medical College and Hospital, Kolkata, West Bengal, India

Correspondence Address:
Himel Mondal
Department of Physiology, MKCG Medical College, Ganjam - 760 004, Odisha
Login to access the Email id

Source of Support: None, Conflict of Interest: None

DOI: 10.4103/2348-8832.196896

Rights and Permissions

Background and Aim: Investigators use correlation study to determine the extent to which two or more variables are related among a single group of people. One big question frequently encountered by investigators is How to calculate sample size? After data collection, it is essential to test the data statistically. Hence, we planned to provide hands-on guide for sample size calculation and statistical analysis of data in Microsoft Excel® 2010 commonly needed for a correlation study. Methods: An example of a correlation study of body mass index and peak expiratory flow rate was taken. Its execution process from sample size calculation to statistical analysis of data has been explained step by step in Excel® 2010. All formula and functions were tested in Excel® 2007. Conclusion: Excel® as a tool for statistical analysis of data would facilitate researchers to do all statistical analyses in a single file. Along with correlation study, analysis by t-test and ANOVA was also provided. With this discussion, new investigators would get a fair knowledge about sample size calculation and data analysis of correlation study in Excel® and can use it for their future studies.

Print this article     Email this article
 Next article
 Previous article
 Table of Contents

 Similar in PUBMED
   Search Pubmed for
   Search in Google Scholar for
 Related articles
 Citation Manager
 Access Statistics
 Reader Comments
 Email Alert *
 Add to My List *
 * Requires registration (Free)

 Article Access Statistics
    PDF Downloaded671    
    Comments [Add]    

Recommend this journal