Two sample unpaired T-test power calculation using simulation
DOI:
https://doi.org/10.14232/analecta.2023.4.10-15Keywords:
T test, Statistics, Simulation, Power, Effect sizeAbstract
Statistical tests like t test are used to test the hypothesis for comparison of mean between two groups. The result from a t test is used to determine if there a significant difference between the two samples mean, which cannot be attributed to sampling error or to random occurrence. A t test is considered a parametric test, meaning test samples should meet assumptions of normality, equal variances and independence. The article aims to calculate the power of unpaired t test using simulation in Microsoft Excel.
Downloads
References
What are statistical tests? https://www.itl.nist.gov/div898/handbook/prc/section1/prc13.htm#:~:text=A%20statistical%20test%20provides%20a,is%20called%20the%20null%20hypothesis (2023.05.23)
Kim T.K. (2015): T test as a parametric statistic, Korean Journal of Anesthesiology 68(6), 540-546. https://doi.org/10.4097/kjae.2015.68.6.540
Nakagawa S., Cuthill I.C., (2007): Effect size, confidence interval and statistical significance: a practical guide for biologists, Biological reviews 82(4) 591-605. https://doi.org/10.1111/j.1469-185X.2007.00027.x
GraphPad Prism 9 Statistics Guide - Monte Carlo example: Power of unpaired t test (2023.05.22)
T.TEST function https://support.microsoft.com/en-us/office/t-test-function-d4e08ec3-c545-485f-962e-276f7cbed055 (2023.05.22)
FTEST function https://support.microsoft.com/en-us/office/ftest-function-4c9e1202-53fe-428c-a737-976f6fc3f9fd (2023.05.22)
David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, Essentials of Modern Business Statistics with Microsoft ® Excel ®, 8th edition, Cenage, Boston, 2019.
Morisette J.T., Khorram S. (1998): Exact Binomial Confidence Interval for Proportions. Photogrammetric Engineering and Remote Sensing 64(4), 281-283.
Hentschke H, Stüttgen M.C. (2011), Computation of measures of effect size for neuroscience data sets. European Journal of Neuroscience 34(12), 1887-1894. https://doi.org/10.1111/j.1460-9568.2011.07902.x
Downloads
Published
How to Cite
Issue
Section
License
Copyright (C) 2024 Authors
This work is licensed under a Creative Commons Attribution 4.0 International License.
