EC5003: Business Statistics and Data Analysis Report, UEL, 2020

This report analyzes the vehicle market in 22 countries, examining variables such as per capita income, vehicles per thousand population, population, and population density. It utilizes scatter graphs to visualize relationships between variables, revealing correlations and independent relationships. The report constructs regression equations to predict vehicle ownership based on per capita income and population, and assesses the impact of various factors on vehicle ownership. It compares two regression equations and predicts the total number of vehicles and vehicles per thousand in Turkey, discussing the limitations of the regression model and the reasons for discrepancies between predictions and actual figures. The report is based on data provided by AutoMobile Inc. and is a student submission on Desklib.

B09406
Business Statistics and
Data Analysis

Table of Contents
INTRODUCTION...........................................................................................................................3
a) Scatter graphs of vehicles per thousand against income, population, population density and
% population urban areas.................................................................................................................4
b) Regression line for the vehicles per thousand population and per capita income.......................8
c) Scatter graphs of total vehicle ownership against population, population density per square km
and population in urban areas........................................................................................................10
d) Regression equation for variable more closely correlated to total vehicle ownership..............13
e) Comparison between two regression equations:......................................................................15
f) Estimated total number of vehicles and number of vehicles/1000 Turkey...............................15
CONCLUSION..............................................................................................................................16
REFERENCES..............................................................................................................................17

INTRODUCTION
This project report carries the study of vehicle market in 22 countries. The data found
classified on the basis of various variables like per capita income, vehicles per thousand
population, population in millions, density population and percentage of population in urban
areas. Two regression equations based on per capita income, vehicles per thousand,
population in millions and total vehicles ownership has been found. This equation has been
used to predict estimated total vehicles ownership and number of vehicles per thousand in
Turkey.

a) Scatter graphs of vehicles per thousand against income,
population, population density and % population urban areas
Vehicles per 1000 Vs Income
5 10 15 20 25 30 35 40 45
0
100
200
300
400
500
600
700
800
Scatter Graph
Denmark
Austria
Belgium
Switzerland
Czech Republic
Germany
Spain
Finland
Great Britain
Greece
Hungary
Ireland
Iceland
Italy
Luxembourg
Netherlands
Norway
Poland
Sweden
Per capita income
Vehicles per 1000 pop
Interpretation: In scatter graph; all countries dots sign are moving in same direction and
closely plotted, which shows close relationship or positive relationship. For instance, if
income of population rises than vehicle per 1000 population raise and decrease in income
simultaneously reduce the demand of vehicle per 1000 population.

Vehicles per 1000 Vs Population
0 100 200 300 400 500 600
0
100
200
300
400
500
600
700
800
Scatter Graph
Austria
Belgium
Switzerland
Czech Republic
Germany
Denmark
Spain
Finland
Great Britain
Greece
Hungary
Ireland
Iceland
Italy
Luxembourg
Netherlands
Norway
Poland
Sweden
Population (mill)
Vehicles per 1000 pop
Interpretation: The scatter graph shows plots are situated far from each other, and showing
independent relationship with each other. This indicates that there is no close relationship
between vehicle per thousand and population in millions.

Vehicles per 1000 Vs Population Density
55 60 65 70 75 80 85 90 95 100
0
100
200
300
400
500
600
700
800
Scatter Graph
Austria
Belgium
Switzerland
Czech Republic
Germany
Denmark
Spain
Finland
Great Britain
Greece
Hungary
Ireland
Iceland
Italy
Luxembourg
Netherlands
Norway
Poland
Sweden
Population Density/KM ^2
Vehicles per 1000 pop
Interpretation: The scatter graph shows plots are situated far from each other, and showing
independent relationship with each other. This indicates that there is no close relationship
between vehicle per thousand and population density per KM2 in millions (Julià, Comas and
Vives-Rego, 2000).

Vehicles per 1000 Vs %Population
5 10 15 20 25 30 35 40 45
0
100
200
300
400
500
600
700
800
Scatter Graph
Austria
Belgium
Switzerland
Czech Republic
Germany
Denmark
Spain
Finland
Great Britain
Greece
Hungary
Ireland
Iceland
Italy
Luxembourg
Netherlands
Norway
Poland
Sweden
%Population
Vehicles per 1000 pop
Interpretation: The scatter graph points are very far plotted which shows independent
relationship with each other. But some plotter are showing close to linear line but moving
opposite sides; this indicates that there is opposite relationship between vehicle per thousand
and percentage of population in urban areas. For instance, Increase in percentage of
population in urban areas very rarely impact vehicle per thousand population.
.

