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
|