Power and Sample Size Help

SPC for Excel will calculate the power, sample size and difference to detect for the the sample options listed below. 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 space.

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