Journal of Tourism & Hospitality

Journal of Tourism & Hospitality
Open Access

ISSN: 2167-0269

+44 1300 500008

Research Article - (2018) Volume 7, Issue 4

The Dynamics for Evaluating Forecasting Methods for International Air Passenger Demand in Nigeria

Adeniran AO* and Stephens MS
Department of Transport Management Technology, Federal University of Technology, Akure (FUTA), Ondo State, Nigeria
*Corresponding Author: Adeniran AO, Department of Transport Management Technology, Federal University of Technology, Akure (FUTA), Ondo State, Nigeria, Tel: 07036196773 Email:

Abstract

This paper examines the dynamics for evaluating different forecasting methods for international air passenger demand in Nigeria. It achieved the objectives by forecasting international air passenger demand in the year 2018 using two single moving average, four single moving average and six single moving average; the same forecast was also achieved by using simple exponential smoothing, with smoothing constants of 0.7, 0.8, and 0.9 respectively. The most appropriate forecasting method was determined by comparing all the single moving averages with exponential smoothing. This study is very essential to airport management, airline management, concessionaires of aeronautical and non-aeronautical services, third-parties, government agencies and ministries, economic regulators, transport policy analysts and planners, and other concerned agencies, for accurate planning which affect the overall operations of international air transport movement and help to prevent problems of having excess air transport demand over air transport supply or having excess air transport supply over demand particularly in the international level. The data involved for this study was between the periods of year 2001 to year 2017, meanwhile single moving average and simple exponential smoothing were the quantitative forecasting methods adopted for forecasting, the two forecasting methods were compared using Mean Squared Deviation (MSD). It was revealed that the MSD of exponential smoothing with constant 0.8 appears to give the best year 2018 forecast as it has a lower MSD when compared to the MSD of the other forecasts

Keywords: Forecasting; International air passenger demand; Single moving average; Simple exponential smoothing

Introduction

Background of the study

The importance of transportation cannot be far-fetched from or beyond the following; economic purpose, social integration and spatial interaction [1], without which poverty is inevitable. This connote the axiom of Wilfred Owen, a renowned transport analyst who states that “Immobility Perpetuate Poverty”. Transportation facilitates international movement and trade; hence transport business seems worthwhile for investors and business owners. International movement is mostly supported by air transportation.

Air transportation is a major industry in its own right and it provides important inputs into wider economic, political, and social processes. The demand for its services, as with most transport, is a derived one which is driven by the needs and desires to attain some other final objective. Air transport can facilitate, for example, in the economic development of a region or of a particular industry such as tourism [2].

Air transport business cannot maximize nor sustain high sales and profit unless there is a demand for its services. Meanwhile the estimation of expected future demands is a key element in planning air transport operations. Air transport service (product) is a derived demand that is rarely demanded for its own purpose. The derived nature of air transport is attributed to the unique characteristics of air transport which are: air transport demand is a product that cannot be stored or kept; the product is usually personalized (consumers feel differently about the product), which is referred to as heterogeneity of product; there is no replacement for bad product; it is difficult to test the product before usage; delivery of product cannot be guaranteed because of unpredictable factors; and the product can be produced only in batches and not in individual units [3,4].

Air transport demand is the quantity of air transport service that consumers (mostly air passengers) are willing to buy at an agreed price. Economists categorized demand as effective demand and ineffective demand. Effective demand in air transport is defined as the quantity of air transport service that consumer (mostly passengers) are willing and able to buy at a given price. While ineffective demand is the willingness to buy but it is not backed up by ability to pay. The type of demand that will be focused in this study is effective international air passenger demand in Nigeria and between the periods of year 2001 to year 2017.

It has been affirmed that all levels of management in the air transport business requires decision making. Decisions are made about what is likely to happen in air transport in the future as it is said that business actions taken today must be based on yesterday’s plan and tomorrow’s expectations which is referred to as expectations, predictions, projections, all referred to as forecasting. Forecasting is needed since every form of decision making and planning activity in international air transport business involves forecasting such as airline planning, airport planning, inventory control, investment cash flows, demand forecasts, corporate planning, budgeting, and others. Forecasting is not planning, it is an indispensable part of planning and a management tool for deciding now what the company must do to realize its objectives.

The purpose of forecasting can be attached to the duration of forecast. Short-term forecast normally span a period of one month to one year and cover such day-to-day operations, medium-term forecasts generally span a period of one to five years and involve such things as route-planning decisions, and long-term forecast spans a period of 5 to 10 years and might involve planning decisions for airport and airline infrastructures. Since international air travel demand is a major inputs for fleet planning, route development and preparation of the annual operating plan, analyzing and forecasting air travel demand help reduce the airlines’ and airports’ risk by objectively evaluating the demand side of the air transport business [5].

The outcome of this study is very essential to airport management, airline management, concessionaires of aeronautical and nonaeronautical services, third-parties, government agencies and ministries, economic regulators, transport policy analysts and planners, and other concerned agencies which are the users of international air forecasting result. Accurate planning affect the overall operations of international air transport movement and help to prevent problems of having excess air transport demand over air transport supply or having excess air transport supply over demand particularly at the international level. As over-forecasting increases the labour/technical cost, administrative cost, having excess air transport supply over air transport demand, and other associated costs, so also does underforecasting result in the problem of having excess air transport demand over air transport supply. Inadequate supply of air transport service result in increased stress for international air passengers who are the direct customer, and under-forecasting will lower employee morale, and challenge the competency of airport and airline managers.

It should be noted that choosing appropriate forecasting technique to employ in international air transport business is quite challenging and requires a comprehensive analysis of empirical results; this study therefore examines the most accurate forecasting methods using single moving average and simple exponential smoothing with different smoothing constants. It is believed that this study is capable of giving a plausible result in this regard.

Aim and objectives

