You have to be clear, first, about how many variables you are
intending to create, and what you want their values to represent.
I can imagine 3 or 4 different solutions, for that many different
questions.
Are these supposed to be a summary for the whole 10 days?
Does it matter if the values are consecutive or not? - "This cow
had a maximum time of X1 hours over 40, X2 days over 39.5, X3
days over 39." That could be a summary of sequences. Or you
could have similar recodings to reflect the totals for the time period.
What you want is probably not hard to do, using Aggregate or using
Lag, once you clarify what you want to create as a result. But there
are a lot of choices you need to make.
--
Rich Ulrich
> Date: Fri, 8 Mar 2013 00:31:46 -0800
> From:
[hidden email]> Subject: time interval and threshold making in SPSS or excel
> To:
[hidden email]>
> Dear Sir/ Madum/Friends,
>
> I am a doctorate student working on the continuous body temperature
> measurement in domestic animals. I have measured body temperature at every
> 10 min for 10 days in 25 cows. The measured body temperature range is 37.8
> to 41 ⁰C. After generating the data-set for my research, I produced certain
> thresholds like ≥ 39 ⁰C, ≥ 39.5⁰C and ≥ 40 ⁰C. It is easy with the Record
> Variable in to Different Variable function in Transfer menu of SPSS. Now my
> problem is, I would like to separate body temperature defining above 3
> thresholds including certain time intervals. For example:
>
> 1. ≥ 39 ⁰C for 1hour, 3 hour, 6 hour, 1 day, 3 days etc
> 2. ≥ 39.5 ⁰C for 1hour, 3 hour, 6 hour, 1 day, 3 days etc
> 3. ≥ 40 ⁰C for 1hour, 3 hour, 6 hour, 1 day, 3 days etc
>
> Is it possible in SPSS or Excel? If yes, how?
>
> Please guide me for this this problem.
>
> Below is the example of data table that I have generated:
>
> Cow No Date Time (hh:mm) Days in Milk Body temperature (⁰C)
> 1 20/10/2012 10:10 2 39.0
> 1 20/10/2012 10:20 2 39.1
> 1 20/10/2012 10:30 2 39.1
> 1 20/10/2012 10:40 2 39.1
> 1 20/10/2012 10:50 2 39.1
> 1 20/10/2012 11:00 2 39.2
> For 10 days
> 2 20/10/2012 10:10 2 38.6
> 2 20/10/2012 10:20 2 38.6
> 2 20/10/2012 10:30 2 38.7
> 2 20/10/2012 10:40 2 38.7
> 2 20/10/2012 10:50 2 38.7
> 2 20/10/2012 11:00 2 38.9
> For 10 days
> 3 20/10/2012 10:10 2 38.8
> 3 20/10/2012 10:20 2 38.8
> 3 20/10/2012 10:30 2 38.8
> 3 20/10/2012 10:40 2 38.7
> 3 20/10/2012 10:50 2 38.7
> 3 20/10/2012 11:00 2 38.8
>
> Like viz., I have data for 25 cows
>
> Thanking you in advance!
>...