Question: You are the production manager for an operation that produces circuit boards. Each board is tested at the end of the manufacturing process. Rejected boards are discarded and have no future value. For product B-17, you have kept data on the number of rejects for the past 38 weeks. These data are found in this Excel spreadsheet.

Prepare a frequency distribution chart.

Does this approximate a normal curve?

What is the Standard Deviation (use Excel to calculate this value with the STDEV function)?

What is the approximate probability that at least 7 rejected boards will be produced next week?

Be sure to clearly show how you arrived at your conclusion in at least one half page of text.

To get you started with a frequency distribution table:

You will have to complete the rest of the table yourself to answer the assignment questions.