The aim of this paper is to examine the dynamics for evaluating different forecasting methods for international air passenger demand in Nigeria.

The specific objectives of this study are:

• To forecast for international air passenger demand in the year 2018 using two, four and six yearly single moving average;

• To forecast for international air passenger demand in the year 2018 using simple exponential smoothing with smoothing constants of 0.7, 0.8 and 0.9 respectively; and

• To determine the most appropriate forecasting method by comparing yearly single moving averages with different exponential smoothing using different smoothing constants.

Scope of study

The study limited to international air passenger demand in Nigeria. The data is also limited to seventeen (17) years from the period of year 2001 to 2017. Two, four, and six yearly moving averages were selected. Also, the smoothing constants of 0.7, 0.8 and 0.9 were chosen because the closer it is to 1, the better the accuracy of forecast.

Literature Review

This aspect of the study reviews the various literatures conducted that seems similar to the topic under consideration. It is expected to reveal critical facts and findings which have already been identified by previous researchers and also identify different gaps. This is a guide which helps to reveal the unknown.

There has been many business and economic discussions about the applications of various forecasting models. Several time series forecasting techniques such as naϊve model, moving average, double moving average, simple exponential smoothing; and semi average method has been applied to forecasting. More studies have been carried out outside the field if aviation as shown below;

In a study conducted by Ryu et al. [6] evaluated the forecasting method for institutional food service facility. They identified the most appropriate forecasting method of forecasting meal count for an institutional food service facility. The forecasting method analyzed included: naϊve model 1, 2 and 3; moving average method, double moving method, exponential smoothing method, double exponential method, Holt’s method, Winter method, linear regression and multiple regression method. The accuracy of forecasting methods was measured using mean absolute deviation, mean squared error, mean percentage error, mean absolute percentage error method, root mean squared error and Theil’s U- statistic. The result of their study showed that multiple regressions was the most accurate forecasting method, but naϊve method 2 was selected as the most appropriate forecasting method because of its simplicity and high level of accuracy.

Cacatto et al. [7] introduced the forecasting practices that have been used by food industries in Brazil and detect how these companies have used forecasting methods, the main factors that influenced their choice. The data was analyzed by multivariate statistics techniques using the SPSS software. The result shows that the companies do not use sophisticated forecasting methods: the historical analysis model is the mostly used. The factors that influence the choice of the models are the type of product and the time spent during the forecasting, and the main difficulties is the availability of the appropriate software.

Pradeep and Rajesh on the evaluation of forecasting methods and their application for sales forecasting of sterilized flavored milk in Chhattisgarh. They applied weekly data spreading over October 2011 to October 2012, on the sales of sterilized flavored milk in liter. The forecasting method analyzed included: naϊve model, moving average, double moving average, simple exponential smoothing; and semi average method. The accuracy of the forecasting method was measured using mean Forecast Error (MFE), mean Absolute Deviation (MAD), mean Square Error (MSE), root mean square Error (RMSE). Their study was limited to the application for sales forecasting of sterilized flavored milk in Chhattisgarh and has nothing to do with air transport demand.

In the field of aviation, the study carried out by Poore [8] aimed at testing the hypothesis that forecasts of the future demand for air transportation offered by airplane manufacturers and aviation regulators are reasonable and representative of the trends implicit in actual experience. The tests compared forecasts provided by Boeing, McDonnell Douglas, Airbus Industry and the International Civil Aviation Organization, with actual results of a baseline model of the demand for Revenue Passenger Kilometers (RPKs). The model is a combination of two equations describing RPKs demanded by the high- and the low-income groups respectively. Variations in RPKs demanded by the high-income group are related to changes in income per capita. Variations in RPKs demanded by the low-income segment are related to changes in population size. The model conforms to the assumptions and conditions for appropriate use of regression analysis. His study does not include time series forecasting and it was not carried out in Nigeria.

Abed et al. [9] established time series model for the domestic and international air travel demand for Saudi Arabia. The authors use passenger numbers as a dependent variable and non-oil gross domestic product, consumer price index, imports of goods and services, population size, total expenditures and the total consumption expenditure as explanatory variables. In both studies, they use four different model specifications in order to see forecasting performance of each model. As a result, they found out that the model with population size and total expenditure is the best model to explain passenger demand for both domestic and international air transportation. Their study does not include time series forecasting technique and it was not carried out in Nigeria.

Adeniran and Ben [10] carried out a study on econometric model of domestic air travel in Nigeria vis-à-vis some selected economic variables. Their study revealed that the predictors (economic variables) cannot give true estimate of the domestic air travel forecast due to the fact that the model estimate was not validated. The invalidation was as a result of the following: no statistical significant between the variables; problem of multicollinearity presence, although the regression value signifies that the model can give a true forecast. Their study does not include time series forecasting technique and was limited to domestic air passenger demand in Nigeria.

In summary of the previous studies, it was discovered that majority of the studies carried out adopted the use of causative method of quantitative forecasting for air travel demand, the studies were not carried out in Nigeria and the one carried out in Nigeria was limited to domestic air passenger travel. Hence, the major gaps identified are: location gap; time gap; variable gap; and method of data analysis gap.

This study therefore adopts two, four and six yearly single moving average and simple exponential smoothing with smoothing constants of 0.7, 0.8 and 0.9 which are time series analysis to forecast international air passenger travel in Nigeria.

Theory of spatial interaction in international air transport demand

Among the modes of transport, the role of air transport mode is quite important. Air transport system is fully driven by the global economy; it is an important catalyst to the global economy. Air transport directly employs four million people worldwide and generates $400 billion in output, also the efficiency and quality improvements in air passenger services contributes to the growth in government sectors such as hotel, tourism, etc. This is enhanced through the free flow of people and information, together with improved air cargo operations, trade and improved efficiency of the overall economy. That is to say that aviation sector imposes significant positive externalities to other industries, contributing to economic and employment growth to the nation [11].

