Determine column mean by day and within certain hours
Aug 14, 2012 06:35 PM(9455 views)
Hi Folks,
I have some hourly data and I'm trying to calculate the mean of variable x for each Day when Hour >= 1 and <=10. I need to store this computed value in column y for each hour of each day. I have tried Column Mean by Day where I've excluded all hours that fall outside 1 & 10, but Column Mean calculates the value for all data by Day regardless of what's been excluded. Any suggestions on how to accomplish this using either a formula for column y or in JSL would be greatly appreciated. Thanks