COL 110 Mathematical Modeling with Data

COL 110 Mathematical Modeling with Data

Introduction

The paper aims at implementing and analyzing mathematical modeling with accessed data. The paper applies the desired modeling method on the key aspects of the UAE economy. In the light of provided instructions, the paper collects all facts and figures from the identified sources and then organizes data into different sections. In addition to this, the paper uses different excel functions to observe and analyze changes and trends in the performance of the identified aspects of economy. The paper supports data collection and analysis with the help of reasons and research basis. Finally, the paper provides conclusion on the overall understanding of the subject matter.

Data Collection and Representation

All the relevant data, figures and economic statistics were accessed from the official websites of government of UAE, government of Dubai and Zayed University. Observations were made and analysis was conducted on the basis of results obtained via different excel formulas and functions. Pictorial representation is used to create better understanding of the economic performance trend of the UAE.

List of Excel Project Sections

GDP of UAE

GPD

GDP per Capita

GDP growth Rate

UAE Population

Population by Emirates

Percentage Distribution of Population by Emirates

Economic Sectors of UAE

Manufacturing Industry

Manufacturing Activity Contribution

Output of Manufacturing Activity

Manufacturing Activity Growth Rate

Labor Share

Foreign Trade

Growth Rate of Imports and Exports

Index Performance of Imports and Exports

Trade Exchange Rate

Tourism Industry

GDP Share of Hotels and Restaurants

Activity Output of Hotels and Restaurants

Growth of Hotels and Restaurants

Mining Industry

Average Labor Wage

Labor Productivity

Labor Share to Mining Industry

Social and Personal Service Industry

Social Service contribution to GDP

Labor productivity

Labor Share to GDP

Financial Service Industry

Output of financial service industry

Growth trend of financial service industry

Transport, Storage and Communication Industry

Output of transport industry

Labor contribution to transport industry

Real Estate and Business Industry

Contribution of real estate and business industry to GDP

Labor contribution to real estate and business industry output

Agriculture Industry

Agriculture industry share to GDP

Labor share to agriculture industry

Construction Industry

Construction activity share to GDP

Data Analysis

National Population of UAE

EMIRATE

2006

2007

2008

2009

2010

Abu Dhabi

1,430,000 14,930,000 385,655 398,148 404,546 Dubai

1,372,000 14,780,000 168,029 164,448 157,514 Sharjah

821,000 882,000 153,365 151,506 147,855 Ajman

212,000 224,000 42,186 41,852 41,192 Umm Al-Quwain

50,000 52,000 17,482 17,296 16,930 Ras Al-Khaimah

214,000 222,000 97,529 96,329 93,973 Fujairah

130,000 137,000 64,860 63,802 61,738

Sum

4,229,000 448,800 929,106 933,381 923,748

Table 1: National Population of UAE (National Bureau of Statistics, 2012, p. n.d.)

Figure 1: Summative Trend of UAE National Population

Excel Functions and Data Analysis

In the excel sheet, sum and average functions were used to analyze the trend of UAE's national population. The rationale behind these functions is the effectual analysis of all figures during a given time frame. Figure 2 shows that average population of UAE is 4,461,000.

Figure 2: Average Population Analysis

Figure 3: Population Percentage Change Analysis

Gross Domestic Products (GDP)

Table 2 provides four year data on the GDP performance of UAE economy.

 Gross Domestic Product (GDP)

2008

2009

2010

2011

GDP at Current Prices (million AED)

345,759

295,441

304,585

315,392

GDP per capita at Current Prices (AED)

210,063

166,823

159,847

157,446

GDP per capita growth rate at Current prices (AED)

4.10%

-20.60%

-4.20%

-1.50%

GDP growth rate at Current Prices

12.00%

-14.60%

3.10%

3.50%

GDP at Constant prices (million AED)

293,103

285,162

295,256

304,989

GDP growth rate at Constant prices

3.50%

-2.70%

3.50%

3.40%

GDP Deflators

117.96

103.6

103.16

103.41

Non-Oil GDP at Constant prices

287,680

279,788

290,097

300,308

Oil sector value ...