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

  • Himel Mondal Department of Physiology, Maharaja Krishna Chandra Gajapati Medical College, Ganjam, Odisha, India.
  • Shaikat Mondal Department of Physiology, Medical College and Hospital, Kolkata, West Bengal, India.
Keywords: Correlation study, Excel 2010, Sample size, Statistical analysis, t‑test

Abstract

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.

Published
2016-10-31
How to Cite
Mondal, H., & Mondal, S. (2016). Sample size calculation to data analysis of a correlation study in Microsoft Excel®: A hands‑on guide with example. International Journal of Clinical and Experimental Physiology, 3(4), 180-189. Retrieved from https://www.ijcep.org/index.php/ijcep/article/view/288