RDP 2001-05: Understanding OECD Output Correlations Appendix B: Data

We consider 17 OECD countries; these and their associated two-digit ISO codes are listed in Table B1. These countries are selected on the basis of data availability across all of the various bilateral variables we consider.

Output

Table B1: Data Sources for Output
Country ISO code Quarterly real GDP
Australia AU ABS National Accounts Cat No 5206.0, Table 5
Austria AT OEOCGVOLG
Canada CA CNGDP…D; CNI99BVRG
Denmark DK DKOCGVOLG
Finland FI FNI99BVPH
France FR FRGDP…D; FROCGVOLG
Germany DE WGGDP…D
Italy IT ITGDP…D; ITI99BVRG
Japan JP JPGDP…D; SNA68
Netherlands NL NLGDO…D; NLOCGVOLG
New Zealand NZ NZGDP…D; RBNZ
Norway NO NWI99BVPH
Spain ES ESGDP…D; ESOCGVOLG
Sweden SE SDI99BVPH
Switzerland CH SWOCGVOLG
United Kingdom GB UKABMI
United States US USGDP…D

Notes: Unless otherwise indicated, codes are for Datastream. Where two sources of data are indicated it is because we do not have an historical series over the 1960–2000 period; series from the two sources are spliced. Some series are not available seasonally adjusted for a substantial portion of the sample; for these series, we use a simple moving average filter as described in Davidson and MacKinnon (1993).

We use quarterly real GDP data to construct four-quarter-ended growth rates (constructed as log fourth differences). The sources for the quarterly GDP data are given in Table B1. To calculate the correlations for the various samples discussed in the text, it is necessary in some instances to take account of the fact that we do not have data for all quarters of the sample. This arises because of limited data, particularly for the earlier years, and also because we use a moving average filter to seasonally adjust some of the series. Where there is missing data, we exclude those observations from the calculation of the bilateral correlations only on a pair wise basis; in other words, for each bilateral correlation, we use the maximum data available.

Bilateral trade in goods and services

The index of bilateral trade intensity we use is the natural logarithm of the following measure:

Where Xijt is total nominal exports from country i to country j in period t, Mijt is total nominal imports of country i from country j in period t, and Yit is nominal GDP for country i in period t. All series are measured in USD.

The bilateral trade flows data are from the IMF International Direction of Trade Statistics. For the period 1960–1993, we use the annual data collected by Frankel and Rose (1998) available at <URL:http://www.haas.berkeley.edu/group/eap/>. For the 1993–2000 period, we use the monthly IMF International Direction of Trade Statistics available on Datastream. The monthly data are aggregated to annual data. All series are reported in USD.

Nominal annual GDP is taken from the OECD Economic Outlook, December 2000. The data are converted to USD using year averages of quarterly nominal USD exchange rates for each country. The exchange rate data are from the IMF International Financial Statistics available on Datastream; the codes are reported in Table B2.

Table B2: Data sources
Country
 
Nominal annual
GDP
Real annual
GDP
CPI
 