As international air movement has to do with connected origin and destination before the above benefits can be achieved; the essence of spatial interaction cannot be overemphasized. According to Transport Geographers, spatial interaction model relates to the estimate flows between locations because the flow enhances the evaluation of demand (existing or potential) for transport services [12,13]. Spatial interaction model is the assumption that movement or flows are functions of the attributes of the locations of origin, the attributes of the locations of destination, and the friction of distance between the concerned origins and destinations. The general formula of the model is Tij = f (ViWjSij). Where Tij is the interaction between location I (origin) and location j (destination), the units of measurement are varied and can involve people, tons of freight, traffic volume, etc. [14].

It also concerns a time period such as interactions by the hour, day, month, or year. Vi is the attributes of the location of origin I, variables often used to express these attributes are socio-economic in nature, such as population, number of jobs available, industrial output or gross domestic product. Wj is the attributes of the location of destination j, it uses similar socio-economic variables to the previous attribute. Sij is the attributes of separation between the location of origin i and the location of destination j, this is also known as transport friction, variables often used to express these attributes are distance, transport costs, or travel time.

Economic activities are generating (supply) and attracting (demand) flows. The simple fact that a movement occurs between an origin and a destination underlines that the costs incurred by a spatial interaction are lower than the benefits derived from such an interaction. As such, an air passenger desiring to travel through the air mode because this interaction is linked to an income, while international trade concepts, such as comparative advantages, underline the benefits of specialization and the ensuing generation of trade flows between distant locations [15].

Regional complementarity: There must be a supply and a demand between the interacting locations. A residential zone is complementary to an industrial zone because the first is supplying workers while the second is supplying jobs. The same can be said concerning complementarity between a store and its customers and between an industry and its suppliers (movements of freight). If location B produces/generates something that location A requires, then an interaction is possible because a supply/ demand relationship has been established between those two locations; they have become complementary to one another. The same applies in the other direction (A to B), which creates a situation of reciprocity common in commuting or international trade [16].

Intervening opportunity: There must not be another location that may offer a better alternative as a point of origin or as a point of destination. For instance, in order to have an interaction of a customer to a store, there must not be a closer store that offers a similar array of goods. If location C offers the same characteristics (namely complementarity) as location A and is also closer to location B, an interaction between B and A will not occur and will be replaced by an interaction between B and C (Ibid) [17].

Spatial transferability: Freight, persons or information being transferred must be supported by transport infrastructures, implies that the origin and the destination must be linked. Costs to overcome distance must not be higher than the benefits of related interaction, even if there is complementarity and no alternative opportunity. Air transport infrastructures (modes and terminals) must be present to support an interaction between B and A. Also, these infrastructures must have a capacity and availability which are compatible with the requirements of such an interaction (Ibid) [18].

In the same vein, the goal of spatial interactions is to explain spatial flows. They provide ways to measure flows and predict the consequences of changes in the conditions generating them. When such attributes are known, it is possible to better allocate air transport resources such as airport terminal building, adequate airport equipment, and other infrastructures/equipment that will facilitate better quality of air services and good passenger/airline/concessionaire experience [19].

Forecasting

Forecasting can be defined as attempt to predict the future by using qualitative or quantitative means. It is an integral part of all human activity, but from the business point of view increasing attention is being given to formal forecasting systems which are continually being refined [12]. Every form of decision making and planning activities in business involve forecasting as it is being applied in air transportation [20].

There are two techniques involved in forecasting, they are;

• Qualitative techniques which involve the use of causal method such as correlation and regression analysis, and time series analysis such as simple exponential smoothing and single moving average.

• Quantitative techniques which is solely judgmental method such as expert opinion, poll, and sales force opinion.

This paper laid emphasis on quantitative techniques. Quantitative techniques have varying levels of statistical complexity which are based on analyzing past data of the item to be forecast. A very good example that will be captured in this study is international air passenger traffic (movement). However sophisticated the technique used, there is the underlying assumption that the past patterns will provide some guidance to the future. According to Terry [12], the main assumption behind the use of quantitative technique of forecasting is that the longer a period covered by the data, the more likely that the data will be representative of the future. Nevertheless, however long a period is covered by past data, any extrapolations or forecasts produced from that data by whatever technique should be treated with caution. In other to forecast quantitatively, the use of time series cannot be overemphasized.

Time series analysis

Time-series or trend analysis is a sophisticated statistical method of forecasting analysis. It is the oldest, and in many cases still the most widely used method of forecasting air transportation demand. It is simply a sequence of values expressed at regular recurring periods of time, and it is possible from these time-series studies to detect regular movements that are likely to recur and thus can be used as a means of predicting future events. Forecasting by time-series or trend extension actually consists of interpreting the historical sequence and applying the interpretation to the immediate future. It assumes that the past rate of growth or change will continue [4].

Methodology

There are uncertainties in demand of product and services, which can be reduced through forecasting methods. The forecasting models used in the analysis are single moving average method and simple exponential smoothing method. The most appropriate forecasting method was determined on the basis of accuracy using Mean Squared Deviation (MSD).

Study area

Nigeria is located in the West Africa sub-region within the longitude 30E and 150E and latitude 40N and 140N of the equator. It is bounded in the north by Niger Republic, south by Atlantic Ocean, east by Cameroon and Chad and west by Benin Republic. She is the most populous country in Africa. With respect to NPC, 2006, Nigeria accounted for more than 140 million and by August, 2011 it was estimated to be about 167 million [13].

It was also indicated in their study that Nigeria has about eight (8) major International and the most functional among them are Murtala Muhammed Airport, Lagos, Nnamdi Azikwe International Airport, Abuja and Mallam Aminu Kano International Airport, Kano. MMIA Lagos is the busiest international Airports in Nigeria that always account for more than 80% of the international airport service operation in Nigeria follow by MAKIA in Kano (Figure 1).

