Using the IEA IDB Analyzer
This presentation is the property of its rightful owner.
Sponsored Links
1 / 52

Using the IEA IDB Analyzer Correlations & Regression PowerPoint PPT Presentation


  • 67 Views
  • Uploaded on
  • Presentation posted in: General

Using the IEA IDB Analyzer Correlations & Regression. Table of content. Correlations Settings for the Analysis Running the Analysis Compare SPSS Output and International Report Output in MS Excel Regression Linear Regression Model Settings for the Analysis Running the Analysis

Download Presentation

Using the IEA IDB Analyzer Correlations & Regression

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Using the IEA IDB Analyzer

Correlations & Regression


Table of content

  • Correlations

    • Settings for the Analysis

    • Running the Analysis

    • Compare SPSS Output and International Report

    • Output in MS Excel

  • Regression

    • Linear Regression Model

    • Settings for the Analysis

    • Running the Analysis

    • Compare SPSS Output and International Report

    • Output in MS Excel

  • Hands-On Training


Table of content

  • Correlations

    • Settings for the Analysis

    • Running the Analysis

    • Compare SPSS Output and International Report

    • Output in MS Excel

  • Regression

    • Linear Regression Model

    • Settings for the Analysis

    • Running the Analysis

    • Compare SPSS Output and International Report

    • Output in MS Excel

  • Hands-On Training


Calculating Correlations

  • Choose variable(s) to be analyzed

  • Load the SPSS Analysis File

  • Choose Correlations as analysis type (some settings will be done automatically with respect to the datafile and the analysis method chosen)

  • Select Variables from the datafile to be analyzed as Analysis Variables

  • Define location and name of the Output Files

  • Start SPSS and run analysis


Select Variable of Interest

Student Questionnaire, Q14A-F, p. 13

Variables of Interest: PARTCOM PVCIV01-05


The Analysis File

  • The analysis file needs to be loaded from the respective directory

  • Countries in the example analysis file:

    • Austria

    • Belgium (Flemish)

    • Bulgaria

    • Denmark

    • England

    • Estonia

    • Finland


Correlations - Preparation

  • Select Analysis File:C:\ICCS2009\Work\ICG_ISG_INTC2.sav

  • Select Analysis Type: Correlations

  • Select Analysis Variables:PARTCOM(Students’ civic participation in the wider community)

  • Select Achievement Variables:PVICIV01-05 (Table 5.09 from ICCS2009 International report, first column)


Correlations - Details

Select Analysis FileC:\ICCS2009\Work\ICG_ISG_INTC2.sav


Correlations - Details

1) Select Correlations 2) Check Exclude Missing from Analysis 3) Check With Achievement Scores


Correlations - Details

IDCNTRY

TOTWGTS

JKZONES


Correlations - Details

Search for PARTCOM


Correlations - Details

Search results will be displayed


Correlations - Details

Highlight variable

Use arrow key to add variable to analysis


Correlations - Details


Correlations - Details

Highlight variable

Use arrow key to add variable to analysis


Correlations - Details

Define path and filename for output:“C:\ICCS2009\Work\Table_5_09.*”

Change number of decimals to “1”


Correlations - Details

  • The IDB Analyzer creates SPSS Syntax and starts SPSS

  • In SPSS Syntax Editor Choose: Run > All


Correlations - Outcome

  • As a result the IDB Analyzer creates the following in the working directory (C:\ICCS2009\Work\):

    • SPSS Syntax file – contains the syntax with the commands (*.sps)

    • SPSS Data file – contains statistics from the analysis (*.sav)

    • MS Excel Output file – contains statistics from the analysis (*.xls)


Correlations – SPSS Output


Correlations – Excel Output


Correlations – Excel Output

Achievement Scores

Mean Achievement

List of Countries

Sum of Weights

S.E. of Mean Achievement


Correlations – Excel Output

Correlation of PV with itself

S.E. of Correlation

Standard Deviation of Mean Achievement

S.E. of Standard Deviation of Mean Achievement


Correlations – Excel Output

S.E. of Mean of Variable

S.E. of Standard Deviation of Mean of Variable

Variable Name of Second Variable

Mean of Variable (here: Country Mean)

Standard Deviation of Mean of Variable


Correlations – Excel Output

Correlation of variable 1 with variable 2(here: Achievement with Participation in Community)

S.E. of Correlation


Correlations – Excel Output


Table of content

  • Correlations

    • Settings for the Analysis

    • Running the Analysis

    • Compare SPSS Output and International Report

    • Output in MS Excel

  • Regression

    • Linear Regression Model

    • Settings for the Analysis

    • Running the Analysis

    • Compare SPSS Output and International Report

    • Output in MS Excel

  • Hands-On Training


Table of content

  • Correlations

    • Settings for the Analysis

    • Running the Analysis

    • Compare SPSS Output and International Report

    • Output in MS Excel

  • Regression

    • Linear Regression Model

    • Settings for the Analysis

    • Running the Analysis

    • Compare SPSS Output and International Report

    • Output in MS Excel

  • Hands-On Training


Linear Regression Model


