Referat

Document Sample
Referat Powered By Docstoc
					Die demographische
Situation in Europa – Ein
Ländervergleich
  HS: Datenanalyse
  Prof. M. Häder
  Referentin: Bianka Gäbler
  15.11.06
Wiederholung:
Was ist eine Datenanalyse?
Phasen der Datenauswertung:
1. Kodierung und Datenübertragung
2. Fehlerkontrolle und –bereinigung;
   Ausschluss von „missing values“
3. Rekodierung und Variablentransformation
4. Statistische Analyse von Verteilungen
   und Zusammenhängen
Datenübertragung - Beispiel

 V1   Welchen Schulabschluss haben Sie?
         Geben Sie nur den höchsten an.


 kein Abschluss                           (1)
 Volks- oder Hauptschulabschluss          (2)
 Mittlere Reife oder Realschulabschluss   (3)
 Abitur oder Hochschulreife               (4)
 verweigert                               (9)
ESS: Teilnehmende Länder
ESS 1                  ESS 2
  AT Austria            AT Austria
  BE Belgium            BE Belgium
  CH Switzerland        CH Switzerland
  CZ Czech Republic     CZ Czech Republic
  DE Germany            DE Germany
  DK Denmark            DK Denmark
  ES Spain              EE Estonia
  FI Finland            ES Spain
  FR France             FI Finland
  GB United Kingdom     FR France
  GR Greece             GB United Kingdom
  HU Hungary            GR Greece
  IE Ireland            HU Hungary
  IL Israel             IE Ireland
  IT Italy              IS Iceland
  LU Luxembourg         LU Luxembourg
  NL Netherlands        NL Netherlands
  NO Norway             NO Norway
  PL Poland             PL Poland
  PT Portugal           PT Portugal
  SE Sweden             SE Sweden
  SI Slovenia           SI Slovenia
                         SK Slovakia
                         UA Ukraine
Demographische Daten F1 – F65
Dataset: ESS2-2004, ed. 2.0                   Gender of twelfth person in household
Gender, Year of birth and Household           Gender of thirteenth person in
   grid                                        household
                                              Gender of fourteenth person in
   Number of people living regularly as       household
    member of household                       Gender of fifteenth person in
   Gender                                     household
   Gender of second person in household      Gender of sixteenth person in
   Gender of third person in household        household
   Gender of fourth person in household      Year of birth
   Gender of fifth person in household       Year of birth of second person in
                                               household
   Gender of sixth person in household       Year of birth of third person in
   Gender of seventh person in                household
    household                                 Year of birth of fourth person in
   Gender of eighth person in household       household
   Gender of ninth person in household       Year of birth of fifth person in
   Gender of tenth person in household        household
   Gender of eleventh person in              Year of birth of sixth person in
    household                                  household
                                              Year of birth of seventh person in
                                               household
Demographische Daten F1 – F65
   Year of birth of eighth person in          Fifth person in household: Relationship
    household                                   to respondent
   Year of birth of ninth person in           Sixth person in household:
    household                                   Relationship to respondent
   Year of birth of tenth person in           Seventh person in household:
    household                                   Relationship to respondent
   Year of birth of eleventh person in        Eighth person in household:
    household                                   Relationship to respondent
   Year of birth of twelfth person in         Ninth person in household:
    household                                   Relationship to respondent
   Year of birth of thirteenth person in      Tenth person in household:
    household                                   Relationship to respondent
   Year of birth of fourteenth person in      Eleventh person in household:
    household                                   Relationship to respondent
   Year of birth of fifteenth person in       Twelfth person in household:
    household                                   Relationship to respondent
   Year of birth of sixteenth person in       Thirteenth person in household:
    household                                   Relationship to respondent
   Second person in household:                Fourteenth person in household:
    Relationship to respondent                  Relationship to respondent
   Third person in household:                 Fifteenth person in household:
    Relationship to respondent                  Relationship to respondent
   Fourth person in household:                Sixteenth person in household:
    Relationship to respondent                  Relationship to respondent
Demographische Daten F1 – F65
Socio-demographics                               Highest level of education,
                                                  Luxembourg
   Domicile, respondent's description           Highest level of education,
   Dwelling owned by any household               Netherlands
    member                                       Highest level of education, Norway
   Number of rooms household have use           Highest level of education, Poland
    of (not kitchens/bathrooms/toilets)          Highest level of education, Portugal
   Highest level of education                   Highest level of education, Sweden
   Highest level of education, Belgium          Highest level of education, Slovakia
   Highest level of education, Switzerland      Highest level of education, Ukraine
   Highest level of education, Czech            Field or subject, highest qualification
    Republic                                     Years of full-time education completed
   Highest level of education, Germany          Doing last 7 days: paid work
   Highest level of education, Denmark          Doing last 7 days: education
   Highest level of education, Estonia          Doing last 7 days: unemployed,
   Highest level of education, Spain             actively looking for job
   Highest level of education, France           Doing last 7 days: unemployed, not
   Highest level of education, Greece            actively looking for job
   Highest level of education, Hungary          Doing last 7 days: permanently sick or
   Highest level of education, Ireland           disabled
