# Confidence Interval for Population Proportion

Please solve the exercise below using Excel and show your work (with formulas).

The production manager for the XYZ Manufacturing company is concerned that the customer orders are being shipped late. He asked one of his planners to check the timeliness of shipments for 1000 orders. The planner randomly selected 1000 orders and found that 120 orders were shipped late. Construct the 99% confidence interval for the proportion of orders shipped late.

© BrainMass Inc. brainmass.com October 10, 2019, 3:09 am ad1c9bdddfhttps://brainmass.com/statistics/confidence-interval/confidence-interval-population-proportion-409164

#### Solution Preview

Please see the attachments.

Statistics exercise 4

Please solve the exercise below using Excel and show your work (incl. formulas).

The production manager for the XYZ manufacturing company is concerned that the customer orders are being shipped late. He asked one of his ...

#### Solution Summary

The solution provides step by step method for the calculation of confidence interval for proportion. Formula for the calculation and Interpretations of the results are also included. Interactive excel sheet is included. The user can edit the inputs and obtain the complete results for a new set of data.