Unit 5 Assignment Calculating Confidence Intervals

profilebrandon282011
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.