More Power & Sample Size Tests (Pro)

Owned by Echo Chu
Last updated: Nov 07, 2017 by Wall-E
1 min read

(ORG-7711, ORG-7712, ORG-7707, ORG-7706)

Sample OPJ to download to try:  More Power and Sample Size Tests.opj


We have introduced more tests for Power and Sample Size. These tests  are accessible from the Statistics: Power and Sample Size menu

  • One-Proportion Test
  • Two-Proportion Test
  • One-Variance Test
  • Two Variance Test

How to

  1. Start with a new empty worksheet
  2. Select Statistics: Power and Sample Size: Two-Variance Test
  3. To calculate Power, select Power for Calculate drop-down list
    To calculate Sample Size, select Sample Size for that drop-down.
  4. Fill in the 1st Group Variance, 2nd Group Variance, Sample Size(or Power). Select Not Equal for Alternative Hypothesis.
  5. Check for Power Curve so a power curve plot will be included in the result sheet.

You can also specify a column to be the source data of Sample Size/Power. Expand the "Options" node and check the More Hypothetical Sample Size/Power box and select a column from the active worksheet.