Long interest
rates
Short interest
rates
Stock market
indices
Exchange
rates
Australia AUOCFGPN AUOCFGDP AUOCPCONF AUI61… AUOCFIST AUOCSPRC AUI..RF.
Austria OEOCFGPN OEOCFGDP OEOCPCONF OEOCLTIR OEOCFIST OEI62…F OEI..RF.
Canada CNOCFGPN CNOCFGDP CNOCPCONF CNOCLNG% CNOCFIST CNOCSPRC CNI..RF.
Denmark DKOCFGPN DKOCFGDP DKOCCPNIF DKOCLTIR DKOCFIST DKOCSPRC DKI..RF.
Finland FNOCFGPN FNOCFGDP FNOCPCONF FNOCLNG% FNOCFIST FNOCSPRC FNI..RF.
France FROCFGPN FROCFGDP FROCPCONF FROCBYG% FROCFIST FROCSPRC FRI..RF.
Germany WGGDP…B WGGDP…D WGCP….F BDOCLNG%R BDOCFIST BDOCSPRC BDI..RF.
Italy ITOCFGPN ITOCFGDP ITOCPCONF ITOCLNG% ITOCFIST ITI62…F ITI..RF.
Japan JPOCFGPN JPOCFGDP JPOCPCONF JPOCLNG% JPOCFIST JPOCSPRC JPI..RF.
Netherlands NLOCFGPN NLOCFGDP NLI64…F NLI61… NLOCFIST NLOCSPRC NLI..RF.
New Zealand NZOCFGPN NZOCFGDP NZOCPCONF NZOCLNG% NZOCFIST NZI62…F NZI..RF.
Norway NWOCFGPN NWOCFGDP NWOCPCONF NWI61… NWOCFIST NWI62…F NWI..RF.
Spain ESOCFGPN ESOCFGDP ESOCPCONF ESI61… ESOCFIST ESOCSPRC ESI..RF.
Sweden SDOCFGPN SDOCFGDP SDOCPCONF SDOCLNGY SDOCFIST SDOCSPRC SDI..RF.
Switzerland SWOCFGPN SWOCFGDP SWOCPCONF SWOCLNG% SWOCFIST SWOCSPRC SWI..RF.
United Kingdom UKOCFGPN UKOCFGDP UKOCPCONF UKOCLNG% UKOCFIST UKOCSPRC UKI..RF.
United States USOCFGPN USOCFGDP USOCPCONF USOCLNG% USOCFIST USI62…F na

Notes: All series are from Datastream. From 1999, EMU exchange rate data is used for the relevant European countries (code: EMI..RF.)

Bilateral foreign direct investment positions

The index of bilateral trade intensity we use is the natural logarithm of the following measure:

Where FIijt is the inward forward investment position in year t of country i from country j; FOijt is the outward foreign investment position in year t for country i in country j. As before, Yit is nominal GDP for country i in period t and all series are measured in USD. The foreign investment positions are taken from OECD Direct Investment Statistics Yearbook 1999. In most instances, the foreign investment series are reported in local currencies; these are converted to USD using the exchange rate series discussed above.

In theory the numerators of the two indices should be the same, however because they are obtained (by the OECD) from different statistical agencies there can be discrepancies between the figures. By taking the maximum we get a measure of the greatest degree of exposure that two countries might have with each other; it is also consistent with the measure of bilateral trade intensities discussed above.

Real interest rates

To calculate real interest rates, we use quarterly nominal interest rates and quarterly consumer price indices. From these, we calculate year average interest rates and price levels. Real interest rates are calculated as an ex post measure:

Where iit is the nominal year average interest rate and Pit is the year average consumer price index. For long interest rates, we use long-term government bonds (usually of 10-year maturity). For short interest rates, we use short-term rates (usually of 3-month maturity). For the price level, we use consumer price indices. All series are available on Datastream. The bilateral series used in estimation, for both short and long rates, is the natural logarithm of the standard deviation of the real interest rate spread:

Real equity returns

To calculate real equity returns we use monthly nominal stock market indices and quarterly consumer price indices. From these, we calculate year average levels and use these to calculate real returns over the year:

Where Sit is the value of the stock index in country i in year t and Pit is the consumer price index described above. The stock market indices are monthly and taken, via Datastream, from either the OECD Economic Outlook or IMF International Financial Statistics. The bilateral series used in estimation is the natural logarithm of the standard deviation of the spread on real equity return:

Exchange rate volatility

We use the standard deviation of the quarterly difference, in logarithms, of the nominal bilateral exchange rates. The data is from Datastream; the codes are identified in Table B2.

Bilateral characteristic variables

We use a number of variables in the empirical models, either as instruments or regressors, which are based upon specific economic or geographic characteristics. The variables typically measure whether or not two countries share a particular characteristic. These variables can be grouped as follows: geographic and language, economic size, industry structure, corporate governance, structural economic reform, and the take-up of new technology.

Geographic and language variables

The geographic and language variables we use are bilateral distance, adjacency, and language; these are taken from Frankel and Rose (1998). The adjacency and linguistic dummies are reported in Table B3; the bilateral distance measure is reported in Table B4.

