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.