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 · 2016 · 3 (4) · 180
DOI: 10.4103/2348-8832.196896 ↗Kurz gefasst
Fachartikel in der Zeitschrift International Journal of Clinical and Experimental Physiology, 2016. Verfasst von Himel Mondal und 1 weiteren Autor:innen. Die Arbeit wurde bisher 21-mal zitiert (Crossref) und nennt 15 Literaturangaben.
Abstract (Originalsprache)
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.
Zitieren
APA
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. https://doi.org/10.4103/2348-8832.196896
Vancouver
Mondal H, Mondal S. 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. 2016;3(4):180. doi:10.4103/2348-8832.196896
BibTeX
@article{Mondal2016,
author = {Mondal, Himel and Mondal, Shaikat},
title = {Sample size calculation to data analysis of a correlation study in Microsoft Excel ® : A hands-on guide with example},
journal = {International Journal of Clinical and Experimental Physiology},
year = {2016},
volume = {3},
number = {4},
pages = {180},
doi = {10.4103/2348-8832.196896}
}
EUVIMED