R codes to import data from google sheet:

아래 R codes Google sheet 에서 직접 데이터를 불러서 분석하는 것입니다.

데이터는 아래에서 가져와서 구글에 저장했습니다.

Source: https://tradingeconomics.com/

myurl<-“https://docs.google.com/spreadsheets/d/e/2PACX-1vTQ5OXZ5SbiFJeBuyaDGmJ4iEDLaYkVBu5AWA2jvG1xIXv3oULdOfi5U-zZ8F3QqBBuHmLPWmGoNuAZ/pub?gid=0&single=true&output=csv&#8221;

Trading_Econ<-read.csv(url(myurl))

summary(Trading_Econ)

attach(Trading_Econ)

plot(Inflation.rate,Jobless.rate)

hist(GDP.YoY,col=’red’)

attach(Trading_Econ)

barplot(GDP.YoY, main=’GDP YoY’, col=’blue’,

names.arg=Country, cex.names = 0.5)

barplot(GDP.QoQ, main=’GDP QoQ’, col=’red’,

names.arg=Country, cex.names = 0.5)

hist(GDP.QoQ,col=’red’)

barplot(Inflation.rate, main=’Inflation Rate’, col=’red’,

names.arg=Country, cex.names = 0.5)

hist(Inflation.rate,col=’red’)

barplot(Jobless.rate, main=’Jobless Rates’, col=’yellow’,

names.arg=Country, cex.names = 0.5)

hist(Jobless.rate,col=’yellow’)

Foreign Exchanges Reserves as of February 2016

The foreign reserves of China and Korea decreased from previous period by $28,572 million and $1,530 million respectively. However, the foreign reserves of German, Japan and France increased from the previous period.

Obs Country

Current

Previous

Highest

Difference

Percent

Reference
1 United States

117188

117581

153075

-393

( 0.3%)

USD Million
2 Euro Area

332917

333872

340247

-955

( 0.3%)

USD Million
3 China

3202321

3230893

3993213

-28572

( 0.7%)

USD Million
4 Japan

1254100

1248107

1306668

5993

0.5%

USD Million
5 Germany

177917

164656

203337

13261

6.5%

EUR Million
6 United Kingdom

134342.8

135181

135181

-838.2

( 0.6%)

USD Million
7 France

160.01

151

187

9.01

4.8%

EUR Billion
8 Brazil

359368

357507

379156

1861

0.5%

USD Million
9 Italy

130926.5

123132

147910

7794.5

5.3%

EUR Million
10 India

353410

350860

383643

2550

0.7%

USD Million
11 Russia

380544

371559

596566

8985

1.5%

USD Million
12 Canada

81290

81182

81290

108

0.1%

USD Million
13 Australia

61222

61585

84610

-363

( 0.4%)

AUD Million
14 South Korea

365760

367290

374749

-1530

( 0.4%)

USD Million
15 Spain

51547.84

50225

64355

1322.84

2.1%

EUR Million
16 Mexico

176321

177597

199161

-1276

( 0.6%)

USD Million
17 Indonesia

104500

102100

124638

2400

1.9%

USD Million
18 Netherlands

37573

36127

44319

1446

3.3%

EUR Million

Note: U.S. Mexico and Euro area are as of January 2016 and India is as of March 2016





Source: Trandingeconomics

Annual GDP Growth Rates for G-20 countries as of December 2015

전세계경제 속도는 는 작년 4분기 에 낮아지고 있었습니다. 3분기 전세계경제 성장률은 2% 였었습니다. 하지만 4분기 평균경제 성장률은 1.9% 으로 0.1% 정도 낮아졌습니다. 한국은 년평균 3% 의 경제성장률을 보였는데 이숫자는 3분기 대비 0.3% 상승한 숫자이고 또한 전세계에서 5위의 경제성장률을 보였습니다.  특히 선진국의 경제 성장률이 낮았습니다.

The world economy slowed down during the fourth quarter of 2015. The average annual growth rate of GDP for G-20 countries dropped to 1.9% in fourth quarter from 2.0% in the third quarter.

Table: Annual GDP growth rates for G-20 countries in the 4th quarter in 2015.

Obs

Country

Annual GDP Growth Rate

Difference from Previous quarter

Annual GDP Growth Rate rank

Difference rank

1

United States

1.9

-0.2

9

13

2

Euro Area

1.6

0

11

9

3

China

6.8

-0.1

2

11

4

Japan

0.7

-1

15

17

5

Germany

2.1

0.4

8

1

6

United Kingdom

1.9

-0.2

9

13

7

France

1.4

0.3

13

3

8

Brazil

-5.9

-1.4

18

18

9

Italy

1

0.2

14

7

10

India

7.3

-0.1

1

11

11

Russia

-3.8

0.3

17

3

12

Canada

0.5

-0.6

16

16

13

Australia

3

0.3

5

3

14

South Korea

3

0.3

5

3

15

Spain

3.5

0.1

4

8

16

Mexico

2.5

-0.1

7

10

17

Indonesia

5.04

0.31

3

2

18

Netherlands

1.6

-0.3

11

15

The following chart shows the annual GDP growth rates for G-20 countries in fourth quarter of 2015. Korea was ranked at 5th.


The following chart displays the annual GDP growth rates difference from the previous quarter (3rd quarter 2015). For example, US growth rate declined from 2.1% to 1.9%. Korea’s growth rate increased from 2.7% to 3.0. The average is -0.1% which implies that the world economy was slowing down from third quarter to fourth quarter in 2015.


The average annual growth rates of G-20 countries is 1.9% in the fourth quarter of 2015 and average difference from the previous quarter is -0.1%.

Source: Trandingeconomics

GDP Growth Rates of G-20 Countries as of 2nd Quarter 2015

지난 2분기 평균 경제성장률은 0.7% 입니다. 한국은 0.3%  지난 1분기보다 0.5%  줄어습니다. 미국은 3.9% 성장으로 단연 선두 그리고 인도네시아가 3.78% 으로 2 그리고 인디아와 중국이 뒤따르고 있습니다,

아래차트  1분기대비 경제성장률 차이인데 한국은 0.5% 이 줄었습니다. 이에 비해 미국은 3.3% 늘었습니다. 가장 많이 줄어든 나라가 일본 (-1.4%) 으로 아베노믹스의 실효성에대해서 의문이 들게합니다. 그리고 브라질과 오스트레리아가 뒤을 따릅니다.


이차트를 보시면 미국과 인도네시아가 확연히 다른나라들보다 눈에 좋아보입니다, 이에 비해 러시아 브라질 그리고 일본은아주 안좋아보입니다. 한국은 평균이하입니다. EU 전체보다 한국의 경제 성장률이 안좋아보입니다,

Source: Traingeconomics