tourism-hospitality-location

Figure 1: Map and spatial location of international Airports in Nigeria.

Research design

This study examines the dynamics of different forecasting model using international air passengers demand data from Nigeria. Yearly data from 2001 to 2017 were collected and used to forecast the air passenger demand. The forecast model used in the analysis included single moving average method (n =2, 4 and 6) and simple exponential method (α = 0.7, 0.8 and 0.9). The most appropriate forecasting method was determined on the basis of accuracy using mean squared deviation.

Materials and method of data collection

Data for this analysis are secondary data sourced from Federal Airport Authority of Nigeria (FAAN), Nigerian Civil Aviation Authority (NCAA), Nigerian Bureau of Statistics, and journals covering the periods of seventeen years spanning from the year 2001 to year 2017.

Model specification

Forecasting method using single moving average: The single moving average method of forecasting is suitable for relatively stable time series with no trend or seasonal pattern. It involves calculating the average of observations and then employing that average as the predictor for the next period. The single moving average method is highly dependent on n which is the number of terms selected for constructing the average.

Single n period Moving Average

image

image.................... (Equation 1)

Where:

Ft is the forecast value for the next period,

Yt is the actual value at period t, and

n is the number of term in the single moving average based on the discretion of the researcher.

For single moving average, the 2, 4 and 6 yearly moving average was calculated and the forecast for the demand in year 2018 was obtained.

Forecasting method using simple exponential smoothing: The simple exponential smoothing method is a widely used and successful model which requires very little data. It is technique that uses weighted single moving average of past data as the basis for a forecast. This method keeps a running average of demand and adjusts it for each period in proportion to the difference between the latest actual demand figure and the latest value of the average. The derivation of equation for the simple exponential smoothing method is:

Ft = α Yt-1 + α (1 – α) Yt-2 + α (1 – α)2 Yt-3 +... ............. (Equation 2a)

Ft = α Yt-1 + α (1 – α) [α Yt-2 + α (1 – α) Yt-3 + ...]........ (Equation 2b)

Ft = α Yt-1 + (1 – α) Ft-1 ................... (Equation 2c)

Where:

Ft-1 is the last period forecast,

Ft is the forecast for period t.

Yt-1 is the last period actual value,

α is the smoothing constant (0 < α < 1),

The accuracy of simple exponential smoothing is dependent on the optimal value of α which is the smoothing constant. For the exponential smoothing, smoothing constants of 0.7, 0.8 and 0.9 was chosen and the forecast for the demand in year 2018 was calculated.

Mean squared deviation: When comparing the various forecasts, the Mean Squared Deviation (MSD) of the two forecasts was calculated and compared, and then the MSD that has a lower value was selected as preferred. The equation is:

image

image..................................... (Equation 3)

Where:

Yt is the actual value in time period t

Ft is the forecast value in time period t

n is the number of periods

Results and Discussions

The results of this study will be in-line with the established objectives. The Table 1 below shows the demand for Nigeria international air passengers in the past seventeen years.

Years International Air Passenger Demand
Yr 2001 1,506,878
Yr 2002 1,798,063
Yr 2003 1,719,533
Yr 2004 1,843,154
Yr 2005 1,700,252
Yr 2006 1,514,656
Yr 2007 2,323949
Yr 2008 2,557,264
Yr 2009 2,619,918
Yr 2010 3,217,876
Yr 2011 3,586,742
Yr 2012 4,440,930
Yr 2013 4,600,698
Yr 2014 4,654,941
Yr 2015 4,233,844
Yr 2016 4,260,989
Yr 2017 3,575,542

Sources: Nigerian Civil Aviation Authority (2011); Federal Airport Authority of Nigeria (2017); Nigeria Bureau of Statistics (2018); Adeniran & Gbadamosi (2017).

Table 1: Demand for Nigeria international air passengers in the past seventeen years.

Forecasting for international air passenger demand in the year 2018 using single moving average

Equation 1 in the model specification has to do with forecasting method using single moving average. In order to derive the forecasts, the variables in the equation will be substituted with values.

Two (2) yearly moving average: The result of two yearly moving average was shown in Table 2 below.

Years International Air Passenger Demand Two Yearly Moving Average
Yr 2001 1,506,878  
Yr 2002 1,798,063  
Yr 2003 1,719,533 1,652,471
Yr 2004 1,843,154 1,758,798
Yr 2005 1,700,252 1,781,344
Yr 2006 1,514,656 1,771,703
Yr 2007 2,323949 1,607,454
Yr 2008 2,557,264 1,919,303
Yr 2009 2,619,918 2,440,607
Yr 2010 3,217,876 2,588,591
Yr 2011 3,586,742 2,918,897
Yr 2012 4,440,930 3,402,309
Yr 2013 4,600,698 4,013,836
Yr 2014 4,654,941 4,520,814
Yr 2015 4,233,844 4,627,820
Yr 2016 4,260,989 4,444,393
Yr 2017 3,575,542 4,247,417
Forecast 2018   3,918,266

Authors’ Computation (2018)

Table 2: Two yearly moving average forecast of international air passenger demand.

image

The forecast of demand in the year 2018 is the two yearly single moving average for the years before, hence 3,918,266. In the forecast, there were approximations because forecast cannot produce a fractional demand.

Four (4) yearly moving average: The result of four yearly moving average was shown in Table 3 below.

Years International Air Passenger Demand Four Yearly Moving Average
Yr 2001 1,506,878  
Yr 2002 1,798,063  
Yr 2003 1,719,533  
Yr 2004 1,843,154  
Yr 2005 1,700,252 1,716,907
Yr 2006 1,514,656 1,765,251
Yr 2007 2,323949 1,694,399
Yr 2008 2,557,264 1,845,503
Yr 2009 2,619,918 2,024,030
Yr 2010 3,217,876 2,253,947
Yr 2011 3,586,742 2,679,752
Yr 2012 4,440,930 2,995,450
Yr 2013 4,600,698 3,466,367
Yr 2014 4,654,941 3,961,562
Yr 2015 4,233,844 4,320,828
Yr 2016 4,260,989 4,482,603
Yr 2017 3,575,542 4,437,618
Forecast 2018   4,181,329

