Close this search box.

Power and Sample Size Help

SPC for Excel will calculate the power, sample size and difference to detect for the one sample z test, the one and two sample t test and the one and two proportion test. This describes how to do this for the one sample z test. The other tests are very similar.

Enter two of the following three items:

You many enter multiple values. For example, you could enter 5, 10, 15, 20 for sample sizes. Separate the multiple entries by a comma.

You must enter a value for the standard deviation.

If the option to generate the power chart was true, the power chart is generated. An example is shown below.

Scroll to Top