A manufacturing company’s quality control personnel have recorded the proportion of defective items for each of 500 monthly shipments of one of the computer components that the company produces. The data are in the file P2_2.XLS. The quality control department manager does not have sufficient time to review all of these data. Rather, she would like to examine the proportions of defective items for a systematic sample of 50 shipments.

a. Use Excel to generate such a systematic sample from the given frame.

b. What are the advantages and disadvantages of the sampling method requested by this quality control manager?