Authors’ Computation (2018)

Table 3: Four yearly moving average forecast of international air passenger demand.

Forecast for year 2018= image

The forecast of demand in the year 2018 is the four yearly single moving average for the years before, hence 4,181,329. In the forecast, there were approximations because forecast cannot produce a fractional demand.

Six (6) yearly moving average: The result of six yearly moving average was shown in Table 4 below.

Years International Air Passenger Demand Six Yearly Moving Average
Yr 2001 1,506,878  
Yr 2002 1,798,063  
Yr 2003 1,719,533  
Yr 2004 1,843,154  
Yr 2005 1,700,252  
Yr 2006 1,514,656  
Yr 2007 2,323949 1,680,423
Yr 2008 2,557,264 1,816,601
Yr 2009 2,619,918 1,943,135
Yr 2010 3,217,876 2,093,199
Yr 2011 3,586,742 2,322,319
Yr 2012 4,440,930 2,636,734
Yr 2013 4,600,698 3,124,447
Yr 2014 4,654,941 3,503,905
Yr 2015 4,233,844 3,853,518
Yr 2016 4,260,989 4,122,505
Yr 2017 3,575,542 4,296,357
Forecast 2018   4,294,491

Authors’ Computation (2018)

Table 4: Six yearly moving average forecast of international air passenger demand.

Forecast for year 2018 = image

The forecast of demand in the year 2018 is the six yearly single moving average for the years before, hence 4,294,491. In the forecast, there were approximations because forecast cannot produce a fractional demand.

Forecasting for International Air Passenger Demand in the Year 2018 Using Simple Exponential Smoothing

The model specification in equation 2c has to do with forecasting method using simple exponential smoothing. In order to derive the forecasts, the variables in the equation will be substituted with values.

Simple Exponential Smoothing with Smoothing Constant of 0.7: Forecast for year 2002 is the demand for year 2001 = 1,506,878 (Table 5).

Years International Air Passenger Demand Exponential Smoothing 0.7
Yr 2001 1,506,878  
Yr 2002 1,798,063 1,506,878
Yr 2003 1,719,533 1,710,708
Yr 2004 1,843,154 1,716,885
Yr 2005 1,700,252 1,805,273
Yr 2006 1,514,656 1,731,758
Yr 2007 2,323949 1,579,787
Yr 2008 2,557,264 2,100,700
Yr 2009 2,619,918 2,420,295
Yr 2010 3,217,876 2,560,031
Yr 2011 3,586,742 3,020,523
Yr 2012 4,440,930 3,416,876
Yr 2013 4,600,698 4,133,714
Yr 2014 4,654,941 4,460,603
Yr 2015 4,233,844 4,596,640
Yr 2016 4,260,989 4,342,683
Yr 2017 3,575,542 4,285,497
Forecast 2018   3,788,529

Authors’ Computation (2018)

Table 5: Exponential smoothing (0.7) forecast of international air passenger demand.

Forecast for year 2018 = 0.7 (3,575,542) + 0.3 (4,285,497) = 3,788,529

The forecast of demand in the year 2018 is the average of the year 2017, hence 3,788,529. In the forecast, there were approximations because forecast cannot produce a fractional demand.

Simple Exponential Smoothing with Smoothing Constant of 0.8: Forecast for year 2002 is the demand for year 2001 = 1,506,878 (Table 6).

Years International Air Passenger Demand Exponential Smoothing 0.8
Yr 2001 1,506,878  
Yr 2002 1,798,063 1,506,878
Yr 2003 1,719,533 1,739,826
Yr 2004 1,843,154 1,723,592
Yr 2005 1,700,252 1,819,242
Yr 2006 1,514,656 1,724,050
Yr 2007 2,323949 1,556,535
Yr 2008 2,557,264 2,170,466
Yr 2009 2,619,918 2,479,904
Yr 2010 3,217,876 2,591,915
Yr 2011 3,586,742 3,092,684
Yr 2012 4,440,930 3,487,930
Yr 2013 4,600,698 4,250,330
Yr 2014 4,654,941 4,530,624
Yr 2015 4,233,844 4,630,078
Yr 2016 4,260,989 4,313,091
Yr 2017 3,575,542 4,271,409
Forecast 2018   3,714,715

Authors’ Computation (2018)

Table 6: Exponential smoothing (0.8) forecast of international air passenger demand.

Forecast for year 2018 = 0.8 (3,575,542) + 0.2 (4,271,409) = 3,714,715

The forecast of demand in the year 2018 is the average of the year 2017, hence 3,714,715. In the forecast, there were approximations because forecast cannot produce a fractional demand.

Simple exponential smoothing with smoothing constant of 0.9: Forecast for year 2002 is the demand for year 2001 = 1,506,878 (Table 7).

Years International Air Passenger Demand Exponential Smoothing 0.9
Yr 2001 1,506,878  
Yr 2002 1,798,063 1,506,878
Yr 2003 1,719,533 1,768,945
Yr 2004 1,843,154 1,724,474
Yr 2005 1,700,252 1,831,286
Yr 2006 1,514,656 1,713,355
Yr 2007 2,323949 1,534,526
Yr 2008 2,557,264 2,245,007
Yr 2009 2,619,918 2,526,038
Yr 2010 3,217,876 2,610,530
Yr 2011 3,586,742 3,157,141
Yr 2012 4,440,930 3,543,782
Yr 2013 4,600,698 4,351,215
Yr 2014 4,654,941 4,575,750
Yr 2015 4,233,844 4,647,022
Yr 2016 4,260,989 4,275,162
Yr 2017 3,575,542 4,262,406
Forecast 2018   3,644,228

