View Single Post
  #1   Report Post  
CarterTC CarterTC is offline
Junior Member
 
Posts: 3
Default Find number of particular values over an interval

Hi,

I have 22 columns consisting of about 5500 rows aligned by date with each column containing hourly temperatures for a different subject over a several month period. I need to determine the percentage of hourly records that fall above a particular upper temperature limit (26 degrees C in this case) every 7 days for each of the 22 subjects.

Any help would be greatly appreciated.

Thanks,
Carter