FOREIGN TRADE UNIVERSITY FACULTY OF
INTERNATIONAL ECONOMICS
=====000=====
ECONOMETRIC REPORT
FACTORS THAT INFLUENCE THE LEVEL OF
USING BUS AS A MEANS OF TRANSPORTATION
IN THE URBAN AREAS
Instructor: Assoc. Prof. Tu Thuy Anh
Group 3 - JIB – K57
ID
Name
Class
1815520167
Le Thuy Hang
English 06
1815520164
Nguyen Thi Thu Ha
English 06
1815520194
Nguyen Phuong Linh
the increasing demand for public transportation, buses take priority over the vehicles on
the road. In developed countries in the world: USA, Western Europe, Japan,... buses
become the main means of transportation. These developed countries often have hundreds
of kilometers length bus routes in order to meet the requirements of transport of the
citizen. The citizen goes to school by bus, goes to work by bus and hangs out by bus too.
Besides, using personal vehicles makes you pay a lot of money for gasoline, oil,
repair costs, equipment maintenance, car wash, even pay the monthly parking fee, taking
bus if different. Using bus can greatly reduce our costs compared to using personal
vehicle. For many people, using motorbikes is much more convenient and time-saving,
but we always have to bring a raincoat or a sundress, or have a mask in the trunk. We also
suffered standing for 15 minutes outdoors in the 40 degree Celsius on the road and
standing for hours inhaling dust and smoke. Instead, we can enjoy cool conditioning when
taking the bus. Therefore, the using bus as a means of transportation brings many benefits
and widespread. But not everyone chooses the bus to move. Many people don’t want to
take the bus for objective reasons such as hustle and bustle on the bus on rush hour or
subjective reason is car sickness...
In order to find out more about this issue, our team decided to study the topic: “Factors
that influence the level of using bus as a means of transportation in the urban areas.”
To the extent of purpose and resources, there are still deficiencies in this
econometrics assignment but we look forward to providing readers with a decent view of
the overall of the data set given and the knowledge that we have gained through Dr. Tu
Thuy Anh’s Econometrics course.
2
2. THEORETICAL BASIS
Bus is a very popular transportation these days, especially to student and the low
income. Number of bus user depends on some factors which can be mentioned as:
Meaning
Unit
Variable Form
The level of using bus in
urban area
Thousand
people/ hour
Dependent
variable
X2 FARE
Fare
USD
Independent
variable
X3 INCOME
Income per capita
USD/person
4.1. Data description:
4.1.1. Statistical description table
Summary Statistics, using the observations 1 – 40
Variable
Median
Minimum
Maximum
Std. Dev.
Missing
obs.
BUSTRAVL
1589,6
18,100
13103,
2431,8
0
FARE
1243,9
0
Exhibit 2. Describe statistical sample data
(Source: we calculated it based on the statistic in the Gretl software)
Where:
- BUSTRAVL: the number of people using the bus in an hour in a locality. The
difference between the lowest value and the highest value is quite high: on average
1.589.600 people/hour.
- FARE: the bus fares used in the metropolitan areas are 0.5 USD with the lowest
price and 1.5 USD with the highest price. The difference is not significant. The average
price is 0.8 USD.
- INCOME: The average annual income of urban bus users is at an average level
in the US, with the difference between the highest value (21 886 USD) and the lowest
value (12 349 USD) is not large. It can be seen that this is the average salary in the US,
with the highest salary of 21 886 USD is still not high in the US.
- POP: The average population of the US is about 555 000 people, and it can be
considered as a high population level. However, the difference between the largest value (7
323 300 people) and the smallest value (167 000 people) is substantial. In the US, there are
many cities with a high population, up to 7 323 300 people such as New York, Los Angles.
Meanwhile, the bus users are just about 18 000 people. We can conclude that: in the big,
densely populated and developed cities, the more income people get, the less they use the
5
bus. In the sparsely populated city, for example about 167 000 people, maybe the
infrastructure has not been developed yet, the demand for traveling is not high so people
don’t use the bus often.
1,0000
0,3351
INCOME
1,0000
POP
Exhibit 3. Correlation matrix
(Source: we calculated it based on the statistic in the Gretl software)
From the matrix, it can be inferred that the correlation between bustravl and each of the
independent variables. Specifically:
r (BUSTRAVL,FARE) = - 0,0480
low correlation level, negative correlation
r (BUSTRAVL,INCOME) = 0,2287
low correlation level, posittive correlation
r (BUSTRAVL,POP) = 0,9313
high correlation level, postitive correlation
4.2. Estimated result and disussion:
4.2.1. Estimated result:
Model 1: OLS, using observations 1-40
−0,116272
0,0712854
−1,631
0,1116
1,88836
0,119904
15,75
1,00e-017
POP
**
***
Mean dependent var
1933,175
S.D. dependent var
2431,757
659,4012
666,1567
Hannan-Quinn
661,8438
Log-likelihood
Schwarz criterion
Excluding the constant, p-value was highest for variable 2 (FARE)
Exhibit 4. Estimated result based on OLS method
(Source: we calculated it based on the statistic in the Gretl software)
From the exhibit 4, we have a random sample regression model:
BUSTRAVL = 2683,59 − 609,126. FARE − 0,116272. INCOME + 1,88836. POP + e i
* From the result, it can be inferred that:
̂
β1= 2683,59: the level of traveling by bus in urban areas is 2683,59 thousand people/hour in case of not being influenced by the other factors.
̂
β2= − 609,126: If the bus fares increase 1 USD, the people traveling by bus decrease by 609,126 thousand people/hour, in case of the other factors not changed.
̂
β3= − 0,116272: If per capita income increases by 1 USD/ person, the level of travel by bus in the city decreases by 0,116272 thousand
P-value(β4)= 1,00e-017 < 0,00001< 5% => Reject H0, β4 is significant.
* Tests of hypothetical violations:
a. Test omitted variables bias:
Auxiliary regression for RESET specification test OLS,
using observations 1-40 Dependent variable:
BUSTRAVL
coefficient
std. error
--------------------------------------------------------------const
1214,48
1378,42
FARE
186,713
593,256
INCOME
−0,0310650
0,0776781
POP
−0,0711677
0,958716
yhat^2
0,000248918
0,000109830
yhat^3
−1,32053e-08
5,66970e-09
t-ratio
Frequency distribution for uhat1, obs 1-40
number of bins = 7, mean = -1,42109e-014, sd = 876,78
interval
< -1400,5
-1400,5
-762,18
-123,83
514,52
1152,9
>=
-762,18
-123,83
514,52
1152,9
1791,2
1791,2
midpt
-1719,7
frequency
1
-1081,4
-443,00
195,35
833,70
1472,0
Test for null hypothesis of normal distribution:
Chi-square(2) = 0,805 with p-value 0,66870
Exhibit 6. Test the normal distribution
(Source: we calculated it based on the statistic in the Gretl software)
P-value = 0,66870 > 0,05. At the 5% significant level, the model has a standard distribution.
c. Multicollinearity test
Signal 1: High
2
and low t-statistics
Low t-ration of variables FARE, INCOME meanwhile t-ration of variable POP is high.
Therefore, regression coefficients of independent POP are statistically significant, the rest
are not.
The model maybe exist multicollinearity
Signal 2: Correlation between independent variables:
Correlation coefficients, using the observations 1 - 40
5% critical value (two-tailed) = 0,3120 for n = 40
FARE
1,0000
FARE regression according to INCOME and POP:
Model 2: OLS, using observations 1-40
Independent variable: FARE
Coefficient
1,07539
−1,20666e-05
1,01731e-05
const
INCOME
POP
R-squared
Std. Error
0,380066
2,31427e-05
3,90336e-05
t-ratio
2,829
−0,5214
0,2606
p-value
0,0075
0,6052
0,7958
***
1094,95
1159,32
0,260324
t-ratio
15,32
−0,5214
2,179
p-value
0,2606
2,179
p-value
0,1372
0,7958
0,0358
**
0,113930
Exhibit 10. Estimated the regression model of POP independent variable according to FARE
and INCOME (Source: we calculated it based on the statistic in the Gretl software)
Vì
2
11
d. Testing the error variance:
Signal 1: Using qualitative methods (visual methods)
Graph of ei according to BUSTRAVL
Comment: From the graph, the values on the graph are not evenly distributed
Have the sign of disease error variance
Signal 2: UsingWhite-test
- Conduct regression of sub-model:
e2i = α1 + α2. FARE + α3. INCOME + α4. POP + α5. FARE 2 + α6. FARE. INCOME + α7. FARE. POP + α8INCOME2 + α9. INCOME. POP +
α10. POP2 + vi
12
- The result shown in the table:
White's test for heteroskedasticity
OLS, using observations 1-40
Dependent variable: uhat^2
coefficient
std. error
--------------------------------------------------------------const
5,19333e+06
8,74264e+06
FARE
−1,84745e+06
−0,2967
−0,4799
0,4811
−0,8519
0,8072
0,1581
0,2089
−0,3532
−0,2125
0,5570
0,7687
0,6348
0,6340
0,4010
0,4259
0,8755
0,8359
0,7264
0,8332
Unadjusted R-squared = 0,145698
Test statistic: TR^2 = 5,827904,
with p-value = P(Chi-square(9) > 5,827904) = 0,757011
Exhibit 12. Testing error variance with the quantitive method White-test
(Source: we calculated it based on the statistic in the Gretl software)
- Hypothesis: {
H0: PSSS unchanged
−1,203
−1,740
21,21
p-value
0,0504
0,2367
0,0903
−455,497
949,072
POP
2455,89
5105,07
sq_FARE
−1,84226e+06
2,16245e+0
6
X2_X3
297,210
368,212
X2_X4
116,104
734,557
sq_INCOME
0,00541227
0,0259041
X3_X4
−0,112996
0,319942
sq_POP
−0,0440935
0,207512
t-ratio
p-value
0,5940
- Hypothesis: {
H0: PSSS unchanged
H1: PSSS changed
- p-valute = 0.757011 > 5%, so rejectH0
The model still suffers from PSSS at 5% significant level
However, because the Robust test has controlled the error variance, we can still use the
model after the Robust without affecting the deductive.
14
4.2.2. Discussion
The model we used to interpret is:
BUSTRAVEL = 2683.59 – 609.126.FARE – 0.116272.INCOME + 1.88836.POP (1)
From the above model estimation, tests and solutions, we have drawn the best model
available:
BUSTRAVEL = 2683.59 – 609.126.FARE – 0.116272.INCOME + 1.88836.POP (2)
Model (2) has been applied with Robust to control the error: Heteroscedasticity
Model (1) has the error: Heteroscedasticity.
For the Heteroscedasticity, our team implemented Robust test and obtained the
model (2), although it could not fix the errors but was controlled and the model
fully reflect all faces of the problem. If possible, we should study some more
explanatory variables such as gasoline prices, prices of alternative vehicles such as
motorcycles, cars or the level of satisfaction of people when they take the bus.
Again, due to the limitation of understanding and resources, our report may
contain misinterpretations. We hope that Dr. Tu Thuy Anh and readers can give us
constructive comments on the report so that we would improve ourselves and do
better in the future.
Sincerely.
16
REFERENCES
1. Textbook Introduction to Econometrics, Brief edition, James H.Stock and Mark
W.Waston
2. Gretl software, Ramanathan Data 4-4
3. Website:
/> />