Tiptop Laboratories has decided to develop a Quality Control program. Because the parts they get from the supplier are either good or defective, Tiptop has decided to develop control charts for the attributes. The total number of parts is 200 for every sample. The values of p should range from .01 to .1 incrementing by .01 each time.
Determine the upper and lower control chart limit and the lower control chart limit for various values of the fraction defective (p) in the sample taken. Assume a 99.7 % confidence.
Answer needs to be in Excel