N

I am wondering if anyone could please give me advice on my rather simple (I assume) statistical problem.

I am working with animal breeding data. I have two groups of animals, group 1 with both partners from the same region, and group 2 with both partners from different regions. For both groups I have breeding success as a ratio of survived young per eggs laid and hatching success as hatched young per eggs laid.

I thought it is good to work with ratios as the first group has laid 200 eggs in total, while the second group only 50 eggs.

1) I see differences in breeding success between both groups. Group 1 has about 25% and group 2 about 15% breeding success. How would I be able to test whether these differences are significant?

2) I see that in both groups hatching success is larger than breeding success, in group 1 40% and in group 2 20%. How would I be able to test whether the loss (difference between hatching success and breeding success) would be significant within each group and between groups?

I assume because I work with ratios correcting for the differences in egg-number, I don't need to worry about these differences in the statistical tests, correct?

If anyone could give me advice on which may be the most appropriate statistical procedures to follow, I would greatly appreciate. Any suggestions involving Excel, R or SPSS would be great... with simple Excel being my naive preference.

This is my first post here, so I am looking forward to any replies,

Thanks in advance for your thoughts,

N