Posted by
vishal on
Mar 08, 2013; 8:31am
URL: http://spssx-discussion.165.s1.nabble.com/time-interval-and-threshold-making-in-SPSS-or-excel-tp5718477.html
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!
Vishal
vishal suthar