Unit 6 Assignment
brandon282011
ConfidenceIntervalCalculators.xlsxOne-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.
