Excel sample size comparison

#1
I have two independent groups that tested their own sample size (based on their group's sampling rules) of the same data for process failures. Group 1 has substantially larger sample size than Group 2; almost 20 times in size. Both groups then calculate the defect rate (failures/sample size) of the found failures; both defect rates because of the sample sizes are different and I need to find a way to show if the defect rates would be the same if the sample sizes were the same in Excel
 
Last edited: