saving each minutes value as hourly average for individual dates.
2 views (last 30 days)
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).