Timeline for Is it possible to take the mean of hourly data to get a daily data
Current License: CC BY-SA 4.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 23, 2020 at 20:00 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Aug 1, 2019 at 10:29 | comment | added | Dave | @Mary That gets you the average amount per hour during that day, which is a quantity you might find interesting or useful. However, it's not the amount from that day. I'd be very skeptical of my memory of what the supervisor said. Imagine doing this when it's time to pay the restaurant bill. "Expensive steak, \$46. Coke, \$2. I'll average them and pay \$24." | |
| Aug 1, 2019 at 6:50 | comment | added | Mary | @Dave Thank you so much for your nice and helpful comments. In statistic, we usually take the mean of the hourly data to get the daily value. I even remember (a long time ago) my supervisor said that to me. But I never work with such data before. | |
| Jul 31, 2019 at 15:37 | answer | added | Bert | timeline score: 1 | |
| Jul 31, 2019 at 15:01 | answer | added | IrishStat | timeline score: 1 | |
| Jul 31, 2019 at 14:53 | comment | added | Dave | @Mary I really have no idea what alternative you have to adding up the hourly values to find the daily values. It would be like finding your restaurant bill a way other than adding up the prices of each dish (okay, there's tax and tip, but you get the idea). Do you have another idea in mind? | |
| Jul 31, 2019 at 13:54 | comment | added | Mary | @Dave Or sorry, I think I should take the sum of the day to give me the value of the day. | |
| Jul 31, 2019 at 13:15 | comment | added | Dave | Wouldn't it be the sum of what happens in each 1-hour period that gives you the daily value? | |
| Jul 31, 2019 at 12:45 | comment | added | user2974951 | Yes you can do that. However, in aggregating the data you may lose some important patterns, this may or may not be important for your task. | |
| Jul 31, 2019 at 12:38 | history | asked | Mary | CC BY-SA 4.0 |