Some Statistics
And now some raw data for you Statistics Hounds. For both an Econometrics project and an International Economic Law and Development paper, I've consolidated Primary Energy Consumption data from the BP Statistical Review Of World Energy 2007, with Nominal GDP data from the October 2007 IMF World Economic Outlook Databse, with Population and Fertility Rate data from the US Census Bureau's International Data Base into two Excel spreadsheets covering 56 countries and the world at large.The reason there are two spreadsheets is that the data is not entirely complete. Energy data goes back for most countries to 1965, but ex-Soviet states present a bit of a problem before 1991. GDP data only goes back to 1980 and fertility rates are a mess - with some countries having good data back to the 60's but others, including many European nations, not having any until the early 90's! Even the countries with lots of fertility data often skip years.
The first file is "all data simple" where I've already divided by population and produced "per capita nominal GDP" and "per capita primary energy consumption", but which includes the incomplete lines. The second is "all complete data simple", where I've deleted any line missing at least one data point.
So, here they are: all data simple and, all complete data simple
Update: Here are the same files with two improvements.
all data simple real fertility and all complete data simple real fertility
First, after a lot of tedious work, I've converted all the nominal dollar data into real $US-2000 data - which should provide a more satisfactory proxy for the average citizen's purchasing power of international products. This was actually pretty hard, since each country's real data is in local currency with widely different base-years. I prefer Real-GDP to "purchasing power parity" because I'm focused on energy consumption, and energy sources and energy-intensive products are priced uniformly (subtracting transportation costs) in global markets.
Second, I've estimated the missing fertility data. I have all the population data, so I assumed that the relationship between population growth (which I know) and fertility rate (which I don't) would be equal to the ratio in the nearest complete data line for that nation. This is not a perfectly accurate assumption, but it's pretty good.
After that, all I'm really missing is the international GDP data prior to 1980, but there's plenty of data without it! I'll have access to both STATA software and an expert Econometrician on Monday, so the analysis begins next week - stay tuned!
Update 2: And here's the data all the way back to 1965 in International Dollars By Purchasing Power Parity from the Penn World Tables, along with the average Real Year-2000 Dollar Oil Price Per Year from the Federal Reserve Economic Data website.
All Data PPP 1965-2004
Update 3: Super Ultimo Data - From 1965-2006 for almost all countries, AND, by the US rows, data on prices and imports of Aluminum, Cement, Nitrogen (Ammonia), Copper, and Steel.
All Data PPP 1965-2006 PLUS US Energy Intensive Imports

Comments