Hi,
I am trying to model the % of air passengers entering a queue over time. Time is based on time before standard time of departure (STD) and is in Column A in minutes i.e. 180-0 (3 hours before STD to 0 minutes before STD).
I would like to apply a smoothed curved distribution. A few passengers will start arriving at 180 minutes but the peak number of passengers will not be until around 90 minutes with arriving passengers droping back off to 0 at around 30 minutes STD.
I have been thinking along the lines of a normal/poisson/weibull/logistic-sigmoid etc. but any help with applying a distribution to the below example would be greatly appreciated.
Time Passengers
180 0%
175 0%
170 0%
165 0%
160 0%
155 0%
150 0%
145 0%
140 0%
135 0%
130 0%
125 0%
120 1%
115 0%
110 0%
105 0%
100 0%
95 0%
90 1%
85 2%
80 8%
75 14%
70 20%
65 25%
60 14%
55 4%
50 5%
45 3%
40 2%
35 1%
30 0%
25 0%
20 0%
15 0%
10 0%
5 0%
0 0%
Obviously my example is just me punching in %'s and I would like to apply a proven equation to the distribution.
Cheers,
Mike
I am trying to model the % of air passengers entering a queue over time. Time is based on time before standard time of departure (STD) and is in Column A in minutes i.e. 180-0 (3 hours before STD to 0 minutes before STD).
I would like to apply a smoothed curved distribution. A few passengers will start arriving at 180 minutes but the peak number of passengers will not be until around 90 minutes with arriving passengers droping back off to 0 at around 30 minutes STD.
I have been thinking along the lines of a normal/poisson/weibull/logistic-sigmoid etc. but any help with applying a distribution to the below example would be greatly appreciated.
Time Passengers
180 0%
175 0%
170 0%
165 0%
160 0%
155 0%
150 0%
145 0%
140 0%
135 0%
130 0%
125 0%
120 1%
115 0%
110 0%
105 0%
100 0%
95 0%
90 1%
85 2%
80 8%
75 14%
70 20%
65 25%
60 14%
55 4%
50 5%
45 3%
40 2%
35 1%
30 0%
25 0%
20 0%
15 0%
10 0%
5 0%
0 0%
Obviously my example is just me punching in %'s and I would like to apply a proven equation to the distribution.
Cheers,
Mike