Again, use the RANDBETWEEN function in Excel. This time generate 200 random numbers between 1 and 100 and output it to one column. Then do the same for until you have 20 columns of which are 200 in length that all have values between 1 and 100.
a. The above generated data is to simulate 20 days of a quality control process. Consider an outcome of 1-5 to be a defect and an outcome of 6-100 to be an acceptable result. Note that this corresponds to a 5% rate of defects.
b. Construct a p chart for the proportion of defective calculators, and determine whether the process is within statistical control. The process is stable with p = 0.05 so a conclusion that it is not stable would be a type I error which means we would have a false positive signal causing use to think that the process should be adjusted when, in fact, it was fine.
c. Simulate another 10 days of manufactoring calculators (as in part a), but modify these 10 so that the defect rate is 10% instead of 5%.
d. Combine the data from parts a) an c) to represent a total of 30 days of results. Contruct a p chart for this combined sample. Is the process out of control or not? If we conclude it is not, we would make a type II error which means that we would believe the process was fine when it shoudl be adjusted to correct the 10% rate of defects.
e. Again, make all your data presentable and report on your findings.