Linear Regression Model

  • yis the dependent variable – here: estimated mean of all 5 plausible values

  • x is the independent variable

  • ß0is the intercept (value of ywhen x is zero)

  • ß1 is the slope (change in yfor each unit increase in x)

x

=

+

×

y

β

β

0

1


Computing Regression

  • Can be used to calculate regression coefficients and their (jackknifed) standard errors for the ICCS background variables

  • Uses the jackknifing procedure and therefore considers the sampling method used in ICCS

  • Makes use of the variables JKZONE and JKREP


Computing Regression

  • Choose variable to be analyzed

  • Load the SPSS Analysis File

  • Choose Regression as analysis type (some settings will be done automatically)

  • Select Variables from the datafile to be analyzed as Analysis Variable AND/OR Select the plausible values as Achievement Scores

  • Define location and name of the Output Files

  • Start SPSS and run analysis


Recoding variables

  • Some tables might display data differently than in the data files

  • E.g., table 7.1 has been calculated using dummy recoded information of the students‘ immigration background (variable name in the datafile is IMMIG)

  • For replication of the table, the information from the variable IMMIG needs to be recoded in SPSS and added as a new variable to the datafile before running the analysis


Dummy Coding for Regression

IMMIG  Reg01IMMIG


Dummy Coding for Regression

  • IMMIG values:

0

1

1

System Missing


SPSS: Dummy Coding for Regression

Menu: TRANSFORM  Recode into Different Variables...


SPSS: Dummy Coding for Regression

Menu: TRANSFORM  Recode into Different Variables...

1  0

2  1

3  1

ELSE  SYSMISS


Linear Regression Model

Predictor variable: Reg01IMMIG

x

=

+

×

y

β

β

0

1

Mean achievement for native students

Difference between mean achieve-ment of native and mean achieve-ment of non-native students


The Analysis File

  • The analysis file needs to be loaded from the respective directory

  • Countries in the example analysis file:

    • Austria

    • Belgium (Flemish)

    • Bulgaria

    • Denmark

    • England

    • Estonia

    • Finland


Computing Regression

  • Select data file:C:\ICCS2009\Work\ICG_ISG_INTC2_Reg.sav

  • Analysis Type:Regression

  • Grouping Variable:IDCNTRY

  • Analysis Variable:Reg01IMMIG

  • Achievement Scores:PVICIV01-05 (Table 7.1, first column from ICCS2009 International report)


Regression - Details

C:\ICCS2009\Work\ICG_ISG_INTC2.sav

1) Select Regression2) Check Exclude Missing from Analysis3) Check With Achievement Scores

IDCNTRY

Reg01IMMIG

PVICIV01-05

Change the number of decimals to 2

TOTWGTS

JKZONES

C:\ICCS2009\Work\Table_7_1.*


Regression - Details

  • The IDB Analyzer creates SPSS Syntax and starts SPSS

  • In SPSS Syntax Editor Choose: Run > All


Regression - Outcome

  • As a result IDB Analyzer creates the following in the working directory (C:\ICCS2009\Work):

    • SPSS Syntax file – contains the syntax with the commands

    • SPSS Data file – contains statistics from the analysis

    • MS Excel Output file – contains statistics from the analysis


Regression – SPSS Output

Number of Cases

S.E. of Intercept

Multiple R-Squared

Intercept: Mean Achievement of Native Students


Regression – SPSS Output

Estimate of Regression Coefficient

S.E. of Regression Coefficient

T-Statistics of Regression Coefficient


Regression – SPSS Output

ABS (-1.3) < 1.96

In Bulgaria the difference in civic knowledge between native students and non-native students is NOT significant.


Regression – SPSS Output

ABS (-8.9) > 1.96

In Austria the difference in civic knowledge between native students and non-native students IS significant.


Regression – SPSS Output

Differences in Draft Table 7.1 of Int. Report are incorrect


Regression – SPSS Output

x

=

-

516,2

×

y

56,6

Predictor variable: Reg01IMMIG

Mean achievement for native students

Difference between mean achieve-ment of native and mean achieve-ment of non-native students


Thank you for your attention!

Any Questions?


Table of content

  • Correlations

    • Settings for the Analysis

    • Running the Analysis

    • Compare SPSS Output and International Report

    • Output in MS Excel

  • Regression

    • Linear regression Model

    • Settings for the Analysis

    • Running the Analysis

    • Compare SPSS Output and International Report

    • Output in MS Excel

  • Hands-On Training


Table of content

  • Correlations

    • Settings for the Analysis

    • Running the Analysis

    • Compare SPSS Output and International Report

    • Output in MS Excel

  • Regression

    • Linear regression Model

    • Settings for the Analysis

    • Running the Analysis

    • Compare SPSS Output and International Report

    • Output in MS Excel

  • Hands-On Training


Hands-On Training

  • Re-produce the example using your country data- Correlation of students’ participation in the wider community with civic and citizenship achievement (PVCIV01-05 with PARTCOM)

    and/or

  • Re-produce the example using your country data- Regression of students’ immigration status on civic and citizenship achievement of (IMMIG [recoded] on PVCIV01-05)

    and/or

  • Practice with own selected variables following these analysis steps


  • Login