Authors’ Computation (2018)

Table 7: Exponential smoothing (0.9) forecast of international air passenger demand.

Forecast for year 2002 is the demand for year 2001 = 1,506,878

Forecast for year 2018 = 0.9 (3,575,542) + 0.1 (4,262,406) = 3,644,228

The forecast of demand in the year 2018 is the average of the year 2017, hence 3,644,228. In the forecast, there were approximations because forecast cannot produce a fractional demand.

Determining the most appropriate forecasting method

This is done by comparing the yearly single moving averages with exponential smoothing of different smoothing constants. Before comparison using mean squared deviation, Figure 1 below is the line graph depicting the demand for international air passenger in Nigeria, the yearly single moving averages, and the simple exponential smoothing with different smoothing constants (Table 8).

Years International Air Passenger Demand Two Yearly Moving Average Four Yearly Moving Average Six Yearly Moving Average Exponential Smoothing 0.7 Exponential Smoothing 0.8 Exponential Smoothing 0.9
Yr 2001 1,506,878            
Yr 2002 1,798,063       1,506,878 1,506,878 1,506,878
Yr 2003 1,719,533 1,652,471     1,710,708 1,739,826 1,768,945
Yr 2004 1,843,154 1,758,798     1,716,885 1,723,592 1,724,474
Yr 2005 1,700,252 1,781,344 1,716,907   1,805,273 1,819,242 1,831,286
Yr 2006 1,514,656 1,771,703 1,765,251   1,731,758 1,724,050 1,713,355
Yr 2007 2,323949 1,607,454 1,694,399 1,680,423 1,579,787 1,556,535 1,534,526
Yr 2008 2,557,264 1,919,303 1,845,503 1,816,601 2,100,700 2,170,466 2,245,007
Yr 2009 2,619,918 2,440,607 2,024,030 1,943,135 2,420,295 2,479,904 2,526,038
Yr 2010 3,217,876 2,588,591 2,253,947 2,093,199 2,560,031 2,591,915 2,610,530
Yr 2011 3,586,742 2,918,897 2,679,752 2,322,319 3,020,523 3,092,684 3,157,141
Yr 2012 4,440,930 3,402,309 2,995,450 2,636,734 3,416,876 3,487,930 3,543,782
Yr 2013 4,600,698 4,013,836 3,466,367 3,124,447 4,133,714 4,250,330 4,351,215
Yr 2014 4,654,941 4,520,814 3,961,562 3,503,905 4,460,603 4,530,624 4,575,750
Yr 2015 4,233,844 4,627,820 4,320,828 3,853,518 4,596,640 4,630,078 4,647,022
Yr 2016 4,260,989 4,444,393 4,482,603 4,122,505 4,342,683 4,313,091 4,275,162
Yr 2017 3,575,542 4,247,417 4,437,618 4,296,357 4,285,497 4,271,409 4,262,406
Forecast 2018   3,918,266 4,181,329 4,294,491 3,788,529 3,714,715 3,644,228

Source: Authors’ Computation (2018)

Table 8: Compressed results of Moving Average and Exponential Smoothing.

From Figure 2 above, it can be seen that most of the forecasts produced seems similar and difficult to identify the accurate forecast. Hence, to avoid this confusion, mean squared deviation was adopted for proper verification as to choose the most reliable forecasting method in this study.

tourism-hospitality-demand

Figure 2: Line graph depicting the comparison of international air passenger demand in Nigeria and results of different forecasts.

Equation 3 in the model specification has to do with mean squared deviation for comparison of the forecasting methods. In order to derive the forecasts, the variables in the equations will be substituted with values.

• The Table 9 below shows the MSD for two yearly single moving average.

Years International Air Passenger Demand (D) Two Yearly Moving Average (E) Deviation = D - E Squared Deviation = (D – E)2
Yr 2003 1,719,533 1,652,471 67,062 4497311844
Yr 2004 1,843,154 1,758,798 84,356 7115934736
Yr 2005 1,700,252 1,781,344 -81,092 6575912464
Yr 2006 1,514,656 1,771,703 -257,047 66073160209
Yr 2007 2,323949 1,607,454 716,495 5.13365E+11
Yr 2008 2,557,264 1,919,303 637,961 4.06994E+11
Yr 2009 2,619,918 2,440,607 179,311 32152434721
Yr 2010 3,217,876 2,588,591 629,285 3.96E+11
Yr 2011 3,586,742 2,918,897 667,845 4.46017E+11
Yr 2012 4,440,930 3,402,309 1,038,621 1.07873E+12
Yr 2013 4,600,698 4,013,836 586,862 3.44407E+11
Yr 2014 4,654,941 4,520,814 134,127 17990052129
Yr 2015 4,233,844 4,627,820 -393,976 1.55217E+11
Yr 2016 4,260,989 4,444,393 -183,404 33637027216
Yr 2017 3,575,542 4,247,417 -671,875 4.51416E+11
Summation       3,960,191,404,001

Table 9: Mean Squared Deviation of two yearly moving average.

MSD for two yearly single moving averageimage

• The Table 10 below shows the MSD for four yearly single moving average.

Years International Air Passenger Demand (D) Four Yearly Moving Average (E) Deviation = D - E Squared Deviation = (D – E)2
Yr 2005 1,700,252 1,716,907 -16,655 277389025
Yr 2006 1,514,656 1,765,251 -250,595 62797854025
Yr 2007 2,323,949 1,694,399 629,550 3.96333E+11
Yr 2008 2,557,264 1,845,503 711,761 5.06604E+11
Yr 2009 2,619,918 2,024,030 595,888 3.55083E+11
Yr 2010 3,217,876 2,253,947 963,929 9.29159E+11
Yr 2011 3,586,742 2,679,752 906,990 8.22631E+11
Yr 2012 4,440,930 2,995,450 1,445,480 2.08941E+12
Yr 2013 4,600,698 3,466,367 1,134,331 1.28671E+12
Yr 2014 4,654,941 3,961,562 693,379 4.80774E+11
Yr 2015 4,233,844 4,320,828 -86,984 7566216256
Yr 2016 4,260,989 4,482,603 -221,614 49112764996
Yr 2017 3,575,542 4,437,618 -862,076 7.43175E+11
 Summation       7.72963E+12

