Basic Statistical Templates - 1 Sample Z-Test and Confidence Interval for
Mean
Click SigmaXL > Templates & Calculators > Basic
Statistical Templates > 1 Sample
Z-Test and Confidence Interval for Mean to access the
template. The template gives the following default example.
Notes
Enter summarized Sample Data, Null Hypothesis and Confidence Level in cells with yellow highlight. Do not modify any other part of this worksheet.
Select Alternative Hypothesis using drop-down.
This calculator will automatically detect the version of Excel and use the appropriate statistical functions.
