# saving each minutes value as hourly average for individual dates.

2 views (last 30 days)
navan on 11 May 2016
In my analysis i want to find out the hourly average of my data point for each individual day. My data points are in minutes. (For each hour, i have to average my minutes data points) .I have to find this hourly averages of data point for an entire day. The same thing should repeat for other days too. I have put the theme of the trouble . Kindy help.
data set :
Date=20-dec Hour=[1AM, 2AM] values for 1AM=[1,2,3,4,5] value for 2AM=[10,15,20,25,30]
Date= 21- Dec Hour=[1AM, 2AM] values for 1AM=[10,20,30,40,50] value for 2AM=[100,150,200,250,300]
I want to identify the average value for each hour corresponding to date.
Ans expected: date:20 dec-1AM- 3 (3 is the average value of 1AM of Dec 20th). date:20 dec-2AM-20 (20 is the average value of 2AM of dec 20th). date:21 dec-1AM- 30 (30 is the average value of 1AM of Dec 20th). date:20 dec-2AM-200 (200 is the average value of 2AM of dec 20th).

Chad Greene on 11 May 2016
If you can get your time into datenum format, you can use my downsample_ts function.