Exportar Publicação
A publicação pode ser exportada nos seguintes formatos: referência da APA (American Psychological Association), referência do IEEE (Institute of Electrical and Electronics Engineers), BibTeX e RIS.
Teixeira, A., Rosa, A. & Calapez, T. (2009). Statistical power analysis with microsoft excel: normal tests for one or two means as a prelude to using non-central distributions to calculate power. Journal of Statistics Education. 17 (1), 1-21
A. F. Teixeira et al., "Statistical power analysis with microsoft excel: normal tests for one or two means as a prelude to using non-central distributions to calculate power", in Journal of Statistics Education, vol. 17, no. 1, pp. 1-21, 2009
@article{teixeira2009_1734885322151, author = "Teixeira, A. and Rosa, A. and Calapez, T.", title = "Statistical power analysis with microsoft excel: normal tests for one or two means as a prelude to using non-central distributions to calculate power", journal = "Journal of Statistics Education", year = "2009", volume = "17", number = "1", doi = "10.1080/10691898.2009.11889507", pages = "1-21", url = "https://www.tandfonline.com/doi/full/10.1080/10691898.2009.11889507" }
TY - JOUR TI - Statistical power analysis with microsoft excel: normal tests for one or two means as a prelude to using non-central distributions to calculate power T2 - Journal of Statistics Education VL - 17 IS - 1 AU - Teixeira, A. AU - Rosa, A. AU - Calapez, T. PY - 2009 SP - 1-21 SN - 1069-1898 DO - 10.1080/10691898.2009.11889507 UR - https://www.tandfonline.com/doi/full/10.1080/10691898.2009.11889507 AB - This article presents statistical power analysis (SPA) based on the normal distribution using Excel, adopting textbook and SPA approaches. The objective is to present the latter in a comparative way within a framework that is familiar to textbook level readers, as a first step to understand SPA with other distributions. The analysis focuses on the case of the equality of the means of two populations with equal variances for independent samples with the same size. This is the situation adopted as case 0 by Cohen (1988), a pioneer in the subject, to develop his set of tables and so, the present article can be seen as an introduction to Cohen's methodology applied to tests based on samples from normal populations. We also discuss how to extend the calculation to cases with other characteristics (cases 1 to 4), similarly to what Cohen proposes, as well as a brief discussion about the advantages and shortcomings of Excel. We teach mainly in the area of business and economics, which determines the scope of our analysis. ER -