Table B3: Adjacency and Linguistic Dummy Variables
Upper triangle: adjacency dummy
Lower triangle: common language dummy
  US GB AT DK FR DE IT NL NO SE CH CA JP FI ES AU NZ
US   0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0
GB 1   0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
AT 0 0   0 0 1 1 0 0 0 1 0 0 0 0 0 0
DK 0 0 0   0 1 0 0 0 1 0 0 0 0 0 0 0
FR 0 0 0 0   1 1 0 0 0 1 0 0 0 1 0 0
DE 0 0 1 0 0   0 1 0 0 1 0 0 0 0 0 0
IT 0 0 0 0 0 0   0 0 0 1 0 0 0 0 0 0
NL 0 0 0 0 0 0 0   0 0 0 0 0 0 0 0 0
NO 0 0 0 0 0 0 0 0   1 0 0 0 1 0 0 0
SE 0 0 0 0 0 0 0 0 0   0 0 0 1 0 0 0
CH 0 0 1 0 1 1 0 0 0 0   0 0 0 0 0 0
CA 1 1 0 0 1 0 0 0 0 0 1   0 0 0 0 0
JP 0 0 0 0 0 0 0 0 0 0 0 0   0 0 0 0
FI 0 0 0 0 0 0 0 0 0 0 0 0 0   0 0 0
ES 0 0 0 0 0 0 0 0 0 0 0 0 0 0   0 0
AU 1 1 0 0 0 0 0 0 0 0 0 1 0 0 0   0
NZ 1 1 0 0 0 0 0 0 0 0 0 1 0 0 0 1  

Source: Frankel and Rose (1998)

Table B4: Bilateral Distance
  US GB AT DK FR DE IT NL NO SE CH CA JP FI ES AU NZ
US  
GB 6,360  
AT 7,548 1,236  
DK 6,847 9,57 870  
FR 6,655 341 1,035 1,028  
DE 6,839 511 727 659 400  
IT 7,747 1,434 765 1,532 1,108 1,066  
NL 6,616 358 935 622 428 235 1,295  
NO 6,505 1,155 1,354 485 1,343 1,048 2,009 916  
SE 6,885 1,433 1,244 523 1,544 1,182 1,978 1,127 416  
CH 7,057 748 802 1,145 414 509 696 690 1,556 1,661  
CA 1,037 5,368 6,574 5,913 5,653 5,857 6,735 5,639 5,604 5,999 6,049  
JP 10,142 9,570 9,140 8,700 9,723 9,356 9,867 9,300 8,414 8,179 9,803 10,327  
FI 7,134 1,824 1,442 885 1,911 1,532 2,204 1,505 789 399 1,982 6,279 7,827  
ES 6,733 1,265 1,810 075 1,055 1,421 1,363 1,483 2,392 2,596 1,025 5,698 10,775 2,953  
AU 14,891 17,010 15,992 16,056 16,978 16,585 16,338 16,659 15,965 15,613 16,788 15,880 7,835 15,214 17,700  
NZ 13,463 18,834 18,171 17,977 19,005 18,620 18,562 18,585 17,689 17,461 18,970 14,498 9,285 17,094 19,871 2,229  

Note: Distance is between the business centres of the relevant countries measured in kilometres.

Source: Frankel and Rose (1998)

Economic size

To measure economic size, we use median nominal annual GDP measured in USD for the period 1980–2000. These are constructed from the nominal GDP series identified in Table B2 and converted to USD using the exchange rate series identified in Table B2. For any two countries, we use the natural logarithm of the product of the median GDP measures for both countries as our bilateral index.

Industry structure

This is a measure of the difference between the industry structures of two economies and is based on Imbs (2000); it follows from previous work by Krugman (1991). The index is constructed as follows:

The variable lik,t denotes employment in sector k as a share of total employment in country i. M is the number of sectors and t is the period for which the index is computed. For the empirical work in this paper, we use 1989 data disaggregated to the one digit sector level, which corresponds to the middle of the 1980–2000 sample. The data is from the OECD Labour Force Statistics, various issues.

Corporate governance

