[Babase] Total numbers by interact type
Niki Learn
nlearn at princeton.edu
Mon Apr 19 15:34:11 EDT 2010
Okay, I will take a look at some of the cases and see what I find.
Meanwhile:
You also asked about how the numbers for grooming compared, with the idea
that groomings are less likely to actually occur between groups than are
agonisms. That in fact appears to be the case, both by raw numbers and by
proportion of the total. And MCEs are lower still.
Using Karl's warning query he sent earlier, with the following line or lines
added (right before "order by"), I got these results (I am not familiar with
these interact tables and so have not attempted to add gender to these
queries - I have been using actor_actees) out of the 5689 total mismatches
Karl reported:
and interact.act in ('A', 'AS', 'OS', 'DS')
3883 agonisms (all years) - this is 1.29% of all agonisms
and interact.act in ('A', 'AS', 'OS', 'DS')
and interact.date >= '2000-01-01'
and interact.date <= '2008-06-30'
358 agonisms (2000 - 2008a only)
Total agonisms in babase = 300,066; total in 2000-2008a = 10,996
and interact.act = 'G'
1705 groomings (all years) - this is 0.62% of all groomings
and interact.act = 'G'
and interact.date >= '2000-01-01' and interact.date <= '2008-06-30'
520 groomings (2000 - 2008a only)
Total grooming in babase = 274,601; total in 2000-2008a = 104,477
and interact.act in ('P', 'R')
3 approaches/requests to groom (all three were in 2000 -
2008a) - this is 0.38% of total
Total approaches and requests to groom in babase = 787
and interact.act in ('M', 'C', 'E')
98 MCEs (all years) - this is 0.30% of all MCEs
and interact.act in ('M', 'C', 'E')
and interact.date >= '2000-01-01'
and interact.date <= '2008-06-30'
22 MCEs (2000 -2008a only)
Total MCEs in babase = 32,708; total in 2000-2008a = 10,953
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://eeblistserv.Princeton.EDU/pipermail/babase/attachments/20100419/374b12ca/attachment-0001.html
More information about the Babase
mailing list