7,591
Views
0
CrossRef citations to date
0
Altmetric
Original Articles

Statistical Power Analysis with Microsoft Excel: Normal Tests for One or Two Means as a Prelude to Using Non-Central Distributions to Calculate Power

, &

References

  • American Psychological Association (1994), Publication Manual of the American Psychological Association, 4th ed., Washington, DC: Author.
  • American Psychological Association (2001), Publication Manual of the American Psychological Association, 5th ed., Washington, DC: Author.
  • Berenson, M. L. and D. M. Levine (1996), Basic Business Statistics, 6th ed., Englewood Cliffs, New Jersey: Prentice Hall International Inc.
  • Berenson, M. L., D. M. Levine and T. C. Krehbiel (2004), Basic Business Statistics, 9th ed., Upper Saddle River, New Jersey: Pearson/Prentice Hall.
  • Bernstein, S. and R. Bernstein (1999), Schaum's Outline Elements of Statistics II: Inferential Statistics, New York: McGraw-Hill.
  • Borenstein, M. (2008), Meta Analysis, www.statistics.com online course.
  • Cohen, J. (1988), Statistical Power Analysis for the Behavioral Sciences, 2nd Ed., NewYork: Lawrence Erlbaum Associates.
  • Freund, J. E. (1962), Mathematical Statistics, Englewood Cliffs, New Jersey: Prentice Hall International Inc.
  • Kazmier, L. J. and N. F. Poll (1979), Basic Statistics for Business and Economics, 2nd ed., New York: McGraw-Hill.
  • Kline, R. B.(2004). Beyond Significance Testing: Reforming Data Analysis Methods in Behavioral Research, American Psychological Association.
  • Knüsel, L. (1998), “On the Accuracy of the Statistical Distributions in Microsoft Excel 97”, Comput. Statist. Data Anal. 39, pp. 109–110 (With Corrigendum in CSDA, 40, 385).
  • Knüsel, L. (2002), “On the Reliability of Microsoft Excel XP for Statistical Purposes”, Comput. Statist. Data Anal. 26, pp. 375–377.
  • Knüsel, L. (2005), On the Accuracy of the Statistical Distributions in Microsoft Excel 2003, Comput. Statist. Data Anal. 48, pp. 445–449.
  • Larson, R. and E. Faber (2000), Elementary Statistics: Picturing the World, Pearson Education.
  • Levin, R. I. and D. S. Rubin (1998), Statistics for Management, 7th ed., Upper saddle River, New Jersey: Prentice Hall International Inc.
  • Levine D. M., M. L. Berenson and David Stephan (1999), Statistics for Managers Using Microsoft Excel, 2nd ed., Upper saddle River, New Jersey: Prentice Hall International Inc.
  • Microsoft Corporation (2007), “Description of the effects of the improved statistical functions for the Analysis ToolPak in Excel”, http://support.microsoft.com/kb/829208/en-us (accessed on on 2008-March-4).
  • Microsoft Corporation (2007a), “Floating-point arithmetic may give inaccurate results”, http://support.microsoft.com/kb/78113 (accessed on 2008-March-4).
  • Microsoft Corporation (2007b), “How to correct rounding errors in floating-point arithmetic”, http://support.microsoft.com/kb/214118/en-us (accessed on 2008-March-4).
  • Murteira, B., C. S. Ribeiro, J. A. Silva and C. Pimenta (2002), Introdução à Estatística, Lisboa: McGraw-Hill.
  • Pestana, D.D. and S. F. Velosa (2002), Introdução à Probabilidade e Estatística, Lisboa: Fundação Calouste Gulbenkian.
  • Pinto, J. C. C. and J. J. Dias Curto (1999), Estatística para Economia e Gestão: Instrumentos de Apoio à Tomada de Decisão, Lisboa: Sílabo.
  • Reis E., P. Melo, R. Andrade and T. Calapez (2001), Estatística Aplicada — Vol. 2, 4th ed., Lisboa: Sílabo.
  • Sanders D. H. (1990), Statistics: A First Course, 5th ed., New York: McGraw-Hill.
  • Sandy, R. (1990), Statistics for Business and Economics, New York: McGraw-Hill.
  • Sleeper, A. (2006), Six Sigma Distribution Modelling, New York: McGraw-Hill.
  • Smithson, M. (2000), Statistics with Confidence, London: SAGE.
  • Smithson, M. (2002), Confidence Intervals, Thousand Oaks, California: SAGE.
  • Spiegel, M. (1972), Schaum's Outline of Statistics, New York: McGraw-Hill.
  • Walkenbach, J. (2001). Excel 2002 Formulas, New York: M&T Books.
  • Walkenbach, J. (2008). http://www.j-walk.com/ss/excel/odd/index.htm.
  • Watson, C. J., P. Billingsley, D.J. Croft and D. Huntsberger (1993), Statistics for Management and Economics, 5th ed., Boston: Allyn and Bacon.
  • Webster, A.L. (1998). Applied Statistics for Business and Economics, 3rd ed. Boston: Irwin/McGrwaw-Hill.

Reprints and Corporate Permissions

Please note: Selecting permissions does not provide access to the full text of the article, please see our help page How do I view content?

To request a reprint or corporate permissions for this article, please click on the relevant link below:

Academic Permissions

Please note: Selecting permissions does not provide access to the full text of the article, please see our help page How do I view content?

Obtain permissions instantly via Rightslink by clicking on the button below:

If you are unable to obtain permissions via Rightslink, please complete and submit this Permissions form. For more information, please visit our Permissions help page.