extracting random sample of utterances

[Javier Aguado Orea]

Caroline,

I made a similar thing some time ago.
Since I was not able to find a CLAN command which could do exactly what
you want to do, I followed this procedure.

First, I imported the full list of utterances with Excel, so that you
get one utterance per cell in a column of the sheet:
Data>Get External Data>Import Text File
Then you create a series of random numbers in the next column with the
function:
"=RAND()"
Finally, you can now sort the list of utterances on the basis of the
second column (the list of random numbers) with:
Data > Sort  and then "Sort by: Column B"
All you have to do now is copy and paste the first 100 cells, the first
200 and so on.

If the random number generated by Excel are not be all the random you
want them to be, try the following website (another person told me
about this website in my previous similar query to Info-Childes):
www.randomizer.org

Javier






On 20 Jul 2004, at 14:00, crowland at liverpool.ac.uk wrote:

> Hi all,
> Is it possible to get one of the CLAN programs to extract random
> samples of
> utterances from a directory of transcripts?
>
> What I want to do is to extract a random sample of 100 CHI utterances
> from some
> transcripts, analyse these, then extract another random sample of 100
> CHI
> utterances (from the same transcripts) and analyse these etc.  Then do
> the same
> for a random sample of 200 CHI utterances, 300 etc.  The rational
> behind this is
> an investigation of the effect of sample size on analyses.
>
> Thanks
>
> Caro
>
>
>
>
>

This message has been scanned but we cannot guarantee that it and any
attachments are free from viruses or other damaging content: you are
advised to perform your own checks.  Email communications with the
University of Nottingham may be monitored as permitted by UK legislation.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: text/enriched
Size: 1875 bytes
Desc: not available
URL: <http://listserv.linguistlist.org/pipermail/chibolts/attachments/20040720/fbf8e2ed/attachment.bin>