EUVIMEDEUVIMED entdecken
Crossref

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

Himel Mondal, Shaikat Mondal

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.

AbstractBibliografische AngabenZitierenVerwandte Studien

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}
}
Kostenlos starten →