Date: Sun, 8 Dec 2002 11:31:35 -0500
Reply-To: Raynald Levesque <rlevesque@videotron.ca>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: Raynald Levesque <rlevesque@videotron.ca>
Subject: Re: Trying again...
In-Reply-To: <5.1.1.6.2.20021208070111.00bd06d8@pop.starband.net>
Content-type: text/plain; charset=us-ascii
Hi
These are ways to do it:
NEW FILE.
DATA LIST LIST /Time1(TIME8) sacbil(F8).
BEGIN DATA
17:45:59 1
17:46:59 1
17:47:59 2
17:48:59 1
17:52:59 2
17:53:59 4
17:54:59 4
17:55:59 3
17:56:59 5
17:57:59 7
17:58:59 9
17:59:59 4
18:00:59 4
18:01:59 4
18:02:59 6
18:03:59 4
18:04:59 8
18:05:59 4
18:06:59 1
18:07:59 6
18:08:59 7
18:09:59 2
18:10:59 5
18:11:59 5
18:12:59 4
18:13:59 4
END DATA.
LIST.
COMPUTE m1=RND(CTIME.MINUTE(time1)).
COMPUTE m5=TIME.HMS(0,TRUNC(RND(m1/5))*5,0).
FORMATS m5 time1 (TIME6).
GRAPH
/TITLE="Basic data"
/LINE(SIMPLE)=SUM(sacbil) BY time1
/MISSING=REPORT.
GRAPH
/TITLE="Total # per 5 minutes interval"
/LINE(SIMPLE)=SUM(sacbil) BY m5
/MISSING=REPORT.
CREATE mavg=MA(sacbil,5).
GRAPH
/TITLE="5 points Moving Average value"
/LINE(SIMPLE)=VALUE(mavg) BY time1
/MISSING=REPORT.
HTH
Raynald Levesque rlevesque@videotron.ca
Visit my SPSS Pages http://pages.infinit.net/rlevesqu/index.htm
-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU]On Behalf Of
WCS Belize
Sent: December 8, 2002 8:01 AM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Trying again...
Importance: High
Sorry for some reason the spaces in the sample data set were stripped
out... here it is again.
I am trying to summarize bat activity data gathered over 2.5
years. Problem that there is too much data for Excel to handle it in a
simple chart.
I can not get my SPSS chart set up to do what I need either.
Any ideas or suggestions?
Data has been sorted by time in 1 minute intervals with a count of
occurrences of the species during each. All blank time slots (i.e. no
activity) have been removed.
So how do I get a nice simple graph to show the actively pattern over the
time from sunset to sunrise?
I have the data saved as SPSS.SAV file and CSV file as well as in XLS.
Data looks like this : where time is the 1 minute time period the bats were
active and the next column is the total times during 2001 that this species
was active during this time slot.
Time sacbil
17:45:59 1
17:46:59 1
17:47:59 2
17:48:59 1
17:52:59 2
17:53:59 4
17:54:59 4
17:55:59 3
17:56:59 5
17:57:59 7
17:58:59 9
17:59:59 4
18:00:59 4
18:01:59 4
18:02:59 6
18:03:59 4
18:04:59 8
18:05:59 4
18:06:59 1
18:07:59 6
18:08:59 7
18:09:59 2
18:10:59 5
18:11:59 5
18:12:59 4
18:13:59 4
.... and so one to 06:00 for a total of 726 rows.
Being a field biologist I ma by definition statistically challenged....
:-)
Thanks for the great help to all who have offered it on previous queries.
Bruce W. Miller
Associate Conservation Zoologist
Wildlife Conservation Society
(founded in 1895 as the New York Zoological Society)
Gallon Jug, Belize
Mailing address
P.O. Box 37, Belize City
Belize, Central America
NEW Phone/Fax +501-220-9002
Visit the
Belize Biodiversity Information System
or the
Neotropical Bat Information System
at
http://fwie.fw.vt.edu/wcs/
OR
Check out the WCS web site at: http://www.wcs.org
OR
Check out information on the Jaguar Conservation Program at
http://www.savethejaguar.com
