Explore BrainMass
Share

Explore BrainMass

    Confidence Interval for Population Proportion

    This content was COPIED 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 October 10, 2019, 3:09 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