Explore BrainMass
Share

Confidence Interval for Population Proportion

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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 December 20, 2018, 7:26 am ad1c9bdddf
https://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.

$2.19