I want to compare salaries of more than two countries. The data I am using is based on the Occupational Wages around the World (OWW) database. Let's say I want to look at the salaries of the nurse. The salaries are specified in US Dollars and not all of them are collected in the same year, so we have sort of an incomplete data. As an example:
- Year: 2008, Country: Azerbaijan, Annual Salary (USD): 1678.15
- Year: 2007, Country: Singapore, Annual Salary (USD): 19523.57 (no 2008 data)
- Year: 2006, Country: China, Annual Salary (USD): 3338.208 (no 2008 or 2007 data)
According to the author of the database (Freeman and Oostendorp), to compare living standards, we have to deflate wages using Purchasing Power Parity (PPP) instead of exchange rates for the US dollars (It seems to me that their data is in local currency, rather than in USD as the example above). However, it is not clear to me how we adjust these salaries to a common year, say 2009.
Is it correct to do the following to my data above? Or is there a better way to compare salaries over countries and time to a common year? I use World Bank Indicator (http://data.worldbank.org/indicator) to compute things.
First, we multiply the USD salary with their corresponding LCU/USD exchange rate [Indicator: "Official exchange rate (LCU per US$, period average)"]
Then, we divide by the PPP-correction [Indicator: "PPP conversion factor, GDP (LCU per international $)"]
To adjust across time, then we multiply the result by ratio of GDP per capita, PPP between the common year (2009) and the year the data is collected (2008) [Indicator: "GDP per capita, PPP (current international $)"]
I would greatly appreciate any help.