Demographische Daten F1 – F65
   Doing last 7 days: retired                  Establishment size
   Doing last 7 days: community or             Responsible for supervising other
    military service                             employees
   Doing last 7 days: housework, looking       Number of people responsible for in
    after children, others                       job
   Doing last 7 days: other                    Allowed to decide how daily work is
   Doing last 7 days: don't know                organised
   Doing last 7 days: refusal                  Allowed to influence policy decisions
                                                 about activities of organisation
   Doing last 7 days: no answer                Allowed to choose/change pace of
   Interviewer code, one/ more than one         work
    doing last 7 days                           Total contracted hours per week in
   Main activity last 7 days                    main job overtime excluded
   Interviewer code, main activity last 7      Total hours normally worked per week
    days                                         in main job overtime included
   Control paid work last 7 days               Occupation, ISCO88 (com)
   Ever had a paid job                         Industry, NACE rev.1.1
   Year last in paid job                       Paid work in another country, period
   Employment relation                          more than 6 months last 10 years
   Number of employees respondent has          Ever unemployed and seeking work for
   Employment contract unlimited or             a period more than three months
    limited duration                            Any period of unemployment and work
                                                 seeking lasted 12 months or more
                                                Any period of unemployment and work
                                                 seeking within last 5 years
Demographische Daten F1 – F65
   Member of trade union or similar            Partner doing last 7 days: housework,
    organisation                                 looking after children, others
   Main source of household income             Partner doing last 7 days: other
   Household's total net income, all           Partner doing last 7 days: don't know
    sources                                     Partner doing last 7 days: not
   Porportion of household income               applicable
    respondent provides                         Partner doing last 7 days: refusal
   Feeling about household's income            Partner doing last 7 days: no answer
    nowadays                                    Interviewer code, one/ more than one
   Borrow money to make ends meet,              doing partner last 7 days
    difficult or easy                           Partner's main activity last 7 days
   Lives with husband/wife/partner at F4       Partner, control paid work last 7 days
   Partner's highest level of education        Occupation partner, ISCO88 (com)
   Partner doing last 7 days: paid work        Partner's employment relation
   Partner doing last 7 days: education        Number of employees partner has
   Partner doing last 7 days:                  Partner responsible for supervising
    unemployed, actively looking for job         other employees
   Partner doing last 7 days:                  Number of people partner responsible
    unemployed, not actively looking for         for in job
    job
   Partner doing last 7 days: permanently      Partner allowed to decide how daily
    sick or disabled                             work is organised
   Partner doing last 7 days: retired
   Partner doing last 7 days: community
    or military service
Demographische Daten F1 - F65
   Partner is allowed to influence policy      Mother responsible for supervising
    decisions about activities of                other employees
    organisation                                Mother's occupation when respondent
   Hours normally worked a week in main         14
    job overtime included, partner              Improve knowledge/skills:
   Father's highest level of education          course/lecture/conference, last 12
   Father's employment status when              months
    respondent 14                               Legal marital status
   Number of employees father had              Legal marital status (France)
   Father responsible for supervising          Currently living with husband/wife
    other employees                             Currently living with another partner
   Father's occupation when respondent          than husband/wife
    14                                          Currently living with partner
   Mother's highest level of education
   Mother's employment status when
    respondent 14
   Number of employees mother had
Fragebogen
Fragebogen
Variablen
Datenanalyse mit F1 –
        F65
Mittelwert, Minimum und Maximum
Anzahl der   Member of household
Mitglieder




                                   Länder   Länder
Standardabweichung
                           Member of household
Standardabweichung

  2,5
                                                                2,073
    2                                                   1,675
                                                1,515                           1,532
        1,291           1,396   1,395   1,372                           1,358
  1,5            1,28

    1

  0,5

    0
                                                                                        Länder
         CZ      DE      ES      FR      GR      HU      IE      IL      SE      SI
Boxplot
             Member of household
Anzahl der
Mitglieder




                                   Länder
Vergleich des Wohnortes mit einem
Kreisdiagramm
Deutschland                    Spanien
                            big city
       0%
                                                 big city
                               1%
       2%                   suburbs
              21%             3%          22%    suburbs
 25%
                            sm all city
                                                 sm all city
                      39%
                12%                         8%
                            country
                                                 country
                            village
                                                 village
                            countryside
                                      27%        countryside
       40%

                            no answ er           no answ er
Histogramm
Bsp: Einkommen in Deutschland                                         Approximate
                                                                      MONTHLY