b) Regression line for the vehicles per thousand population and per
capita income
Regression line is the equation which builds relationship between independent variable
and dependent variable. In this case, from scatter plot diagram it was found that per
capita income and vehicles per thousand populations are closely related, hence it was
decided to form regression equation for these two variables (Goodman, 1959). Where
per capita income is independent variable and vehicles per thousand populations is
dependent on income variable. If per capita income rises than it is estimate that vehicles
per thousand populations will also increase. Below the regression line equation:
Y= a + bx
Where Y: Dependent variable (Vehicles per thousand populations)
And X : Independent variable (Per capita income)
The line of best fit is described by the equation ŷ = bX + a, where b is the slope of the
line and a is the intercept (i.e., the value of Y when X = 0). This calculator will
determine the values of b and a for a set of data comprising two variables, and estimate
the value of Y for any specified value of X (Miller, 1994).
X Y X – Mx Y – My (X – Mx)2 (X – Mx)( Y – My)
26.3 629 2.71 110.55 7.3441 299.5905
24.7 520 1.11 1.55 1.2321 1.7205
27.7 559 4.11 40.55 16.8921 166.6605
13.6 390 -9.99 -128.45 99.8001 1283.216
23.5 586 -0.09 67.55 0.0081 -6.0795
25.9 430 2.31 -88.45 5.3361 -204.32
19.3 564 -4.29 45.55 18.4041 -195.41
24.3 488 0.71 -30.45 0.5041 -21.6195
23.7 576 0.11 57.55 0.0121 6.3305
23.6 515 0.01 -3.45 0.0001 -0.0345
16.1 422 -7.49 -96.45 56.1001 722.4105
12.3 306 -11.29 -212.45 127.4641 2398.561
29.8 472 6.21 -46.45 38.5641 -288.455
26.7 672 3.11 153.55 9.6721 477.5405
23.3 656 -0.29 137.55 0.0841 -39.8895
42.6 716 19.01 197.55 361.3801 3755.426

25.3 477 1.71 -41.45 2.9241 -70.8795
28.1 521 4.51 2.55 20.3401 11.5005
9.6 370 -13.99 -148.45 195.7201 2076.816
25.4 500 1.81 -18.45 3.2761 -33.3945
471.8 10369 965.058 10339.69
Calculation Summary
Sum of X = 471.8
Sum of Y = 10369
Mean X = 23.59
Mean Y = 518.45
Sum of squares (SSX) = 965.058
Sum of products (SP) = 10339.69
Regression Equation = ŷ = bX + a
b = SP/SSX = 10339.69/965.06 = 10.71406
a = MY - bMX = 518.45 - (10.71*23.59) = 265.70531
ŷ = 10.71406X + 265.70531

Interpretation: The result shows that there is positive relationship between both
variables, as per capita income increases; demand for vehicles per thousand populations
also increases. The regression line found is Y = 10.71X + 265.71; through this
regression equation results can be found simply by changing independent variable and
seeing effect on dependent variable Y (Kvanli, Pavur, and Guynes, 1999).
c) Scatter graphs of total vehicle ownership against population,
population density per square km and population in urban areas.
Total vehicle ownership Vs Population:
0 10 20 30 40 50 60 70 80 90
0
10
20
30
40
50
60
Scatter Graph
Denmark
Austria
Belgium
Switzerland
Czech Republic
Germany
Spain
Finland
Great Britain
Greece
Hungary
Ireland
Iceland
Italy
Luxembourg
Netherlands
Norway
Poland
Sweden
Population
Vehicle Ownersip

Interpretation: The scatter graph shows plots are situated far from each other, but
showing linear line. This indicates that there is there can be positive relationship
between vehicle owned and population in millions.
Total vehicle ownership Vs Population density:
55 60 65 70 75 80 85 90 95 100
0
10
20
30
40
50
60
Scatter Graph
Denmark
Austria
Belgium
Switzerland
Czech Republic
Germany
Spain
Finland
Great Britain
Greece
Hungary
Ireland
Iceland
Italy
Luxembourg
Netherlands
Norway
Poland
Sweden
Population density
Vehicle Ownersip
Interpretation: The scatter graph shows plots are situated far from each other, and
showing independent relationship with each other. This indicates that there is no close
relationship between vehicle owned and population density per KM2 in millions.

Total vehicle ownership Vs %Population in Urban areas:
55 60 65 70 75 80 85 90 95 100
0
10
20
30
40
50
60
Scatter Graph
Denmark
Austria
Belgium
Switzerland
Czech Republic
Germany
Spain
Finland
Great Britain
Greece
Hungary
Ireland
Iceland
Italy
Luxembourg
Netherlands
Norway
Poland
Sweden
% population urban
Vehicle Ownersip
Interpretation: The scatter graph points are very far plotted which shows independent
relationship with each other. But some plotter are showing close to linear line but
moving opposite sides; this indicates that there is opposite relationship between vehicle
owned and percentage of population in urban areas. For instance, Increase in percentage
of population in urban areas very rarely impact vehicle owned.