Table 10: Mean Squared Deviation of four yearly moving average.

MSD for four yearly single moving averageimage

• The Table 11 below shows the MSD for six yearly single moving average.

Years International Air Passenger Demand (D) Six Yearly Moving Average (E) Deviation = D - E Squared Deviation = (D – E)2
Yr 2007 2,323,949 1,680,423 643,526 4.14126E+11
Yr 2008 2,557,264 1,816,601 740,663 5.48582E+11
Yr 2009 2,619,918 1,943,135 676,783 4.58035E+11
Yr 2010 3,217,876 2,093,199 1,124,677 1.2649E+12
Yr 2011 3,586,742 2,322,319 1,264,423 1.59877E+12
Yr 2012 4,440,930 2,636,734 1,804,196 3.25512E+12
Yr 2013 4,600,698 3,124,447 1,476,251 2.17932E+12
Yr 2014 4,654,941 3,503,905 1,151,036 1.32488E+12
Yr 2015 4,233,844 3,853,518 380,326 1.44648E+11
Yr 2016 4,260,989 4,122,505 138,484 19177818256
Yr 2017 3,575,542 4,296,357 -720,815 5.19574E+11
 Summation       1.17271E+13

Table 11: Mean Squared Deviation of six yearly moving average.

MSD for six yearly single moving averageimage

• The Table 12 below shows the MSD for simple exponential smoothing with smoothing constant of 0.7.

Years International Air Passenger Demand (D) Exponential Smoothing of 0.7 (E) Deviation = D - E Squared Deviation = (D – E)2
Yr 2002 1,798,063 1,506,878 291,185 84788704225
Yr 2003 1,719,533 1,710,708 8,825 77880625
Yr 2004 1,843,154 1,716,885 126,269 15943860361
Yr 2005 1,700,252 1,805,273 -105,021 11029410441
Yr 2006 1,514,656 1,731,758 -217,102 47133278404
Yr 2007 2,323,949 1,579,787 744,162 5.53777E+11
Yr 2008 2,557,264 2,100,700 456,564 2.08451E+11
Yr 2009 2,619,918 2,420,295 199,623 39849342129
Yr 2010 3,217,876 2,560,031 657,845 4.3276E+11
Yr 2011 3,586,742 3,020,523 566,219 3.20604E+11
Yr 2012 4,440,930 3,416,876 1,024,054 1.04869E+12
Yr 2013 4,600,698 4,133,714 466,984 2.18074E+11
Yr 2014 4,654,941 4,460,603 194,338 37767258244
Yr 2015 4,233,844 4,596,640 -362,796 1.31621E+11
Yr 2016 4,260,989 4,342,683 -81,694 6673909636
Yr 2017 3,575,542 4,285,497 -709,955 5.04036E+11
 Summation       3,661,273,103,204

Source: Authors’ computation (2018)

Table 12: Mean Squared Deviation of exponential smoothing of 0.7.

MSD for simple exponential smoothing with smoothing constant of 0.7

image

• The Table 13 below shows the MSD for simple exponential smoothing with smoothing constant of 0.8.

 

Years International Air Passenger Demand (D) Exponential Smoothing of 0.8 (E) Deviation = D - E Squared Deviation = (D – E)2
Yr 2002 1,798,063 1,506,878 291,185 84788704225
Yr 2003 1,719,533 1,739,826 -20,293 411805849
Yr 2004 1,843,154 1,723,592 119,562 14295071844
Yr 2005 1,700,252 1,819,242 -118,990 14158620100
Yr 2006 1,514,656 1,724,050 -209,394 43845847236
Yr 2007 2,323,949 1,556,535 767,414 5.88924E+11
Yr 2008 2,557,264 2,170,466 386,798 1.49613E+11
Yr 2009 2,619,918 2,479,904 140,014 19603920196
Yr 2010 3,217,876 2,591,915 625,961 3.91827E+11
Yr 2011 3,586,742 3,092,684 494,058 2.44093E+11
Yr 2012 4,440,930 3,487,930 953,000 9.08209E+11
Yr 2013 4,600,698 4,250,330 350,368 1.22758E+11
Yr 2014 4,654,941 4,530,624 124,317 15454716489
Yr 2015 4,233,844 4,630,078 -396,234 1.57001E+11
Yr 2016 4,260,989 4,313,091 -52,102 2714618404
Yr 2017 3,575,542 4,271,409 -695,867 4.84231E+11
Summation       3.24193E+12

Source: Authors’ computation (2018)

Table 13: Mean Squared Deviation of exponential smoothing of 0.8.

• MSD for simple exponential smoothing with smoothing constant of 0.8

image

• The Table 14 below shows the MSD for simple exponential smoothing with smoothing constant of 0.9.

