File talk:Unit labor costs.svg

From Wikimedia Commons, the free media repository
Jump to navigation Jump to search

{Citation needed}

[edit]

@Spitzl and Lommes: Both sources in the description are discontinued in 2012 and in the plot there are data from 2015. OECD sends to new one http://stats.oecd.org/Index.aspx?DataSetCode=PDBI_I4# but I get a bit different numbers: Subject: Unit Labour Cost; Activity: Total, Time 2000-15, Measure: Index I get for Germany 2015/2010 108.8/96.6 = 1.13 in the plot about 1.15, Ireland has decreased 77.5/86; Italy 102.5/74.7 = 1.37 in the plot 1.29. After changing Activity to Industry there are even stronger differences Germany 105/106, Italy 106/79 = 1.34. There should be also data for Euro area and for UE. PawełS (talk) 16:20, 14 March 2018 (UTC)[reply]

Dear Paweł, thanx for your remark. Unfortunately there is no way of linking to a specific query result of the OECD database (at least not that I know of). So I couldn't provide a direct link. The graph is based on "Unit labour costs and labour productivity (employment based), Total economy"; Subject: "Unit Labor Costs"; Measure: "Index"; Frequency: "Annual"; Unit: "Index, 2010=100". Using this setting, the OECD database provides data for the years 1949-2017. Here is a step-by-step guide to the data:

  1. Follow this link http://stats.oecd.org/Index.aspx?DataSetCode=ULC_EEQ
  2. Change the "Measure" drop-down menu from "Quarterly change..." to "Index"
  3. Click on "Frequency" and set the date range to "Annual" 2000-2017 (uncheck "Quarterly")

Please let me know if this is of any help. Please note that I changed the index from "2010=100" to "2000=100" before drawing the graph, to match the time period of the debt crisis. Besides that I did not make any changes. Btw, I am about to upload an updated version of the graph. Since my last edit, the OECD not only published data for they years 2016 and 2017, the authors also made (minor) changes to existing data for some countries. I'll take up your suggestion and also add the EU 19 Area. (There is no data for the entire EU). Kind regards, --Spitzl (talk) 20:45, 17 March 2018 (UTC)[reply]

Thanks for the update and the whole plot. I still get different numbers for Italy 2015/2000 103.8/75.2 = 1.38. In the plot is the middle? European decimal coma, not English point. PawełS (talk) 23:16, 18 March 2018 (UTC)[reply]
Ok, I think I know see your point. Your figures for Italy are correct. Please keep in mind though that the graph is normalized. Unit labor costs of all countries presented in the graph were NOT the same in 2000. I just made it all start at 1.0 to show how each country's unit labor costs developed over time compared to the other countries. This means, 75.2 for Italy in the year 2000 is shown as 1.0 just like the other starting points (Greece 67.5; Spain 75.3; Italy 75.2; Ireland 83.5; Portugal 81.9; France 81.3; Germany 94.6; OECD 86.8; Euro Area 83.4). Any idea to prevent such misunderstandings? --Spitzl (talk) 19:17, 20 March 2018 (UTC)[reply]
PS: You are of course right regarding the decimal coma. I'll correct this in the next update. --Spitzl (talk) 19:18, 20 March 2018 (UTC)[reply]
,,This means, 75.2 for Italy in the year 2000 is shown as 1.0 " To get 1.0 one has to divide 75.2, and values form others years, by the value from 2000, to save ratios between years because normalization is about showing proportions. In en:Normalization (statistics) all formulas use division. The rate of growth between years should be the same for normalized numbers and raw ones. PawełS (talk) 17:45, 21 March 2018 (UTC)[reply]
Dear PawełS, sorry for the delay and a special thanx for pointing out this error. You are absolutely right. Here is the updated version. It should be ok now. --Spitzl (talk) 22:03, 23 June 2018 (UTC)[reply]