Some Statistical Questions

noodler

I am just toying with some CSO figures with regards wages in the Republic during the 90s and and up to as recent as possible whcih gives me this result:

http://www.cso.ie/px/pxeirestat/Dialog/varval.asp?ma=QIJA1&ti=Tables+1,2+and+3:+Average+Earnings+and+Hours+Worked+by+Sex,+Broad+Industrial+Sector,+Year+and+Statistic&path=../Database/Eirestat/Earnings%20Employment%20and%20Productivity%20in%20Industry/&lang=1

I guess my question is on the categories. I would prefer a very broad set of figures and the above only has Industrial (so I guess I still need PS and Services?) but does anybody know what the NACDE 1-4 classification alludes to?

I can't get much from their site without a subscription.

Time Magazine

Firstly, the QNHS provides microdata from 1997 on. It's the main file for analysing wages here, and you can request access to it from the ISSDA.

Secondly, from my reading of it, NACE 1-4 essentially means "all workers" and the other option is "the industrial wage".

noodler

Isn't that only every four years?

Scratch that, I was thinking about the HSB.

All I want is annual wage figures for Ireland to show the general trend during the Celtic Tiger, can't even find these. I'll have to give them an email as you say then. Thanks.

Flamed Diving

noodler

Thank you very much, thats essentially all I want.

Where did you get that? I would like to find the relevant table/excel file for that.

Also, does that simply mean private sector or is that everything?

Flamed Diving

noodler wrote: »

Thank you very much, thats essentially all I want.

Where did you get that? I would like to find the relevant table/excel file for that.

Also, does that simply mean private sector or is that everything?

CSO>Database Direct>CSO Main Data Dissemination Service>Labour Market and Earnings>Earnings>Earnings Employment and Productivity in Industry:

Tables 1,2 and 3: Average Earnings and Hours Worked by Sex, Broad Industrial Sector, Year and Statistic (1996 - 2006)

http://www.cso.ie/px/pxeirestat/Dialog/varval.asp?ma=QIJA1&ti=Tables+1,2+and+3:+Average+Earnings+and+Hours+Worked+by+Sex,+Broad+Industrial+Sector,+Year+and+Statistic&path=../Database/Eirestat/Earnings%20Employment%20and%20Productivity%20in%20Industry/&lang=1


All of these:

http://ec.europa.eu/competition/mergers/cases/index/nace_all.html

noodler

Oh sorry, thats what I have in my OP. Thanks though, does it exclude anything then?

Flamed Diving

It might, although this simply excludes household work:

http://nui.epp.eurostat.ec.europa.eu/nui/show.do?dataset=earn_gr_nace2&lang=en

but doesn't have the time span. You might have to make do with the CSO data, they cover a pretty decent range.

noodler

The CSO data is fine to be honest, thanks.

One final question before I let you go back to your Sunday evening in peace.

The graph you posted here - I can not for the life of me reproduce that with the CSO graph options - did you make that yourself?

Flamed Diving

Don't use their graph options, just download the Excel file and use that. If you don't know how to make a graph with Excel, then I assume there must be tutorials on Youtube, it's really easy. If you don't have Excel, then I will make one for you. It only takes me a second.

noodler

I haven't got it on this laptop but I do in work so I'll sort it tomorrow.

Thanks for your input.

Flamed Diving

Oh, you know about Open Office, right?

http://www.openoffice.org/

noodler

Flamed Diving wrote: »

Oh, you know about Open Office, right?

http://www.openoffice.org/

Yeah thanks, I have been meaning to just buy MS Office and stop being a cheap SOB though!
Haven't used open office for anything other than word files but I will keep it in mind!

Tah!

noodler

Time Magazine wrote: »

Firstly, the QNHS provides microdata from 1997 on. It's the main file for analysing wages here, and you can request access to it from the ISSDA.

Secondly, from my reading of it, NACE 1-4 essentially means "all workers" and the other option is "the industrial wage".

What about figures from 2007 onwards? Do the QNHS have these or are thay not available yet?

Time Magazine

I'm not sure where the micro data stops (call the Data Archive maybe, link), but summary stats are certainly available for as late as Q4 2009.

noodler

I'll give them a call. Those summary stats you linked to are just emplyoment figures, not wages unfortunately.