We use three variables related to corporate governance taken from La Porta et al (1998). These are country of legal origin, accounting standards and firm ownership concentration. The first identifies the origin of the legal system used by a particularly country; there are four possible groups: English, French, German and Scandinavian. Accounting standards rates each country's accounting standards on a scale of 0–100, with high values indicating good quality accounting standards. Firm ownership measures the concentration of ownership of the top ten non-financial firms for each country. These variables are reported in Table B5.

Table B5: Corporate Governance and Economic Reform Variables
Country
 
Country
of legal origin
Accounting standards
 
Firm ownership
 
Structural
economic reform
United States English 71 0.12 6.50
United Kingdom English 78 0.15 5.81
Austria German 54 0.51 4.50
Denmark Scandinavian 62 0.40 4.81
France French 69 0.24 4.69
Germany German 62 0.50 4.69
Italy French 62 0.60 4.25
Netherlands French 64 0.31 5.00
Norway Scandinavian 74 0.31 4.69
Sweden Scandinavian 83 0.28 5.31
Switzerland German 68 0.48 5.19
Canada English 74 0.24 5.88
Japan German 65 0.13 4.81
Finland Scandinavian 77 0.34 5.13
Spain French 64 0.50 4.50
Australia English 75 0.28 5.38
New Zealand English 70 0.51 5.88

Notes: Country of legal origin, accounting standards and firm ownership are taken from La Porta et al (1998).
Structural economic reform is from The Economist (2001).

For country of legal origin, we construct a dummy variable that is 1 if a country pair shares a common country of legal origin and 0 otherwise. There are 28 such pairs. We also construct dummy variables specific to each possible origin. For accounting standards, we use as an index the natural logarithm of the product of the two countries accounting standards. We use a similar bilateral index for firm ownership concentration.

Structural economic reform

The structural economic reform bilateral index is constructed from an index prepared by Lehmann Brothers and reported in The Economist (2001). On the basis of a large number of indicators, it rates countries on a scale of 0 to 10 on their structural economic policies (0, worst; 10, best). The measure of structural economic reform for each country is reported in Table B5. The bilateral index is constructed as the natural logarithm of the product of the measures for each country.

Technology adoption

This measures the speed with which a country adopts new technology. We use data on the following three new technologies: mobile phones – number per 1,000 people in 1995; personal computers – number per 1,000 people in 1995 and Internet hosts – number per 10,000 people in 1996. Data on these variables are taken from the World Bank Social Indicators. Countries are ranked according to their adoption of each of the new technologies: those in the top third receive a score of 3, those in the middle third a score of 2 and those in the lowest third a score of 1. The scores are then added across the three technologies to give a total score out of 9. These are reported in Table B6.

Table B6: Technology Adoption
Country Mobile phones Per 1,000 pop 1995 Score Personal computers
Per 1,000 pop
1995
Score Internet hosts Per 10,000 pop 1996 Score Total score
 
       
United States 128.40 3 328.00 3 313.16 3 9
United Kingdom 98.00 2 186.20 2 99.01 2 6
Austria 47.60 1 124.20 1 88.27 2 4
Denmark 157.30 3 270.50 3 147.20 2 8
France 23.80 1 134.30 1 32.69 1 3
Germany 42.80 1 164.90 2 66.96 1 4
Italy 67.40 2 83.70 1 19.97 1 4
Netherlands 33.20 1 200.50 2 138.88 2 5
Norway 224.40 3 273.00 3 277.46 3 9
Sweden 229.40 3 192.50 2 211.02 3 8
Switzerland 63.50 2 348.00 3 145.87 2 7
Canada 86.50 2 192.50 2 143.33 2 6
Japan 81.50 2 152.50 1 39.65 1 4
Finland 199.20 3 182.10 2 542.69 3 8
Spain 24.10 1 81.60 1 15.93 1 3
Australia 127.70 3 275.80 3 220.15 3 9
New Zealand 108.00 2 222.70 3 216.81 3 8

Notes: The data are from the World Bank Social Indicators. For each category, ranking is structured as: top 6 = 3; middle 6 = 2; bottom 5 = 1.

An index of difference in speed of adoption is then constructed by taking the absolute difference between the scores of two economies divided by nine. This index then describes how similar two countries are in their adoption of technology.