# Compare species count data between sites

I'm comparing species counts between areas. My data is very similar to the below.

Species  Location    count
Yellow-frog Africa  3
Blue-frog   Africa  0
Green-frog  Africa  20
Yellow-frog Europe  0
Blue-frog   Europe  100
Green-frog  Europe  0


I'm not sure about what statistical test to use to compare between sites?? Especially so it takes into account that its zero count data.

My desired output would be to see if there is a statistical difference between:

1. The sites overall
2. Species (i.e. are there more yellow frogs in Europe or Africa).
3. The species within each site (i.e. are there more blue frogs compared to yellow frogs)

My stats knowledge is pretty basic. I assume its regression, but I'm not sure about the family. Poisson regression/ binomial/ Zero-inflated.

[P.s. I'm working in R]

• Present the data in 2x3 contingency table. Can perform Fisher's exact test. – user158565 Dec 23 '18 at 3:32
• Can you tel us some more about how you obtained this data, and what is the question you want to ask the data? – kjetil b halvorsen Dec 23 '18 at 10:07
• Sampling of the species was random, i.e. we would go to a pond and count the number of frogs of each species. The same frog occurs in Europe and Africa. My priority is that I need to know if there are differences in frog species composition between africa and europe. – imasnake Dec 23 '18 at 10:28

| Continent | Species 1 | Species 2 | Species 3 |