Anzahl                                                         J      Less than €150
der                                                            R       €150 - €300
Befagten   700
                                                               C       €300 - €500
                                                               M       €500 - €1000
           600
                                                               F      €1000 - €1500
                                                               S      €1500 - €2000
           500
                                                               K      €2000 - €2500

           400                                                 P      €2500 - €3000
                                                                           me
                                                               E ink o m €5000 ns k
                                                               D   €3000 -
                                                               sen
           300                                                 H      €5000 - €7500
                                                               U      €7500 - €10000
           200                                                 N      €10000 or more


           100

             0                                                     N = 2919
                 J   R C M   F   S   K P   D   H U N no
                                                   a ns we r
Einkommen - Ländervergleich
 40
 35
 30
 25                                                              CZ
 20                                                              DE
 15                                                              ES
 10
  5
  0
        J      R   C   M   F   S   K   P   D   H   U   N no
                                                        answer
Angaben in %
Gender
Angaben in %


     60
     50
     40
                                                            male
     30
                                                            female
     20
                                                            no answer
     10
     0
          CZ   DE   ES   FR   GR   HU   IE   IL   SE   SI
Frage: highest level of education




Not completed primary education         = kein Abschluss
Primary or first stage of basic         = Grundschule
Lower secondary or second stage of basic = Haupt- oder Realschule
Upper secondary                         = Gymnasium oder Fachhochschulreife
Post secondary, non-tertiary            = Gymnasium oder Fachhochschulreife + Lehre
First stage of tertiary                  = Master, Diplom usw.
Second stage of tertiary                 = Promotion / Habilitation
Ausbildung
 100%


 80%                                               no answer
                                                   Doktor
 60%                                               Diplom
                                                   Abitur+Lehre
                                                   Abitur
 40%                                               Mittelschule
                                                   Grundschule
 20%                                               Kein Abschluss


  0%
        CZ   DE   ES   FR   GR HU   IE   SE   SI
Bildung – Vergleich ESS 1 und ESS 2

 100%                                             no answer
  80%                                             Doktor
                                                  Diplom
  60%
                                                  Abitur+Lehre
  40%                                             Abitur
  20%                                             Mittelschule
                                                  Grundschule
  0%
        CZ1 CZ2 DE1 DE2 ES1 ES2 IE1 IE2 SE1 SE2   Kein Abschluss
Berufstätigkeit
Frage: What have you been doing fo the last 7 days?
Angaben in %       CZ     DE     ES     FR     GR      HU     IE     SE     SI

bezahlte Arbeit    9,0    11,5   1,8    0,9    2,0     12,4   7,8    2,6    14,2
Ausbildung         0,9    2,0    0,5    0,1    0,6     2,0    1,4    0,8    4,0
arbeitslos und     0,5    1,6     -     0,1    0,2     0,7    0,2    0,2    0,5
arbeitssuchend
arbeitslos und     0,2    0,2     -      -     0       0,3    0,1    0,1    0,3
nicht
arbeitssuchend
Arbeitsunfähig     1,0    0,5     -     0,1    0,1     1,1    0,2    0,3    0,3
Rentner            4,7    4,0    0,1    0,4    1,5     6,6    2,2    0,6    6,6


Hausfrau /-mann    2,2    0,1    0,5    0,6    1,0     3,3    3,3    0,3    2,6
Anderes            0,1     -      -     0,2        -   0,1    0,1    0,1    0,2

nicht zutreffend   80,3   75,5   95,6   97,7   94,7    73,0   84,8   95,0   69,5
keine Antwort      1,1    0,1    1,5     -         -   0,5     -     0,2    1,8
Korrelationen zweier Variablen
   Bildung + Arbeit                                               (gewichtet
                                                                    mit DWEIGHT)
    (Berechnung von Cramer‘s V)

     CZ   V = 0,226
     DE   V = 0,188
     IE   V = 0,308

   Bildung des Interviewten und Bildung des Partners

    (Berechnung des Rangkorrelationskoeffizienten nach Spearman)

     CZ   R = 0,317
     DE   R = 0,326
     IE   R = 0,559

   Anzahl der im Haushalt lebenden Personen + Anzahl der Zimmer im
    Haushalt

    (Berechung des Korrelationskoeffizienten nach Pearson)

     CZ   rxy = 0,373
     DE   rxy = 0,545
     IE   rxy = 0,204
Literatur
   http://www.europeansocialsurvey.org

   http://ess.nsd.uib.no

   Diekmann, Andreas: Empirische Sozialforschung.
    Grundlagen, Methoden, Anwendungen, Rowohlts
    Enzyklopädie im Rowohlt Taschenbuch Verlag,
    Reinbek, 2004

   Diaz – Bone, Rainer: Statistik für Soziologen,
    UVK Verlagsgesellschaft mbH, Konstanz, 2006

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:8
posted:1/5/2013
language:German
pages:27