processing eprime data

Fri Jun 24 18:53:09 UTC 2005

I do the same. Filter, copy to Excel. Our data analyst imports to SPSS & 
takes it from there.

Leisha

Jordan Bigio wrote:

> I do this as well. Hide columns I don't want, then arrange the ones I 
> do. Copy. Paste to excel. Save, and run in SPSS with SPSS syntax for 
> stats we want. Then, save outfiles as excel files, and paste them back 
> into my behavioral stats file (excel as well).
>
> Jordan
>
>
>
> At 05:44 PM 6/23/2005 -0400, Tony Zuccolotto wrote:
>
>> If you are not familiar with the feature, you may be able to save a
>> little bit of work by using E-DataAid's "Tools|Arrange Columns..."
>> dialog.
>>
>> Specifically, you can click the Remove All button on the dialog to
>> remove (hide) all the columns, optionally alphabetize the list of
>> variables, and then double click just the variables that you want to add
>> them back in.
>>
>> If you save the data file it will bring back that same column
>> arrangement the next time you load it, and you can then use the File |
>> Export... option to send the data elsewhere.
>>
>> If you do this early on in your master merged file, save it, and keep
>> reusing it then E-DataAid should save your preferred column arrangement
>> and keep it as the default for that merged file as new data files are
>> added in.
>>
>> ...not totally automated, but may save a few repetitive steps or a lot
>> of adding and deleting using Excel.
>>
>> -Tony
>>
>> > -----Original Message-----
>> > From: eprime at mail.talkbank.org [mailto:eprime at mail.talkbank.org] On
>> Behalf
>> > Of Paul Warren
>> > Sent: Thursday, June 23, 2005 5:29 PM
>> > To: eprime at mail.talkbank.org
>> > Subject: RE: processing eprime data
>> >
>> > I use a similar strategy to Dave, i.e. E-merge then Excel and then
>> stats
>> > either in Excel (with the statistiXL product) or in SPSS. But I
>> haven't
>> > come to grips with macros in Excel for stripping out the dross. Maybe
>> Dave
>> > could make his macros available?
>> >
>> > Paul
>> >
>> > Dr Paul Warren
>> > School of Linguistics and Applied Language Studies
>> > Victoria University of Wellington
>> > New Zealand
>> >
>> > tel +64 4 463 5631/5600
>> > fax +64 4 463 5604
>> >
>> >
>> >
>> > | -----Original Message-----
>> > | From: David Hairston [mailto:dhair at wfubmc.edu]
>> > | Sent: Friday, 24 June 2005 9:20 a.m.
>> > | To: Michael J. Crowley; eprime at mail.talkbank.org
>> > | Subject: RE: processing eprime data
>> > |
>> > |
>> > | As a general rule, I do not use E-Data Aid at all; I use SPSS
>> > | for 90% of
>> > | my analyses, and Excel for transitioning the data between
>> > | E-Data Aid and
>> > | SPSS. Personally since I know that I'll need everything in SPSS for
>> > | eventual stats, groups for figures, etc etc, I find it easier to go
>> > | there directly.
>> > | So, when the experiment is done, I immediately group it via E-Merge,
>> > | then export into Excel Test format... then I open it via Excel, and
>> go
>> > | through and trim out all the stuff I don't want (Mike I know what
>> you
>> > | mean about a LOT of irrelevant stuff). The nice thing about doing
>> this
>> > | in Excel is that you can easily record a macro to delete all
>> > | the things
>> > | you don't want, so you can do it again later w/ a few clicks.
>> > | This also
>> > | gives me a chance to change variable names to be SPSS-friendly, etc.
>> > | Then I just port it back out into tab-delineated text, and import
>> into
>> > | SPSS from there.
>> > |
>> > | I, too, am curious to see what other folks do...
>> > |
>> > | Unfortunately as a result I do not know how to handle the block/
>> NULL
>> > | data in E-data-Aid, sorry.
>> > |
>> > | Dave
>> > |
>> > | W. David Hairston
>> > | Neurobiology and Anatomy
>> > |
>> > | Wake Forest University School of Medicine
>> > | Winston-Salem, NC 27157
>> > | (336) 716-4481 (lab)
>> > | http://www.wfubmc.edu/nba/XMODAL/
>> > |
>> > | -----Original Message-----
>> > | From: eprime at mail.talkbank.org [mailto:eprime at mail.talkbank.org] On
>> > | Behalf Of Michael J. Crowley
>> > | Sent: Thursday, June 23, 2005 5:10 PM
>> > | To: eprime at mail.talkbank.org
>> > | Subject: processing eprime data
>> > |
>> > | Dear List,
>> > |
>> > | I'm wondering how much preprocessing people are doing in edata aid
>> > | before going
>> > | to a stat package.  I've seen that most postings reflect programming
>> > | issues and
>> > | I'm wondering how people are processing their data,
>> > | post-collection from
>> > | edata
>> > | aid. I'm hoping that his post will open this for discussion.
>> > |
>> > | Because data is stored trial variable by block, there are
>> > | many null data
>> > | values.
>> > |  Is there any ideal way for handling this in edata aid?
>> > |
>> > | Also, some of the data we've opted to store, in retrospect, are
>> > | irrelevant.  Is
>> > | their a way to batch process files in edata aid to drop irrelevant
>> > | variables?
>> > |
>> > | Thank you for all your responses.  If there is a good response to
>> this
>> > | post, I
>> > | will compile the feedback for the list.
>> > |
>> > | best wishes,
>> > |
>> > | Mike Crowley
>> > |
>> > |
>> > |
>> > | Michael J. Crowley, Ph.D.
>> > | Yale Child Study Center
>> > | 230 South Frontage Rd.
>> > | New Haven, CT 06520
>> > |
>> > |
>> > |
>> > | Please be aware that email communication can be
>> > | intercepted in transmission or misdirected. Please
>> > | consider communicating any sensitive information
>> > | by telephone, fax or mail. The information
>> > | contained in this message may be privileged and
>> > | confidential. If you are NOT the intended
>> > | recipient, please notify the sender immediately
>> > | with a copy to hipaa.security at yale.edu and destroy
>> > | this message.
>> > |
>> > |
>> > |
>
>
> Jordan D. Bigio, B.A.
> Project Coordinator
> Developmental Cognitive Neuroscience Laboratory
> Department of Communication Sciences and Disorders
> Northwestern University
> 2240 N. Campus Dr., Frances Searle Building, Rm. 2-342
> Evanston, IL 60208
> Phone: 847-491-3647
>
>
>