1

Assume that I have data collected every minute.
If I want to display that data on a line chart with data averaged to every hour.

Is it assumed that a label on the horizontal axis is the measurement from the beginning of that hour to the start of the next hour?
Or should the data point be the average of that hour +/- 30 minutes?

enter image description here

2

The following is correct:

a label on the horizontal axis is the measurement from the beginning of that hour to the start of the next hour

Take your first two labels for example. The data point for 14:00 should encompass activity that took place during the 14th hour, i.e. the time from 14:00 to 14:59.

It's easier to wrap your mind around it if you think of a history timeline: timeline

The event that happened within the year of 1964 had to have happened from Jan 1 - Dec 31, 1964.

Image source: https://sintoamerica.com/history/sai-history-timeline/

| improve this answer | |
  • 1
    Excellent example, thanks so much! – Jordan Dec 16 '19 at 14:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.