Years International Air Passenger Demand (D) Exponential Smoothing of 0.9 (E) Deviation = D - E Squared Deviation = (D – E)2
Yr 2002 1,798,063 1,506,878 291,185 84788704225
Yr 2003 1,719,533 1,768,945 -49,412 2441545744
Yr 2004 1,843,154 1,724,474 118,680 14084942400
Yr 2005 1,700,252 1,831,286 -131,034 17169909156
Yr 2006 1,514,656 1,713,355 -198,699 39481292601
Yr 2007 2,323,949 1,534,526 789,423 6.23189E+11
Yr 2008 2,557,264 2,245,007 312,257 97504434049
Yr 2009 2,619,918 2,526,038 93,880 8813454400
Yr 2010 3,217,876 2,610,530 607,346 3.68869E+11
Yr 2011 3,586,742 3,157,141 429,601 1.84557E+11
Yr 2012 4,440,930 3,543,782 897,148 8.04875E+11
Yr 2013 4,600,698 4,351,215 249,483 62241767289
Yr 2014 4,654,941 4,575,750 79,191 6271214481
Yr 2015 4,233,844 4,647,022 -413,178 1.70716E+11
Yr 2016 4,260,989 4,275,162 -14,173 200873929
Yr 2017 3,575,542 4,262,406 -686,864 4.71782E+11
Summation       2.95699E+12

Source: Authors’ computation (2018)

Table 14: Mean Squared Deviation of exponential smoothing of 0.9.

• The Table 15 below shows the MSD for simple exponential smoothing with smoothing constant of 0.9.

MSD of two yearly moving average MSD of four yearly moving average MSD of six yearly moving average MSD of exponential smoothing constant 0.7 MSD of exponential smoothing constant 0.8 MSD of exponential smoothing constant 0.9
264,012,760,267 5.94587E+11 1.0661E+12 228,829,568,950 30,264,430,106 1.84812E+11

Source: Authors’ computation (2018)

Table 15: Comparison of MSDs for two, four, and six yearly single moving averages, simple exponential smoothing constants of 0.7, 0.8, and 0.9.

image

From the comparison of the different MSDs shown in Table 15 and Figure 3 respectively, it can be seen that the MSD of exponential smoothing with constant 0.8 appears to give the best year 2018 forecasts as it has a lower MSD than all other forecasting methods. Hence, the 2018 forecast of 3,714,715 that was produced by exponential smoothing with constant 0.8 was preferred (Figure 3).

tourism-hospitality-forecasting

Figure 3: Pictorial view comparing MSDs of forecasting methods.

Conclusion

In conclusion, this study examined the dynamics for evaluating different forecasting methods for international air passenger demand in Nigeria. Yearly data from 2001 to 2017 were collected and used to forecast the year 2018 international air passenger demand in Nigeria.

Lastly, the study revealed that simple exponential smoothing with constant 0.8 is closer to the original raw data; hence, it can be said that exponential smoothing with constant 0.8 will give a better forecast for the demand in year 2018 and subsequent years if adopted. The evaluation statement was best justified in the third objective where the mean square deviation was adopted to compare the different methods of forecast, so the year 2018 forecast of 3,714,715 was preferred.

References

  1. Adeniran AO (2016) Nigerian Economic Recession: Emphasis on Sound Transport Policy. Developing Country Studies 6: 48-54.
  2. Jourquin B, Rietveld P, Westin K (2006) Towards Better Performing Transportation Systems, Routledge, London.
  3. Adeniran AO, Adekunle EA, Oyedele OJ (2017) Establishing the Concept of Research Hypothesis through the Relationship between Demand in Nigeria International Air Passenger Traffic and Economic Variables. Inter J Economic Behavior and Organi 5: 105-113.
  4. Wenseveen JG (2007) Air Transportation: A Management Perspective. Ashgate Publishing Limited, Sixth Edition.
  5. Boeing Commercial Airplane Company (BCAC) (1993) Airline Evaluation Seminar.
  6. Ryu K, Sanchez A (2003) The Evaluation of Forecasting Method at an Institutional Food Service Dining Facility. J Hospitality Financial Manag 11: 27-45.
  7. Cacatto C, Belfiore P, Vieira JG (2012) Forecasting Practices in Brazilian Food Industry. Journal of Logistics Management 1: 24-36.
  8. Poore JW (1993) Forecasting the Demand for air Transportation Services. J Transportation Engineering.
  9. Abed SY, Ba-Fail AO, Jasimuddin SM (1998) An Econometric Analysis of International Air Travel Demand in Saudi Arabia. J Air Transport Manag 7: 143-148.
  10. Adeniran AO, Ben SO (2017) Understanding Econometric Modeling: Domestic Air Travel in Nigeria and Implication for Planning Process. J Applied Res in Industrial Eng 4: 240–251.
  11. International Air Transport Association (IATA) (2002) IATA Global Airport Monitor in 2002.
  12. Afolayan OS, Asaju AJ, Malik NA (2012) Variation in Spatial Trend of Passengers and Aircrafts Movement in Nigerian International Airports. Inter J Humanities and Social Sci 2: 126-133.
  13. Alperovich G, Machnes Y (1994) The Role of Wealth in the demand for International Air travel. J Transport Economics and Policy 28: 163-173.
  14. Butler W, Robert K, Robert P (1974) Methods and Techniques of Business Forecasting. Englewood Cliffs, NJ: Prentice-Hall.
  15. Ghobrial A (1992) Aggregate Demand Model for Domestic Airlines. J Advanced Transportation.
  16. ICAO (2006) Safety Management Manual (SMM), Doc 9859 AN/460. (1st edn), International Civil Aviation Organisation, Montreal.
  17. Kothari CR (2004) Research Methodology: Methods and Techniques. (2nd edn), New Age International Publishers, New Delhi.
  18. Marazzo M, Scherre R, Fernandes E (2010) Air Transport Demand and Economic Growth in Brazil: A Time Series Analysis. Transp Res Part E Logist Transp Rev 46: 261-269.
  19.  Organization of Economic Co-operation and Development (OECD) (2015) The Metropolitan Century: Understanding Urbanization and its Consequences.
Citation: Adeniran AO, Stephens MS (2018) The Dynamics for Evaluating Forecasting Methods for International Air Passenger Demand in Nigeria. J Tourism Hospit 7: 366.

Copyright: © 2018 Adeniran AO, et al. This is an open-access article distributed under the terms of the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original author and source are credited.
Top