[Babase] Please review a darting view

Susan Alberts alberts at duke.edu
Fri Jul 2 16:03:23 EDT 2010


I can see it too, thanks.

It looks fine to me.

I am okay with either stdev or stddev,  but I imagine most people will  
find the first (stdev) easier to manage.

With respect to standard error versus standard deviation, but most  
likely we would calculate standard error for a larger data set, and  
not on an individual by individual basis. The standard error will be a  
function of the sample size, and I'm not sure that we will learn much  
by having that column in this table.

Susan

n Jul 2, 2010, at 3:52 PM, Niki Learn wrote:

> Oops, sorry.  Didn't notice it was a view.  Yeah, I see that table  
> too.  What about standard error?  Much more useful for most things  
> (especially graphing) than standard deviation.  Can we invent sql  
> for standard error without dividing stdev() by sqrt(count())?  (How  
> come babase has two d's in stdev?)
>
> -----Original Message-----
> From: babase-bounces at eeblistserv.Princeton.EDU [mailto:babase-bounces at eeblistserv.Princeton.EDU 
> ] On Behalf Of Karl O. Pinc
> Sent: Friday, July 02, 2010 3:41 PM
> To: The Baboon Database Project
> Subject: Re: [Babase] Please review a darting view
>
> On 07/02/2010 12:25:52 PM, Niki Learn wrote:
>> I see crownrumps.
>
> That's the underlying table.  CROWNRUMP_STATS
> is a view and so shows up in a different place
> in ppa.
>
>>
>> -----Original Message-----
>> From: babase-bounces at eeblistserv.Princeton.EDU
>> [mailto:babase-bounces at eeblistserv.Princeton.EDU] On Behalf Of Karl
>> O.
>> Pinc
>> Sent: Friday, July 02, 2010 12:31 PM
>> To: The Baboon Database Project
>> Subject: Re: [Babase] Please review a darting view
>>
>> On 07/02/2010 11:22:40 AM, Susan Alberts wrote:
>>> Sorry, I am not seeing this in test. Susan
>>
>> crownrump_stats?  (There's no data.)
>>
>> Maybe to see it on the list you need to reload
>> your browser page?
>>
>>> On Jul 2, 2010, at 12:09 PM, Karl O. Pinc wrote:
>>>
>>>> On 07/02/2010 09:24:02 AM, Susan Alberts wrote:
>>>>> Karl,
>>>>>
>>>>> this looks fine to me–very clear and straightforward.
>>>>
>>>> Ok.  The view is now in babase_test and can be tested there.
>>>>
>>>> This is also the last chance to change column names, or
>>>> the table name.  I'll pattern the rest of the views
>>>> off these names.  Some seemed a bit long but were the
>>>> best I could come up with.
>>>>
>>>> FYI, I used the name CRsamps instead of something like
>>>> CRcount because we've counts in the TICKS table and
>>>> it seemed like it would get confusing.
>>>>
>>>>>
>>>>> Susan
>>>>> On Jul 2, 2010, at 1:08 AM, Karl O. Pinc wrote:
>>>>>
>>>>>> Hi,
>>>>>>
>>>>>> Here's CROWNRUMP_STATS, the view that summarizes
>>>>>> multiple crown to rump measurements taken during
>>>>>> a darting.  Please review.
>>>>>>
>>>>>> CROWNRUMP_STATS (Darting Crown-To-Rump Statistics)
>>>>>> http://papio.biology.duke.edu/babase_system_html/ch06s04.html
>>>>>>
>>>>>> Once we work the kinks out of this I'll whack out
>>>>>> the rest of the "summary" views for darting.
>>>>>>
>>>>>>
>>>>>> Karl <kop at meme.com>
>>>>>> Free Software:  "You don't pay back, you pay forward."
>>>>>>               -- Robert A. Heinlein
>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> Babase mailing list
>>>>>> Babase at www.eco.princeton.edu
>>>>>> http://www.eco.princeton.edu/mailman/listinfo/babase
>>>>>
>>>>> ------------------------------------------------------------
>>>>> Susan Alberts, Dept of Biology, Duke University, Box 90338,
>> Durham
>>> NC
>>>>>
>>>>> 27708. Phone 919-660-7272, FAX 919-660-7293
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> Babase mailing list
>>>>> Babase at www.eco.princeton.edu
>>>>> http://www.eco.princeton.edu/mailman/listinfo/babase
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>>
>>>> Karl <kop at meme.com>
>>>> Free Software:  "You don't pay back, you pay forward."
>>>>                -- Robert A. Heinlein
>>>>
>>>>
>>>> _______________________________________________
>>>> Babase mailing list
>>>> Babase at www.eco.princeton.edu
>>>> http://www.eco.princeton.edu/mailman/listinfo/babase
>>>
>>> ------------------------------------------------------------
>>> Susan Alberts, Dept of Biology, Duke University, Box 90338, Durham
>> NC
>>>
>>> 27708. Phone 919-660-7272, FAX 919-660-7293
>>>
>>>
>>>
>>>
>>> _______________________________________________
>>> Babase mailing list
>>> Babase at www.eco.princeton.edu
>>> http://www.eco.princeton.edu/mailman/listinfo/babase
>>>
>>>
>>
>>
>>
>>
>> Karl <kop at meme.com>
>> Free Software:  "You don't pay back, you pay forward."
>>                 -- Robert A. Heinlein
>>
>>
>> _______________________________________________
>> Babase mailing list
>> Babase at www.eco.princeton.edu
>> http://www.eco.princeton.edu/mailman/listinfo/babase
>>
>>
>> _______________________________________________
>> Babase mailing list
>> Babase at www.eco.princeton.edu
>> http://www.eco.princeton.edu/mailman/listinfo/babase
>>
>>
>
>
>
>
> Karl <kop at meme.com>
> Free Software:  "You don't pay back, you pay forward."
>                 -- Robert A. Heinlein
>
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
>
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase

------------------------------------------------------------
Susan Alberts, Dept of Biology, Duke University, Box 90338, Durham NC  
27708. Phone 919-660-7272, FAX 919-660-7293






More information about the Babase mailing list