Confidence Interval Estimation – Discussion
clpoole78
unit4_discussion_cie_proportion.xlsxCOMPUTE
| Proportion of In-Error Sales Invoices | |
| Data | |
| Sample Size | 100 |
| Number of Successes | 10 |
| Confidence Level | 95% |
| Intermediate Calculations | |
| Sample Proportion | 0.1 |
| Z Value | -1.9600 |
| Standard Error of the Proportion | 0.03 |
| Interval Half Width | 0.0588 |
| Confidence Interval | |
| Interval Lower Limit | 0.0412 |
| Interval Upper Limit | 0.1588 |
COMPUTE_FORMULAS
| Proportion of In-Error Sales Invoices | |
| Data | |
| Sample Size | 100 |
| Number of Successes | 10 |
| Confidence Level | 95% |
| Intermediate Calculations | |
| Sample Proportion | =B5/B4 |
| Z Value | =NORM.S.INV((1 - B6)/2) |
| Standard Error of the Proportion | =SQRT(B9 * (1 - B9)/B4) |
| Interval Half Width | =ABS(B10 * B11) |
| Confidence Interval | |
| Interval Lower Limit | =B9 - B12 |
| Interval Upper Limit | =B9 + B12 |
COMPUTE_OLDER
| Proportion of In-Error Sales Invoices | |
| Data | |
| Sample Size | 100 |
| Number of Successes | 10 |
| Confidence Level | 95% |
| Intermediate Calculations | |
| Sample Proportion | 0.1 |
| Z Value | -1.9600 |
| Standard Error of the Proportion | 0.03 |
| Interval Half Width | 0.0588 |
| Confidence Interval | |
| Interval Lower Limit | 0.0412 |
| Interval Upper Limit | 0.1588 |
COMPUTE_OLDER_FORMULAS
| Proportion of In-Error Sales Invoices | |
| Data | |
| Sample Size | 100 |
| Number of Successes | 10 |
| Confidence Level | 95% |
| Intermediate Calculations | |
| Sample Proportion | =B5/B4 |
| Z Value | =NORM.S.INV((1 - B6)/2) |
| Standard Error of the Proportion | =SQRT(B9 * (1 - B9)/B4) |
| Interval Half Width | =ABS(B10 * B11) |
| Confidence Interval | |
| Interval Lower Limit | =B9 - B12 |
| Interval Upper Limit | =B9 + B12 |
