1
COMPARATIVE PASSENGER FLOW
IN US AIRPORTS by Larry Beck
November 25, 2014
For Dr. Bruce Gockerman
Robert Morris University – Fall 2014
Prd 590 – Downtown Chicago – Tuesdays
LBeck490@robertmorris.edu
(312) 656-8303 cell
Larry Beck
Passenger Flows
2
Larry Beck
Contents
Executive Summary......................................................................................................................... 4
Introduction .................................................................................................................................... 5
Objective ......................................................................................................................................... 8
Brief Literature Review …show more content…
The SFs are the average value for each month’s ratio of (actual values / moving average). The MA is a 12-month centered average of the actual values, as follows:
MAt = [ Average(Data t-5 to t+6) + Average(Data t-4 to t+7) ] / 2
The SFs are then calculated as follows: SFt = Actualt / MAt – which yields a decimal percent of deviation from the moving average. These values are then averaged by month for a single number to represent the month.
Appendix 4 displays the result of these calculations for each airport by month. The actual data tables are available in the Excel file online 13.
SF HYPOTHESIS
Per the research objective, we now test for statistical significance (α=.05) on the difference between the USA total SF and each airport’s SF. The hypothesis is stated as:
Ho: SFusa = SFairport
A t-test between means was then conducted on all 15 airports over 12 months (180 comparisons). The significance level was calculated for each comparison. A visual
13
Excel data file, see tab {Seasonal Factors}: https://drive.google.com/file/d/0BxuZ9YCOBeH-UTdPcVpKalM4WDg/view?usp=sharing Passenger Flows