E
ErwinAlonzo
Hello everyone,
Let me set up the problem really quick:
I have data for train passengers in half hour blocks as shown:
11:00 AM - 11:30 AM = 100
11:30 AM - 12:00 PM = 400
12:00 PM - 12:30 PM = 1200
12:30 PM - 1:00 PM = 3200
1:00 PM - 1:30 PM = 2000
1:30 PM - 2:00 PM = 1600
2:00 PM - 2:30 PM = 700
2:30 PM - 3:00 PM = 400
3:00 PM - 3:30 PM = 200
3:30 PM - 4:00 PM = 100
For example, there are 2,000 people taking the train between 1:00 PM
and 1:30 PM.
What I really need is one-minute intervals of data points. Therefore,
I somehow need to obtain a smooth curve while holding the above data
to be true (total passengers for each half-hour block is still the
same as the given data).
Does anyone know what function or method I can use to obtain such a
curve from this data? Perhaps some averaging technique? In the end, I
need values for each minute for the entire period. If anyone can
provide me any help or hints on going about doing this, I would very
much appreciate it. Thanks all.
Let me set up the problem really quick:
I have data for train passengers in half hour blocks as shown:
11:00 AM - 11:30 AM = 100
11:30 AM - 12:00 PM = 400
12:00 PM - 12:30 PM = 1200
12:30 PM - 1:00 PM = 3200
1:00 PM - 1:30 PM = 2000
1:30 PM - 2:00 PM = 1600
2:00 PM - 2:30 PM = 700
2:30 PM - 3:00 PM = 400
3:00 PM - 3:30 PM = 200
3:30 PM - 4:00 PM = 100
For example, there are 2,000 people taking the train between 1:00 PM
and 1:30 PM.
What I really need is one-minute intervals of data points. Therefore,
I somehow need to obtain a smooth curve while holding the above data
to be true (total passengers for each half-hour block is still the
same as the given data).
Does anyone know what function or method I can use to obtain such a
curve from this data? Perhaps some averaging technique? In the end, I
need values for each minute for the entire period. If anyone can
provide me any help or hints on going about doing this, I would very
much appreciate it. Thanks all.