NotesFAQContact Us
Search Tips
Peer reviewed Peer reviewed
Direct linkDirect link
ERIC Number: EJ841534
Record Type: Journal
Publication Date: 2009-Mar
Pages: 22
Abstractor: As Provided
ISSN: ISSN-1069-1898
Statistical Power Analysis with Microsoft Excel: Normal Tests for One or Two Means as a Prelude to Using Non-Central Distributions to Calculate Power
Texeira, Antonio; Rosa, Alvaro; Calapez, Teresa
Journal of Statistics Education, v17 n1 Mar 2009
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. (Contains 7 tables and 7 figures.)
American Statistical Association. 732 North Washington Street, Alexandria, VA 22314. Tel: 703-684-1221 or 888-231-3473; Fax: 703-684-2037; e-mail:; Website:
Publication Type: Journal Articles; Reports - Descriptive
Education Level: Higher Education
Audience: N/A
Language: English
Sponsor: N/A
Authoring Institution: N/A