Minitab
MTB > ZTest 10 2.24 'SKQ-Pre';
SUBC> Alternative 1.
produces:
Test of mu = 10.000 vs mu > 10.000
The assumed sigma = 2.24
Variable N Mean StDev SE Mean Z P-Value
SKQ-Pre 15 11.533 2.200 0.578 2.65 0.0041
Return to Top
Excel
Excel will not directly perform this statistical test with the tools available in
the Data Analysis toolpack.
Download ztest.xls, an Excel worksheet that will perform the z-test
for the mean when the variance is known.
Return to Top
Java Applet
The following Java applet introduced on the main page calculates the z-test
and its probability.
Return to Top