 ConfidenceIntervalCalculators.xlsx

## One-Population

 One Population Statistics Hypothesis test calculator Sample Statistic x-mean 15 enter enter 15 Hypothetical Value Sample Size n 150 enter Sample Standard Deviation 2 enter 0 Difference between sample value and Hypothetical value Standard Error of Statistic SE 0.1633 0.0000 z-score 50% p-value lower (Probability the mean is more than Hypothetical Value) z-score CL 50% p-value upper (Probaility the mean is less than Hypothetical value) 1.645 90% 1.0000 Two-tailed test p-value 1.96 95% 2.576 99% Confidence Intervals using z-scores CL 90% upper 15.27 z 1.645 lower 14.73 CL 95% upper 15.32 z 1.96 lower 14.68 CL 99% upper 15.42 z 2.576 lower 14.58

Only enter data in the dark-colored cells; the remaining cells are locked and calculate automatically. If you delete a formula, reload the calculator from your classroom, or a clean saved file.

## Two-Populations

 Two Population (mean) Statistics First Sample Mean 1 50 enter first sample mean First Sample Size 1 40 enter first sample size Second Sample Mean 2 51 enter second sample mean 51 Hypothetical difference between the two samples (usually zero) Second Sample Size 2 50 enter second sample size Difference Mean Diff -1 -52 Difference between sample value and Hypothetical value Sample Standard Deviation 1 Stdev. 1 1.2 enter first standard deviation Sample Standard Deviation 2 Stdev. 2 1.8 enter second standard deviation -163.7846 z-score 0.0000 Probability the samples are different Standard Error of Statistic SE 0.3174901573 1.0000 Probability the samples are the same 0.0000 Probability the samples are different, using two-tails C I of Difference using z-scores CL 90% upper -0.478 z 1.645 lower -1.522 CL 95% upper -0.378 z 1.96 lower -1.622 CL 99% upper -0.182 z 2.576 lower -1.818

Only enter data in the dark-colored cells; the remaining cells are locked and calculate automatically. If you delete a formula, reload the calculator from your classroom, or a clean saved file.