Prediction of Skytrax airport rankings, short formula (2011) (2e)

[PEREZGONZALEZ Jose D (2011). Prediction of Skytrax airport rankings, short formula (2011) (2e)4. Journal of Knowledge Advancement & Integration (ISSN 1177-4576), 2012, pages 204-208.] [Printer friendly] [YouTube channel] [Screenr channel]

Prediction of airport rankings for 2011

Perezgonzalez continued a previous study by Perezgonzalez and Gilbey (20102), attempting to predict Skytrax's 2011 Official World Airport Star rankings from average ratings that passengers had given to those airports, independently, on Skytrax's website. The regression formula was based on a single variable, the average 'Customer review scoring', which is a cumulative average of past ratings, including those given during 2011.

The short regression formula for predicting Skytrax's 2011 ranking was:

Predicted Skytrax Ranking = 0.711 + (0.410 * Customer review scoring)
(F = 27.264, p = 0.00; R = 0.715; R2 = 0.512; Adj.R = 0.702; Adj.R2 = 0.493)

Table 1 shows the actual ranking given by Skytrax, the predicted 'ranking' obtained from above formula, the customer average rating used as predictor and the same customer average rating adjusted to a scale ranging between 1 and 5 in order to facilitate comparisons with the other scores. Overall, 72% of the airports could be ranked in approximately the same hierarchy than the one provided by Skytrax. Furthermore, it may be possible to also rank correctly 70% of the remaining airports not ranked by Skytrax (adj.R).

Table 1. Predicted and actual scores
Airport Customer Customer (adj) Predicted Skytrax
Seoul Incheon 9.20 4.68 4.48 5.00
Hong Kong 8.70 4.48 4.28 5.00
Munich 8.30 4.32 4.11 4.00
Singapore Changi 8.20 4.28 4.07 5.00
Zurich 8.10 4.24 4.03 4.00
London Heathrow 7.70 4.08 3.87 3.00
Helsinki 7.60 4.04 3.83 4.00
Doha 7.60 4.04 3.83 3.00
Beijing 7.50 4.00 3.79 4.00
Copenhagen 7.40 3.96 3.75 4.00
Dusseldorf 7.30 3.92 3.70 4.00
Amsterdam 7.10 3.84 3.62 4.00
Bahrain 7.00 3.80 3.58 3.00
Johannesburg 7.00 3.80 3.58 3.00
Kuala Lumpur International 6.60 3.64 3.42 4.00
Guangzhou 6.60 3.64 3.42 3.00
Houston 6.60 3.64 3.42 3.00
Brussels Zaventem 6.50 3.60 3.38 3.00
Madrid Barajas 6.50 3.60 3.38 3.00
Atlanta 6.30 3.52 3.29 3.00
Bangkok Suvarnabhumi 6.30 3.52 3.29 3.00
Frankfurt Main 5.80 3.32 3.09 4.00
Amman 5.80 3.32 3.09 2.00
Abu Dhabi 5.60 3.24 3.01 3.00
Dubai 4.70 2.88 2.64 3.00
Kuwait 4.50 2.80 2.56 3.00
Paris CDG 3.70 2.48 2.23 3.00
Moscow Sheremetyevo 3.70 2.48 2.23 2.00
(The 'Customer (adj)' column shows customer scores on a 1-5 scale, thus facilitating comparisons with the other variables)

The regression formula obtained in this study is relatively similar to that obtained in 2010. In order to ascertain how fit these formulas may be to predict future Skytrax airport rankings, a simulation was carried out in order to predict the 2011 ranking using the 2010 formula. A good correlation between the results of the simulation and the 2011 prediction could then be taken as evidence in support of such fit. A low correlation could be taken as evidence against such fit.

Table 2 collates the predictions made for 2010 (using the 2010 formula, see Perezgonzalez, 2010 1), for 2011 (using the 2011 formula), and the results of the simulation predicting 2011 ranking using the 2010 formula. The correlation between the 2010 ranking and the simulation ranking was 98% (r=0.98), while there was a perfect positive correlation between the 2011 ranking and the simulation ranking (r=1.00).

Table 2. Predicted scores for 2010, 2011 using 2010 formula, and 2011
Airport 2010 prediction Simulation 2011 prediction
Seoul Incheon 4.52 4.52 4.48
Hong Kong 4.31 4.31 4.28
Munich --- 4.15 4.11
Singapore Changi 4.15 4.11 4.07
Zurich 4.06 4.06 4.03
London Heathrow 3.90 3.90 3.87
Helsinki --- 3.86 3.83
Doha 3.81 3.86 3.83
Beijing 3.90 3.81 3.79
Copenhagen --- 3.77 3.75
Dusseldorf --- 3.73 3.70
Amsterdam 3.65 3.65 3.62
Johannesburg 3.69 3.61 3.58
Bahrain 3.61 3.61 3.58
Guangzhou --- 3.44 3.42
Houston --- 3.44 3.42
Kuala Lumpur International 3.52 3.44 3.42
Brussels Zaventem --- 3.40 3.38
Madrid Barajas 3.48 3.40 3.38
Atlanta --- 3.31 3.29
Bangkok Suvarnabhumi 3.73 3.31 3.29
Amman --- 3.10 3.09
Frankfurt Main 3.27 3.10 3.09
Abu Dhabi 3.06 3.02 3.01
Dubai 2.77 2.65 2.64
Kuwait 2.56 2.56 2.56
Moscow Sheremetyevo --- 2.23 2.23
Paris CDG --- 2.23 2.23
(The simulation column shows the predicted ranking for 2011 when using the 2010 formula)

Author

Jose D PEREZGONZALEZ (2012). Massey University, Turitea Campus, Private Bag 11-222, Palmerston North 4442, New Zealand. (JDPerezgonzalezJDPerezgonzalez).

Peer-reviewers

Nicholas ASHLEY (2012). School of Aviation, Massey University, New Zealand (NickAshleyNickAshley).

Want to know more?

Journal of Airport Management - Perezgonzalez et al's (2010) article
This article describes an alternative regression formula which predicts Skytrax's airport ranking using three 2010-based variables as predictors. The article is, PEREZGONZALEZ Jose D & Andrew GILBEY (2010). Predicting Skytrax’s airport rankings from customer reviews. Journal of Airport Management (ISSN 1750-1938), 2011, volume 5, number 4, pages 335-339.
Skytrax's website
Skytrax offers the latest rankings for airports and airlines, as well as independent reviews of those by passengers.
Wiki of Science - Skytrax's 2010 airport rankings
Perezgonzalez et al's (2010) article expanded with actual data and predicted scores per airport.

BlinkListblogmarksdel.icio.usdiggFarkfeedmelinksFurlLinkaGoGoNewsVineNetvouzRedditYahooMyWebFacebook

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License