In particular, I was asked this question: "If I have a data point for every minute of the data, I also have an average of 15 data points for every 15 minute period of the day, and I wanted to calculate the daily average, it would be better to use the 1 minute data versus the 15 minute averages (aka rollup data). The average of the 15 minute averages would really be an average of averages and is therefore not accurate."
The reality is actually contrary to that thinking. The average of averages of data is exactly the same as the average of the same source data. To illustrate this, let's look at some data.
Below, we have random numbers between 0 and 100 to represent our data. We have one data point for each minute of the day. Every 15 minutes, an average is calculated. For example, at 0:30 an average is calculated averaging the points from 0:30-0:44.
Time | 1 Minute Data | 15 Minute Average |
0:00 | 37 | 51.6666666666667 |
0:01 | 74 | |
0:02 | 49 | |
0:03 | 21 | |
0:04 | 59 | |
0:05 | 15 | |
0:06 | 32 | |
0:07 | 69 | |
0:08 | 40 | |
0:09 | 26 | |
0:10 | 87 | |
0:11 | 38 | |
0:12 | 96 | |
0:13 | 79 | |
0:14 | 53 | |
0:15 | 60 | 25.8 |
0:16 | 35 | |
0:17 | 7 | |
0:18 | 24 | |
0:19 | 46 | |
0:20 | 3 | |
0:21 | 22 | |
0:22 | 1 | |
0:23 | 39 | |
0:24 | 9 | |
0:25 | 34 | |
0:26 | 0 | |
0:27 | 42 | |
0:28 | 34 | |
0:29 | 31 | |
0:30 | 4 | 33.8 |
0:31 | 5 | |
0:32 | 81 | |
0:33 | 36 | |
0:34 | 35 | |
0:35 | 9 | |
0:36 | 36 | |
0:37 | 41 | |
0:38 | 76 | |
0:39 | 93 | |
0:40 | 21 | |
0:41 | 12 | |
0:42 | 10 | |
0:43 | 21 | |
0:44 | 27 | |
0:45 | 5 | 48.8 |
0:46 | 42 | |
0:47 | 83 | |
0:48 | 48 | |
0:49 | 18 | |
0:50 | 79 | |
0:51 | 24 | |
0:52 | 78 | |
0:53 | 19 | |
0:54 | 5 | |
0:55 | 52 | |
0:56 | 100 | |
0:57 | 39 | |
0:58 | 70 | |
0:59 | 70 | |
1:00 | 14 | 44.0666666666667 |
1:01 | 45 | |
1:02 | 82 | |
1:03 | 34 | |
1:04 | 74 | |
1:05 | 90 | |
1:06 | 33 | |
1:07 | 10 | |
1:08 | 43 | |
1:09 | 24 | |
1:10 | 96 | |
1:11 | 12 | |
1:12 | 17 | |
1:13 | 62 | |
1:14 | 25 | |
1:15 | 96 | 54.7333333333333 |
1:16 | 19 | |
1:17 | 91 | |
1:18 | 58 | |
1:19 | 76 | |
1:20 | 24 | |
1:21 | 86 | |
1:22 | 35 | |
1:23 | 48 | |
1:24 | 31 | |
1:25 | 67 | |
1:26 | 72 | |
1:27 | 9 | |
1:28 | 45 | |
1:29 | 64 | |
1:30 | 79 | 40.4 |
1:31 | 68 | |
1:32 | 0 | |
1:33 | 10 | |
1:34 | 30 | |
1:35 | 23 | |
1:36 | 65 | |
1:37 | 74 | |
1:38 | 53 | |
1:39 | 78 | |
1:40 | 4 | |
1:41 | 3 | |
1:42 | 38 | |
1:43 | 78 | |
1:44 | 3 | |
1:45 | 91 | 47.6 |
1:46 | 85 | |
1:47 | 44 | |
1:48 | 4 | |
1:49 | 6 | |
1:50 | 13 | |
1:51 | 39 | |
1:52 | 93 | |
1:53 | 52 | |
1:54 | 35 | |
1:55 | 49 | |
1:56 | 69 | |
1:57 | 67 | |
1:58 | 64 | |
1:59 | 3 | |
2:00 | 11 | 56.8666666666667 |
2:01 | 72 | |
2:02 | 54 | |
2:03 | 45 | |
2:04 | 16 | |
2:05 | 17 | |
2:06 | 75 | |
2:07 | 96 | |
2:08 | 96 | |
2:09 | 62 | |
2:10 | 80 | |
2:11 | 55 | |
2:12 | 96 | |
2:13 | 34 | |
2:14 | 44 | |
2:15 | 73 | 46.6666666666667 |
2:16 | 57 | |
2:17 | 21 | |
2:18 | 61 | |
2:19 | 28 | |
2:20 | 11 | |
2:21 | 16 | |
2:22 | 1 | |
2:23 | 86 | |
2:24 | 23 | |
2:25 | 64 | |
2:26 | 89 | |
2:27 | 46 | |
2:28 | 38 | |
2:29 | 86 | |
2:30 | 42 | 45.8 |
2:31 | 15 | |
2:32 | 7 | |
2:33 | 3 | |
2:34 | 40 | |
2:35 | 41 | |
2:36 | 8 | |
2:37 | 66 | |
2:38 | 1 | |
2:39 | 85 | |
2:40 | 59 | |
2:41 | 89 | |
2:42 | 94 | |
2:43 | 42 | |
2:44 | 95 | |
2:45 | 64 | 57.6 |
2:46 | 58 | |
2:47 | 6 | |
2:48 | 14 | |
2:49 | 17 | |
2:50 | 100 | |
2:51 | 85 | |
2:52 | 72 | |
2:53 | 93 | |
2:54 | 58 | |
2:55 | 100 | |
2:56 | 32 | |
2:57 | 53 | |
2:58 | 36 | |
2:59 | 76 | |
3:00 | 4 | 38.7333333333333 |
3:01 | 19 | |
3:02 | 32 | |
3:03 | 14 | |
3:04 | 84 | |
3:05 | 26 | |
3:06 | 17 | |
3:07 | 65 | |
3:08 | 20 | |
3:09 | 15 | |
3:10 | 26 | |
3:11 | 52 | |
3:12 | 79 | |
3:13 | 31 | |
3:14 | 97 | |
3:15 | 8 | 55.6666666666667 |
3:16 | 47 | |
3:17 | 87 | |
3:18 | 66 | |
3:19 | 23 | |
3:20 | 88 | |
3:21 | 28 | |
3:22 | 53 | |
3:23 | 87 | |
3:24 | 66 | |
3:25 | 32 | |
3:26 | 71 | |
3:27 | 87 | |
3:28 | 10 | |
3:29 | 82 | |
3:30 | 84 | 54.9333333333333 |
3:31 | 81 | |
3:32 | 54 | |
3:33 | 88 | |
3:34 | 77 | |
3:35 | 98 | |
3:36 | 2 | |
3:37 | 15 | |
3:38 | 92 | |
3:39 | 72 | |
3:40 | 16 | |
3:41 | 45 | |
3:42 | 4 | |
3:43 | 60 | |
3:44 | 36 | |
3:45 | 84 | 63.4666666666667 |
3:46 | 97 | |
3:47 | 87 | |
3:48 | 29 | |
3:49 | 53 | |
3:50 | 11 | |
3:51 | 84 | |
3:52 | 83 | |
3:53 | 76 | |
3:54 | 64 | |
3:55 | 50 | |
3:56 | 36 | |
3:57 | 83 | |
3:58 | 38 | |
3:59 | 77 | |
4:00 | 3 | 64.1333333333333 |
4:01 | 79 | |
4:02 | 90 | |
4:03 | 91 | |
4:04 | 46 | |
4:05 | 53 | |
4:06 | 26 | |
4:07 | 77 | |
4:08 | 46 | |
4:09 | 62 | |
4:10 | 60 | |
4:11 | 93 | |
4:12 | 78 | |
4:13 | 92 | |
4:14 | 66 | |
4:15 | 35 | 37.1333333333333 |
4:16 | 81 | |
4:17 | 42 | |
4:18 | 50 | |
4:19 | 14 | |
4:20 | 26 | |
4:21 | 72 | |
4:22 | 4 | |
4:23 | 15 | |
4:24 | 65 | |
4:25 | 14 | |
4:26 | 9 | |
4:27 | 10 | |
4:28 | 38 | |
4:29 | 82 | |
4:30 | 14 | 51 |
4:31 | 48 | |
4:32 | 62 | |
4:33 | 36 | |
4:34 | 89 | |
4:35 | 3 | |
4:36 | 53 | |
4:37 | 58 | |
4:38 | 86 | |
4:39 | 71 | |
4:40 | 49 | |
4:41 | 67 | |
4:42 | 20 | |
4:43 | 96 | |
4:44 | 13 | |
4:45 | 0 | 47.3333333333333 |
4:46 | 91 | |
4:47 | 64 | |
4:48 | 28 | |
4:49 | 96 | |
4:50 | 23 | |
4:51 | 37 | |
4:52 | 37 | |
4:53 | 77 | |
4:54 | 15 | |
4:55 | 13 | |
4:56 | 98 | |
4:57 | 7 | |
4:58 | 58 | |
4:59 | 66 | |
5:00 | 48 | 48.6 |
5:01 | 22 | |
5:02 | 5 | |
5:03 | 76 | |
5:04 | 96 | |
5:05 | 5 | |
5:06 | 10 | |
5:07 | 3 | |
5:08 | 34 | |
5:09 | 56 | |
5:10 | 82 | |
5:11 | 96 | |
5:12 | 58 | |
5:13 | 80 | |
5:14 | 58 | |
5:15 | 48 | 48.1333333333333 |
5:16 | 30 | |
5:17 | 50 | |
5:18 | 71 | |
5:19 | 12 | |
5:20 | 12 | |
5:21 | 98 | |
5:22 | 24 | |
5:23 | 41 | |
5:24 | 21 | |
5:25 | 66 | |
5:26 | 24 | |
5:27 | 99 | |
5:28 | 73 | |
5:29 | 53 | |
5:30 | 8 | 37.3333333333333 |
5:31 | 67 | |
5:32 | 17 | |
5:33 | 0 | |
5:34 | 0 | |
5:35 | 37 | |
5:36 | 51 | |
5:37 | 33 | |
5:38 | 28 | |
5:39 | 58 | |
5:40 | 3 | |
5:41 | 74 | |
5:42 | 79 | |
5:43 | 90 | |
5:44 | 15 | |
5:45 | 56 | 55.7333333333333 |
5:46 | 82 | |
5:47 | 66 | |
5:48 | 64 | |
5:49 | 69 | |
5:50 | 94 | |
5:51 | 81 | |
5:52 | 23 | |
5:53 | 22 | |
5:54 | 41 | |
5:55 | 16 | |
5:56 | 89 | |
5:57 | 47 | |
5:58 | 74 | |
5:59 | 12 | |
6:00 | 70 | 49.2666666666667 |
6:01 | 72 | |
6:02 | 76 | |
6:03 | 28 | |
6:04 | 62 | |
6:05 | 28 | |
6:06 | 46 | |
6:07 | 62 | |
6:08 | 61 | |
6:09 | 34 | |
6:10 | 52 | |
6:11 | 69 | |
6:12 | 12 | |
6:13 | 37 | |
6:14 | 30 | |
6:15 | 79 | 51.8666666666667 |
6:16 | 35 | |
6:17 | 74 | |
6:18 | 71 | |
6:19 | 12 | |
6:20 | 52 | |
6:21 | 72 | |
6:22 | 6 | |
6:23 | 89 | |
6:24 | 16 | |
6:25 | 17 | |
6:26 | 30 | |
6:27 | 64 | |
6:28 | 76 | |
6:29 | 85 | |
6:30 | 47 | 42.8666666666667 |
6:31 | 44 | |
6:32 | 46 | |
6:33 | 46 | |
6:34 | 2 | |
6:35 | 83 | |
6:36 | 12 | |
6:37 | 24 | |
6:38 | 47 | |
6:39 | 94 | |
6:40 | 32 | |
6:41 | 70 | |
6:42 | 70 | |
6:43 | 24 | |
6:44 | 2 | |
6:45 | 77 | 54.2 |
6:46 | 1 | |
6:47 | 27 | |
6:48 | 47 | |
6:49 | 18 | |
6:50 | 75 | |
6:51 | 46 | |
6:52 | 83 | |
6:53 | 58 | |
6:54 | 24 | |
6:55 | 58 | |
6:56 | 81 | |
6:57 | 65 | |
6:58 | 57 | |
6:59 | 96 | |
7:00 | 34 | 66.8666666666667 |
7:01 | 99 | |
7:02 | 79 | |
7:03 | 75 | |
7:04 | 89 | |
7:05 | 92 | |
7:06 | 63 | |
7:07 | 47 | |
7:08 | 49 | |
7:09 | 93 | |
7:10 | 45 | |
7:11 | 40 | |
7:12 | 97 | |
7:13 | 41 | |
7:14 | 60 | |
7:15 | 56 | 52.0666666666667 |
7:16 | 71 | |
7:17 | 92 | |
7:18 | 31 | |
7:19 | 68 | |
7:20 | 1 | |
7:21 | 3 | |
7:22 | 64 | |
7:23 | 21 | |
7:24 | 7 | |
7:25 | 82 | |
7:26 | 8 | |
7:27 | 99 | |
7:28 | 96 | |
7:29 | 82 | |
7:30 | 97 | 51.4 |
7:31 | 5 | |
7:32 | 1 | |
7:33 | 82 | |
7:34 | 67 | |
7:35 | 30 | |
7:36 | 29 | |
7:37 | 89 | |
7:38 | 53 | |
7:39 | 80 | |
7:40 | 14 | |
7:41 | 88 | |
7:42 | 73 | |
7:43 | 36 | |
7:44 | 27 | |
7:45 | 53 | 47.4666666666667 |
7:46 | 47 | |
7:47 | 55 | |
7:48 | 4 | |
7:49 | 46 | |
7:50 | 65 | |
7:51 | 47 | |
7:52 | 21 | |
7:53 | 25 | |
7:54 | 51 | |
7:55 | 87 | |
7:56 | 24 | |
7:57 | 46 | |
7:58 | 75 | |
7:59 | 66 | |
8:00 | 63 | 41.5333333333333 |
8:01 | 46 | |
8:02 | 69 | |
8:03 | 58 | |
8:04 | 14 | |
8:05 | 21 | |
8:06 | 83 | |
8:07 | 75 | |
8:08 | 23 | |
8:09 | 12 | |
8:10 | 60 | |
8:11 | 63 | |
8:12 | 6 | |
8:13 | 9 | |
8:14 | 21 | |
8:15 | 53 | 40.6 |
8:16 | 42 | |
8:17 | 22 | |
8:18 | 0 | |
8:19 | 65 | |
8:20 | 6 | |
8:21 | 66 | |
8:22 | 16 | |
8:23 | 85 | |
8:24 | 8 | |
8:25 | 78 | |
8:26 | 44 | |
8:27 | 86 | |
8:28 | 30 | |
8:29 | 8 | |
8:30 | 98 | 68.3333333333333 |
8:31 | 81 | |
8:32 | 93 | |
8:33 | 66 | |
8:34 | 60 | |
8:35 | 27 | |
8:36 | 84 | |
8:37 | 62 | |
8:38 | 81 | |
8:39 | 76 | |
8:40 | 94 | |
8:41 | 19 | |
8:42 | 60 | |
8:43 | 38 | |
8:44 | 86 | |
8:45 | 92 | 47.7333333333333 |
8:46 | 39 | |
8:47 | 18 | |
8:48 | 49 | |
8:49 | 36 | |
8:50 | 57 | |
8:51 | 59 | |
8:52 | 84 | |
8:53 | 8 | |
8:54 | 36 | |
8:55 | 14 | |
8:56 | 48 | |
8:57 | 51 | |
8:58 | 67 | |
8:59 | 58 | |
9:00 | 73 | 44.7333333333333 |
9:01 | 90 | |
9:02 | 59 | |
9:03 | 2 | |
9:04 | 1 | |
9:05 | 2 | |
9:06 | 33 | |
9:07 | 51 | |
9:08 | 33 | |
9:09 | 81 | |
9:10 | 2 | |
9:11 | 93 | |
9:12 | 79 | |
9:13 | 18 | |
9:14 | 54 | |
9:15 | 87 | 48.8666666666667 |
9:16 | 75 | |
9:17 | 33 | |
9:18 | 19 | |
9:19 | 24 | |
9:20 | 14 | |
9:21 | 45 | |
9:22 | 13 | |
9:23 | 93 | |
9:24 | 54 | |
9:25 | 69 | |
9:26 | 12 | |
9:27 | 2 | |
9:28 | 99 | |
9:29 | 94 | |
9:30 | 42 | 44.4666666666667 |
9:31 | 70 | |
9:32 | 83 | |
9:33 | 20 | |
9:34 | 66 | |
9:35 | 10 | |
9:36 | 35 | |
9:37 | 74 | |
9:38 | 18 | |
9:39 | 35 | |
9:40 | 7 | |
9:41 | 64 | |
9:42 | 67 | |
9:43 | 55 | |
9:44 | 21 | |
9:45 | 48 | 53.4 |
9:46 | 91 | |
9:47 | 88 | |
9:48 | 3 | |
9:49 | 11 | |
9:50 | 45 | |
9:51 | 8 | |
9:52 | 20 | |
9:53 | 96 | |
9:54 | 17 | |
9:55 | 76 | |
9:56 | 78 | |
9:57 | 54 | |
9:58 | 99 | |
9:59 | 67 | |
10:00 | 18 | 53.5333333333333 |
10:01 | 52 | |
10:02 | 33 | |
10:03 | 19 | |
10:04 | 65 | |
10:05 | 88 | |
10:06 | 56 | |
10:07 | 99 | |
10:08 | 18 | |
10:09 | 98 | |
10:10 | 50 | |
10:11 | 46 | |
10:12 | 42 | |
10:13 | 53 | |
10:14 | 66 | |
10:15 | 61 | 58.5333333333333 |
10:16 | 84 | |
10:17 | 66 | |
10:18 | 44 | |
10:19 | 43 | |
10:20 | 8 | |
10:21 | 26 | |
10:22 | 77 | |
10:23 | 55 | |
10:24 | 85 | |
10:25 | 6 | |
10:26 | 91 | |
10:27 | 66 | |
10:28 | 66 | |
10:29 | 100 | |
10:30 | 74 | 46.3333333333333 |
10:31 | 70 | |
10:32 | 10 | |
10:33 | 72 | |
10:34 | 35 | |
10:35 | 19 | |
10:36 | 86 | |
10:37 | 72 | |
10:38 | 7 | |
10:39 | 31 | |
10:40 | 95 | |
10:41 | 35 | |
10:42 | 46 | |
10:43 | 2 | |
10:44 | 41 | |
10:45 | 45 | 46.3333333333333 |
10:46 | 85 | |
10:47 | 3 | |
10:48 | 11 | |
10:49 | 48 | |
10:50 | 90 | |
10:51 | 59 | |
10:52 | 40 | |
10:53 | 26 | |
10:54 | 9 | |
10:55 | 94 | |
10:56 | 7 | |
10:57 | 70 | |
10:58 | 31 | |
10:59 | 77 | |
11:00 | 67 | 47 |
11:01 | 78 | |
11:02 | 59 | |
11:03 | 0 | |
11:04 | 70 | |
11:05 | 77 | |
11:06 | 71 | |
11:07 | 49 | |
11:08 | 51 | |
11:09 | 63 | |
11:10 | 21 | |
11:11 | 21 | |
11:12 | 50 | |
11:13 | 11 | |
11:14 | 17 | |
11:15 | 4 | 46.9333333333333 |
11:16 | 54 | |
11:17 | 9 | |
11:18 | 49 | |
11:19 | 30 | |
11:20 | 82 | |
11:21 | 41 | |
11:22 | 22 | |
11:23 | 33 | |
11:24 | 29 | |
11:25 | 78 | |
11:26 | 88 | |
11:27 | 37 | |
11:28 | 84 | |
11:29 | 64 | |
11:30 | 23 | 47.4666666666667 |
11:31 | 50 | |
11:32 | 8 | |
11:33 | 50 | |
11:34 | 24 | |
11:35 | 84 | |
11:36 | 53 | |
11:37 | 78 | |
11:38 | 80 | |
11:39 | 2 | |
11:40 | 61 | |
11:41 | 89 | |
11:42 | 77 | |
11:43 | 16 | |
11:44 | 17 | |
11:45 | 19 | 36.2666666666667 |
11:46 | 64 | |
11:47 | 85 | |
11:48 | 9 | |
11:49 | 30 | |
11:50 | 24 | |
11:51 | 5 | |
11:52 | 10 | |
11:53 | 59 | |
11:54 | 7 | |
11:55 | 42 | |
11:56 | 21 | |
11:57 | 69 | |
11:58 | 55 | |
11:59 | 45 | |
12:00 | 37 | 48.0666666666667 |
12:01 | 60 | |
12:02 | 85 | |
12:03 | 44 | |
12:04 | 28 | |
12:05 | 89 | |
12:06 | 35 | |
12:07 | 18 | |
12:08 | 48 | |
12:09 | 64 | |
12:10 | 3 | |
12:11 | 38 | |
12:12 | 96 | |
12:13 | 5 | |
12:14 | 71 | |
12:15 | 71 | 46.4 |
12:16 | 93 | |
12:17 | 37 | |
12:18 | 7 | |
12:19 | 38 | |
12:20 | 85 | |
12:21 | 28 | |
12:22 | 86 | |
12:23 | 12 | |
12:24 | 65 | |
12:25 | 38 | |
12:26 | 6 | |
12:27 | 66 | |
12:28 | 24 | |
12:29 | 40 | |
12:30 | 26 | 42 |
12:31 | 98 | |
12:32 | 74 | |
12:33 | 13 | |
12:34 | 46 | |
12:35 | 52 | |
12:36 | 39 | |
12:37 | 14 | |
12:38 | 38 | |
12:39 | 25 | |
12:40 | 28 | |
12:41 | 30 | |
12:42 | 44 | |
12:43 | 63 | |
12:44 | 40 | |
12:45 | 96 | 41.0666666666667 |
12:46 | 13 | |
12:47 | 50 | |
12:48 | 8 | |
12:49 | 43 | |
12:50 | 27 | |
12:51 | 38 | |
12:52 | 97 | |
12:53 | 0 | |
12:54 | 11 | |
12:55 | 84 | |
12:56 | 73 | |
12:57 | 11 | |
12:58 | 20 | |
12:59 | 45 | |
13:00 | 39 | 60.1333333333333 |
13:01 | 94 | |
13:02 | 95 | |
13:03 | 82 | |
13:04 | 39 | |
13:05 | 26 | |
13:06 | 80 | |
13:07 | 70 | |
13:08 | 19 | |
13:09 | 79 | |
13:10 | 74 | |
13:11 | 78 | |
13:12 | 16 | |
13:13 | 20 | |
13:14 | 91 | |
13:15 | 58 | 46 |
13:16 | 67 | |
13:17 | 52 | |
13:18 | 55 | |
13:19 | 47 | |
13:20 | 25 | |
13:21 | 8 | |
13:22 | 78 | |
13:23 | 53 | |
13:24 | 55 | |
13:25 | 43 | |
13:26 | 9 | |
13:27 | 28 | |
13:28 | 56 | |
13:29 | 56 | |
13:30 | 26 | 27.7333333333333 |
13:31 | 5 | |
13:32 | 17 | |
13:33 | 2 | |
13:34 | 53 | |
13:35 | 9 | |
13:36 | 5 | |
13:37 | 63 | |
13:38 | 91 | |
13:39 | 46 | |
13:40 | 7 | |
13:41 | 23 | |
13:42 | 25 | |
13:43 | 3 | |
13:44 | 41 | |
13:45 | 94 | 49.0666666666667 |
13:46 | 70 | |
13:47 | 49 | |
13:48 | 60 | |
13:49 | 59 | |
13:50 | 51 | |
13:51 | 71 | |
13:52 | 16 | |
13:53 | 37 | |
13:54 | 31 | |
13:55 | 13 | |
13:56 | 64 | |
13:57 | 76 | |
13:58 | 30 | |
13:59 | 15 | |
14:00 | 0 | 32.5333333333333 |
14:01 | 6 | |
14:02 | 7 | |
14:03 | 13 | |
14:04 | 52 | |
14:05 | 25 | |
14:06 | 53 | |
14:07 | 15 | |
14:08 | 65 | |
14:09 | 70 | |
14:10 | 72 | |
14:11 | 12 | |
14:12 | 23 | |
14:13 | 23 | |
14:14 | 52 | |
14:15 | 87 | 50.9333333333333 |
14:16 | 98 | |
14:17 | 24 | |
14:18 | 60 | |
14:19 | 32 | |
14:20 | 31 | |
14:21 | 10 | |
14:22 | 63 | |
14:23 | 28 | |
14:24 | 20 | |
14:25 | 42 | |
14:26 | 90 | |
14:27 | 43 | |
14:28 | 81 | |
14:29 | 55 | |
14:30 | 60 | 53.7333333333333 |
14:31 | 45 | |
14:32 | 98 | |
14:33 | 96 | |
14:34 | 11 | |
14:35 | 14 | |
14:36 | 3 | |
14:37 | 97 | |
14:38 | 63 | |
14:39 | 29 | |
14:40 | 23 | |
14:41 | 96 | |
14:42 | 35 | |
14:43 | 89 | |
14:44 | 47 | |
14:45 | 67 | 58.4666666666667 |
14:46 | 41 | |
14:47 | 66 | |
14:48 | 70 | |
14:49 | 98 | |
14:50 | 47 | |
14:51 | 37 | |
14:52 | 68 | |
14:53 | 61 | |
14:54 | 16 | |
14:55 | 70 | |
14:56 | 19 | |
14:57 | 46 | |
14:58 | 100 | |
14:59 | 71 | |
15:00 | 97 | 56.7333333333333 |
15:01 | 65 | |
15:02 | 99 | |
15:03 | 60 | |
15:04 | 54 | |
15:05 | 3 | |
15:06 | 60 | |
15:07 | 79 | |
15:08 | 30 | |
15:09 | 50 | |
15:10 | 37 | |
15:11 | 54 | |
15:12 | 51 | |
15:13 | 63 | |
15:14 | 49 | |
15:15 | 27 | 43.0666666666667 |
15:16 | 10 | |
15:17 | 77 | |
15:18 | 82 | |
15:19 | 15 | |
15:20 | 55 | |
15:21 | 68 | |
15:22 | 74 | |
15:23 | 11 | |
15:24 | 0 | |
15:25 | 72 | |
15:26 | 49 | |
15:27 | 62 | |
15:28 | 41 | |
15:29 | 3 | |
15:30 | 54 | 64.8666666666667 |
15:31 | 86 | |
15:32 | 95 | |
15:33 | 31 | |
15:34 | 45 | |
15:35 | 71 | |
15:36 | 100 | |
15:37 | 59 | |
15:38 | 43 | |
15:39 | 15 | |
15:40 | 88 | |
15:41 | 3 | |
15:42 | 97 | |
15:43 | 88 | |
15:44 | 98 | |
15:45 | 76 | 49.7333333333333 |
15:46 | 17 | |
15:47 | 82 | |
15:48 | 34 | |
15:49 | 64 | |
15:50 | 85 | |
15:51 | 52 | |
15:52 | 29 | |
15:53 | 60 | |
15:54 | 76 | |
15:55 | 16 | |
15:56 | 12 | |
15:57 | 64 | |
15:58 | 52 | |
15:59 | 27 | |
16:00 | 84 | 42.8 |
16:01 | 10 | |
16:02 | 11 | |
16:03 | 13 | |
16:04 | 99 | |
16:05 | 29 | |
16:06 | 64 | |
16:07 | 29 | |
16:08 | 20 | |
16:09 | 64 | |
16:10 | 36 | |
16:11 | 14 | |
16:12 | 38 | |
16:13 | 69 | |
16:14 | 62 | |
16:15 | 96 | 52.0666666666667 |
16:16 | 39 | |
16:17 | 10 | |
16:18 | 80 | |
16:19 | 88 | |
16:20 | 14 | |
16:21 | 2 | |
16:22 | 4 | |
16:23 | 54 | |
16:24 | 25 | |
16:25 | 78 | |
16:26 | 88 | |
16:27 | 99 | |
16:28 | 89 | |
16:29 | 15 | |
16:30 | 73 | 56 |
16:31 | 68 | |
16:32 | 29 | |
16:33 | 43 | |
16:34 | 26 | |
16:35 | 54 | |
16:36 | 13 | |
16:37 | 100 | |
16:38 | 89 | |
16:39 | 33 | |
16:40 | 48 | |
16:41 | 35 | |
16:42 | 92 | |
16:43 | 56 | |
16:44 | 81 | |
16:45 | 30 | 50.1333333333333 |
16:46 | 99 | |
16:47 | 4 | |
16:48 | 100 | |
16:49 | 5 | |
16:50 | 10 | |
16:51 | 37 | |
16:52 | 12 | |
16:53 | 92 | |
16:54 | 99 | |
16:55 | 95 | |
16:56 | 69 | |
16:57 | 20 | |
16:58 | 52 | |
16:59 | 28 | |
17:00 | 45 | 44.3333333333333 |
17:01 | 27 | |
17:02 | 20 | |
17:03 | 35 | |
17:04 | 57 | |
17:05 | 88 | |
17:06 | 91 | |
17:07 | 7 | |
17:08 | 66 | |
17:09 | 41 | |
17:10 | 20 | |
17:11 | 32 | |
17:12 | 77 | |
17:13 | 8 | |
17:14 | 51 | |
17:15 | 38 | 53.6 |
17:16 | 36 | |
17:17 | 39 | |
17:18 | 40 | |
17:19 | 15 | |
17:20 | 91 | |
17:21 | 45 | |
17:22 | 37 | |
17:23 | 99 | |
17:24 | 98 | |
17:25 | 54 | |
17:26 | 64 | |
17:27 | 97 | |
17:28 | 48 | |
17:29 | 3 | |
17:30 | 55 | 50.6 |
17:31 | 33 | |
17:32 | 71 | |
17:33 | 40 | |
17:34 | 65 | |
17:35 | 80 | |
17:36 | 46 | |
17:37 | 57 | |
17:38 | 43 | |
17:39 | 3 | |
17:40 | 70 | |
17:41 | 30 | |
17:42 | 73 | |
17:43 | 63 | |
17:44 | 30 | |
17:45 | 79 | 67.4 |
17:46 | 67 | |
17:47 | 49 | |
17:48 | 75 | |
17:49 | 98 | |
17:50 | 78 | |
17:51 | 83 | |
17:52 | 83 | |
17:53 | 54 | |
17:54 | 77 | |
17:55 | 46 | |
17:56 | 52 | |
17:57 | 66 | |
17:58 | 64 | |
17:59 | 40 | |
18:00 | 95 | 58.8666666666667 |
18:01 | 100 | |
18:02 | 83 | |
18:03 | 61 | |
18:04 | 9 | |
18:05 | 11 | |
18:06 | 35 | |
18:07 | 40 | |
18:08 | 75 | |
18:09 | 80 | |
18:10 | 14 | |
18:11 | 82 | |
18:12 | 37 | |
18:13 | 72 | |
18:14 | 89 | |
18:15 | 48 | 45.6666666666667 |
18:16 | 40 | |
18:17 | 90 | |
18:18 | 27 | |
18:19 | 10 | |
18:20 | 65 | |
18:21 | 52 | |
18:22 | 4 | |
18:23 | 29 | |
18:24 | 23 | |
18:25 | 29 | |
18:26 | 90 | |
18:27 | 92 | |
18:28 | 1 | |
18:29 | 85 | |
18:30 | 62 | 63.2 |
18:31 | 46 | |
18:32 | 99 | |
18:33 | 50 | |
18:34 | 61 | |
18:35 | 74 | |
18:36 | 90 | |
18:37 | 45 | |
18:38 | 91 | |
18:39 | 100 | |
18:40 | 93 | |
18:41 | 67 | |
18:42 | 19 | |
18:43 | 16 | |
18:44 | 35 | |
18:45 | 86 | 58.9333333333333 |
18:46 | 64 | |
18:47 | 99 | |
18:48 | 26 | |
18:49 | 99 | |
18:50 | 19 | |
18:51 | 31 | |
18:52 | 93 | |
18:53 | 11 | |
18:54 | 74 | |
18:55 | 88 | |
18:56 | 36 | |
18:57 | 56 | |
18:58 | 68 | |
18:59 | 34 | |
19:00 | 18 | 69.3333333333333 |
19:01 | 97 | |
19:02 | 26 | |
19:03 | 84 | |
19:04 | 98 | |
19:05 | 53 | |
19:06 | 79 | |
19:07 | 95 | |
19:08 | 72 | |
19:09 | 92 | |
19:10 | 24 | |
19:11 | 95 | |
19:12 | 86 | |
19:13 | 96 | |
19:14 | 25 | |
19:15 | 50 | 58.8 |
19:16 | 88 | |
19:17 | 95 | |
19:18 | 20 | |
19:19 | 85 | |
19:20 | 41 | |
19:21 | 39 | |
19:22 | 45 | |
19:23 | 67 | |
19:24 | 39 | |
19:25 | 63 | |
19:26 | 98 | |
19:27 | 2 | |
19:28 | 61 | |
19:29 | 89 | |
19:30 | 90 | 57.8666666666667 |
19:31 | 74 | |
19:32 | 84 | |
19:33 | 98 | |
19:34 | 83 | |
19:35 | 25 | |
19:36 | 92 | |
19:37 | 72 | |
19:38 | 26 | |
19:39 | 34 | |
19:40 | 48 | |
19:41 | 2 | |
19:42 | 70 | |
19:43 | 7 | |
19:44 | 63 | |
19:45 | 38 | 53.7333333333333 |
19:46 | 12 | |
19:47 | 44 | |
19:48 | 23 | |
19:49 | 0 | |
19:50 | 80 | |
19:51 | 88 | |
19:52 | 88 | |
19:53 | 93 | |
19:54 | 34 | |
19:55 | 69 | |
19:56 | 15 | |
19:57 | 95 | |
19:58 | 85 | |
19:59 | 42 | |
20:00 | 37 | 35 |
20:01 | 100 | |
20:02 | 3 | |
20:03 | 17 | |
20:04 | 5 | |
20:05 | 44 | |
20:06 | 99 | |
20:07 | 29 | |
20:08 | 100 | |
20:09 | 2 | |
20:10 | 5 | |
20:11 | 11 | |
20:12 | 25 | |
20:13 | 24 | |
20:14 | 24 | |
20:15 | 63 | 40.7333333333333 |
20:16 | 81 | |
20:17 | 90 | |
20:18 | 44 | |
20:19 | 61 | |
20:20 | 18 | |
20:21 | 37 | |
20:22 | 6 | |
20:23 | 85 | |
20:24 | 1 | |
20:25 | 53 | |
20:26 | 3 | |
20:27 | 54 | |
20:28 | 5 | |
20:29 | 10 | |
20:30 | 9 | 54.4666666666667 |
20:31 | 68 | |
20:32 | 89 | |
20:33 | 69 | |
20:34 | 74 | |
20:35 | 50 | |
20:36 | 84 | |
20:37 | 15 | |
20:38 | 58 | |
20:39 | 80 | |
20:40 | 30 | |
20:41 | 69 | |
20:42 | 86 | |
20:43 | 11 | |
20:44 | 25 | |
20:45 | 0 | 45.4666666666667 |
20:46 | 49 | |
20:47 | 29 | |
20:48 | 65 | |
20:49 | 26 | |
20:50 | 62 | |
20:51 | 41 | |
20:52 | 65 | |
20:53 | 27 | |
20:54 | 78 | |
20:55 | 70 | |
20:56 | 17 | |
20:57 | 90 | |
20:58 | 5 | |
20:59 | 58 | |
21:00 | 24 | 49.4 |
21:01 | 95 | |
21:02 | 23 | |
21:03 | 16 | |
21:04 | 0 | |
21:05 | 25 | |
21:06 | 70 | |
21:07 | 70 | |
21:08 | 85 | |
21:09 | 81 | |
21:10 | 81 | |
21:11 | 90 | |
21:12 | 44 | |
21:13 | 9 | |
21:14 | 28 | |
21:15 | 67 | 53.1333333333333 |
21:16 | 89 | |
21:17 | 54 | |
21:18 | 11 | |
21:19 | 17 | |
21:20 | 63 | |
21:21 | 97 | |
21:22 | 88 | |
21:23 | 95 | |
21:24 | 63 | |
21:25 | 65 | |
21:26 | 56 | |
21:27 | 13 | |
21:28 | 3 | |
21:29 | 16 | |
21:30 | 14 | 55.8 |
21:31 | 83 | |
21:32 | 2 | |
21:33 | 73 | |
21:34 | 81 | |
21:35 | 70 | |
21:36 | 5 | |
21:37 | 84 | |
21:38 | 63 | |
21:39 | 88 | |
21:40 | 33 | |
21:41 | 49 | |
21:42 | 90 | |
21:43 | 75 | |
21:44 | 27 | |
21:45 | 43 | 53.7333333333333 |
21:46 | 67 | |
21:47 | 61 | |
21:48 | 17 | |
21:49 | 49 | |
21:50 | 32 | |
21:51 | 100 | |
21:52 | 93 | |
21:53 | 93 | |
21:54 | 53 | |
21:55 | 23 | |
21:56 | 16 | |
21:57 | 4 | |
21:58 | 76 | |
21:59 | 79 | |
22:00 | 47 | 39.6 |
22:01 | 46 | |
22:02 | 9 | |
22:03 | 92 | |
22:04 | 67 | |
22:05 | 2 | |
22:06 | 39 | |
22:07 | 38 | |
22:08 | 52 | |
22:09 | 1 | |
22:10 | 15 | |
22:11 | 17 | |
22:12 | 78 | |
22:13 | 14 | |
22:14 | 77 | |
22:15 | 70 | 43.8666666666667 |
22:16 | 58 | |
22:17 | 54 | |
22:18 | 71 | |
22:19 | 0 | |
22:20 | 68 | |
22:21 | 10 | |
22:22 | 79 | |
22:23 | 50 | |
22:24 | 57 | |
22:25 | 49 | |
22:26 | 0 | |
22:27 | 50 | |
22:28 | 5 | |
22:29 | 37 | |
22:30 | 50 | 46.8 |
22:31 | 27 | |
22:32 | 54 | |
22:33 | 39 | |
22:34 | 1 | |
22:35 | 88 | |
22:36 | 23 | |
22:37 | 81 | |
22:38 | 70 | |
22:39 | 54 | |
22:40 | 39 | |
22:41 | 52 | |
22:42 | 33 | |
22:43 | 2 | |
22:44 | 89 | |
22:45 | 5 | 58.9333333333333 |
22:46 | 78 | |
22:47 | 39 | |
22:48 | 82 | |
22:49 | 79 | |
22:50 | 73 | |
22:51 | 36 | |
22:52 | 75 | |
22:53 | 81 | |
22:54 | 71 | |
22:55 | 40 | |
22:56 | 33 | |
22:57 | 90 | |
22:58 | 38 | |
22:59 | 64 | |
23:00 | 14 | 51.2666666666667 |
23:01 | 27 | |
23:02 | 93 | |
23:03 | 80 | |
23:04 | 12 | |
23:05 | 98 | |
23:06 | 9 | |
23:07 | 67 | |
23:08 | 87 | |
23:09 | 10 | |
23:10 | 15 | |
23:11 | 69 | |
23:12 | 60 | |
23:13 | 60 | |
23:14 | 68 | |
23:15 | 21 | 59.4666666666667 |
23:16 | 86 | |
23:17 | 76 | |
23:18 | 21 | |
23:19 | 81 | |
23:20 | 31 | |
23:21 | 71 | |
23:22 | 68 | |
23:23 | 90 | |
23:24 | 63 | |
23:25 | 8 | |
23:26 | 85 | |
23:27 | 95 | |
23:28 | 29 | |
23:29 | 67 | |
23:30 | 45 | 46.2666666666667 |
23:31 | 71 | |
23:32 | 73 | |
23:33 | 58 | |
23:34 | 23 | |
23:35 | 16 | |
23:36 | 16 | |
23:37 | 79 | |
23:38 | 84 | |
23:39 | 100 | |
23:40 | 4 | |
23:41 | 23 | |
23:42 | 55 | |
23:43 | 25 | |
23:44 | 22 | |
23:45 | 8 | 45.4 |
23:46 | 27 | |
23:47 | 49 | |
23:48 | 22 | |
23:49 | 84 | |
23:50 | 46 | |
23:51 | 24 | |
23:52 | 19 | |
23:53 | 53 | |
23:54 | 32 | |
23:55 | 72 | |
23:56 | 69 | |
23:57 | 96 | |
23:58 | 20 | |
23:59 | 60 |
Average of all the 1 minute data points: 49.76319444
Average of all the 15 minute averages: 49.76319444
They're exactly the same! The reason for this comes from the associative property of addition. Think about the formula for an average:
x̄ = (a1+a2+a3+...+an)/n
If you had multiple sets (i.e. 15 minute averages):
x̄ = {(a1+a2+a3+...+an)/na + (b1+b2+b3+...+bn)/nb + (c1+c2+c3+...+cn)/nc}/3
Since in this case na=nb=nc, then substitue n and factor out:
x̄ = {(a1+a2+a3+...+an) + (b1+b2+b3+...+bn) + (c1+c2+c3+...+cn)}/3n
Associative property of addition:
x̄ = (a1+a2+a3+...+an+b1+b2+b3+...+bn+c1+c2+c3+...+cn)/3n
Since in this case 3n = n + n + n and na=nb=nc=n, then substitue for n:
x̄ = (a1+a2+a3+...+an+b1+b2+b3+...+bn+c1+c2+c3+...+cn)/(n + n + n)
x̄ = (a1+a2+a3+...+an+b1+b2+b3+...+bn+c1+c2+c3+...+cn)/(na + nb + nc)
Knowing that na + nb + nc is actually the total number of original points gets us back to the original equation for calculating the average of the 1 minute data. So the average of all the data points is the same as the average of evenly spaced averages of all the data points. If you're wondering if this works, go ahead and mock it up in Excel. I did.
No comments:
Post a Comment