saving each minutes value as hourly average for individual dates.
2 views (last 30 days)
Show older comments
navan on 11 May 2016
Answered: Chad Greene 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).
Find more on Dates and Time in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!Start Hunting!