I've include a chart of information below the questions listed. From this chart, I need to answer the following questions:

1. Create a control chart in Excel for the data set.
2. Discuss an analysis of the chart.

• Is/are any point(s) out of control? How do you know? (Reference rules for control charts)
• Is there a specific type of control chart that would be best for this data set and why? X-chart, R-chart, p-chart, np-chart?
• Any suggestions? Change process, change sample size, risk amount, process is in control?

Percent Defective in the Lot Probability of Accepting the Lot

1 .8601

2 .7386

3 .6333

4 .5421

5 .4633

10 .2059

15 .0874

20 .0352

25 .0134