# Unit 5 Assignment Calculating Confidence Intervals

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