This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Determine column mean by day and within certain hours
Aug 14, 2012 06:35 PM(8968 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